Update from 4.0.12 to 4.0.20

[DragonSigh]

Hello. I'm trying to update my VaultWiki from 4.0.12 to 4.0.20. Uploaded all the files and launched /vault/install/index.php and then I get this error:

Step 2

Updating data in table: vw_lastupdate

PHP Warning: mysqli_query(): (42S22/1054): Unknown column 'f.unresizable' in 'field list' in ..../includes/class_core.php on line 1386

PHP Warning: realpath(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/home/admin/web/MYSITE:/home/admin/tmp) in ..../includes/class_core.php on line 1084

Database error in vBulletin 4.2.5:

Invalid SQL:
SELECT `e`.*,`attachment`.*,`gi`.*,`l`.*,`ch`.*,`c`.*,`i`.*,`r`.*,`page`.*,`f`.`filesize` AS `filesize`,`f`.`dateline` AS `file_dateline`,`f`.`width` AS `width`,`f`.`height` AS `height`,`f`.`unresizable` AS `unresizable`,`f`.`extension` AS `extension`,`e`.`dateline` AS `attach_dateline`,`sub`.`subscribeid` AS `issubscribed`,`sub`.`notifytype` AS `subscribetype`,`sub`.`options` AS `subscribeoptions`,`mk`.`readtime`,`gi`.`userid` AS `group_userid`,`l`.`userid` AS `translate_userid`,`ch`.`userid` AS `chapter_userid`,`r`.`dateline` AS `edit_dateline`,`r`.`flags` + 0 AS `flags`,`r`.`parentid` AS `edit_parentid`,`page`.`pageid` FROM `vb_vw_page` `page`  LEFT JOIN `vb_vw_route` `i` ON (`page`.`pageid` = `i`.`itemid` AND `i`.`itemtypeid` = 1) 
 LEFT JOIN `vb_vw_counter` `c` ON (`c`.`routeid` = `i`.`routeid`) 
 LEFT JOIN `vb_vw_revision` `r` ON (`r`.`revisionid` = `page`.`revisionid`) 
 LEFT JOIN `vb_vw_chapter` `ch` ON (`page`.`pageid` = `ch`.`pageid`) 
 LEFT JOIN `vb_vw_langitem` `l` ON (`page`.`pageid` = `l`.`pageid`) 
 LEFT JOIN `vb_vw_teamitem` `gi` ON (`page`.`pageid` = `gi`.`pageid`) 
 LEFT JOIN `vb_vw_markread` `mk` ON (`mk`.`itemtypeid` = 1 AND `mk`.`itemid` = `page`.`pageid` AND `mk`.`userid` = 11) 
 LEFT JOIN `vb_vw_subscribe` `sub` ON (`sub`.`nodetypeid` = 1 AND `sub`.`nodeid` = `page`.`pageid` AND `sub`.`userid` = 11) 
 LEFT JOIN `vb_vw_attachment` `attachment` ON (`attachment`.`pageid` = `page`.`pageid`) 
 LEFT JOIN `vb_vw_attachmentedit` `e` ON (`e`.`attacheditid` = `attachment`.`attacheditid`) 
 LEFT JOIN `vb_vw_attachmentfile` `f` ON (`e`.`attachfileid` = `f`.`attachfileid`)   WHERE  `page`.`pageid` IN (152,161,183)  LIMIT 3;

MySQL Error   : Unknown column 'f.unresizable' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, October 18th 2017 @ 12:54:42 PM
Error Date    : Wednesday, October 18th 2017 @ 12:54:43 PM
Script        : [url]http://MYSITE/vault/install/index.php[/url]
Referrer      : [url]http://MYSITE/vault/install/index.php?step=1[/url]
IP Address    : IP
Username      : USER
Classname     : vB_Database_MySQLi
MySQL Version : 5.5.57-0+deb8u1
Server        : 178.32.13.220
User Agent    :

What should I do?

[pegasus]

In vault/core/controller/fetch/attach/vw.php, find and remove:

$prep['f']['fields']['unresizable'] => 'unresizable'

Also, your PHP and/or vBulletin installation is misconfigured. Your server has an open_basedir restriction in effect, but you have not defined a custom temporary file directory using php.ini upload_tmp_dir and/or you have not setup the safe directory in vBulletin Options > Server Settings and Optimization Options > Safe Mode Upload Enabled, and Safe Mode Temporary Directory.

[DragonSigh]

Thank you. The process progressed a bit, but stopped on a new error.

Upgrading to 4.0.17
Step 15

Updating data in table: vw_attachmentfile

PHP Warning: unpack(): Type C: not enough input, need 1, have 0 in ..../vault/core/model/image/structure/gif/vw.php on line 290

PHP Warning: reset() expects parameter 1 to be array, boolean given in ..../vault/core/model/image/structure/gif/vw.php on line 291

[pegasus]

This suggests that one of the wiki attachments on your site is a GIF file that ends abruptly in the middle of a GIF comment or GIF watermark, and your PHP version is less than 7.0.

In vault/core/model/image/structure/gif/vw.php, find:

	public function subblock_to_string($block)
	{

After it, add:

if (!strlen($block)) return '';

[DragonSigh]

Thanks but nothing has changed, still the same errors. PHP version is 5.6.30.
On PHP 7.1.10 it gives me the same errors.

[pegasus]

It does not make sense to me that a string could have a positive length or not be considered empty but still contain 0 characters. Please submit a private ticket so that we can look into this issue further: https://www.vaultwiki.org/members/?do=tickets