Issue: DB problem by upgrading

Issue Tools
- View Changes

August 20, 2017 6:03 AM

Ecstasy

New Member

DB problem by upgrading

Hello,

i want to upgrade my VaultWiki installation. I got the Version 4.0.15 and want to upgrade it to 4.0.19.

The Upgrade Script brings an error message:

Code:

Upgrading to 4.0.17
Step 15

Updating data in table: vw_attachmentfile

Warnung (PHP Warning): Missing argument 2 for vw_DB_MySQL_Model::eq(), called in ..../vault/install/lib/upgradepath/steps/4/0/17/base/vw.php on line 790 and defined in ..../vault/core/model/db/mysql/vw.php (Zeile 698)

Warnung (PHP Warning): mysqli_query(): (42000/1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 in ..../includes/class_core.php (Zeile 1394)Datenbankfehler in vBulletin 4.2.3:

Invalid SQL:
SELECT filedata,file_flags + 0 AS `file_flags` FROM `vw_attachmentfile` WHERE 1 =;

MySQL-Fehler  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Fehler-Nr.    : 1064
Fehler-Zeit   : Sunday, 20.08.2017 @ 12:04:19
Datum         : Sunday, 20.08.2017 @ 12:04:19
Skript        : [url]http://herzogtum-falkenstein.de/vault/install/index.php[/url]
Referrer      : [url]http://herzogtum-falkenstein.de//vault/install/index.php[/url]
Klassenname   : vB_Database_MySQLi
MySQL-Version : 5.6.33-0ubuntu0.14.04.1

Can you fix it?

Thank you very much
Greetings

Issue Details

Issue Number 5197

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.17

Fixed Version 4.0.19

Milestone (none)

Software DependencyvBulletin 4.x

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

August 20, 2017 10:04 AM
pegasus

VaultWiki Team
This occurs while upgrading vBulletin past 4.0.17 while attachments are stored in the database, rather than as files.
In vault/install/lib/upgradepath/steps/4/0/17/base/vw.php, find:

Code:

'where' => vw_DB::get()->query()->eq($file['attachfileid']),

Replace with:

Code:

'where' => vw_DB::get()->query()->eq('attachfileid', $file['attachfileid']),
Reply

August 20, 2017 10:43 AM

Ecstasy

New Member

Thank you very much for your help.

Now, i got a problem at the next step

Code:

Upgrading to 4.0.17
Step 16

Updating data in table: vw_route

Fatal error: Unsupported operand types in /var/www/vhosts/herzogtum-falkenstein.de/herzogtum-falkenstein/vault/core/controller/dm/attach/thumb/vw.php on line 340
Fatal Error: Unsupported operand types in [path]/vault/core/controller/dm/attach/thumb/vw.php at line 340

August 20, 2017 2:02 PM

pegasus

VaultWiki Team

Your database appears to be damaged, since this step is deleting stale attachment thumbnails but there is no record that any existing attachments are using disk/db space.

Run the following MySQL queries manually to repair the data:

Code:

INSERT INTO datastore (title, `data`)
VALUES ('vw_attach_usage', 0)
ON DUPLICATE KEY UPDATE `data` = 0;

UPDATE datastore
SET `data` = `data` + (SELECT SUM(filesize) AS `data` FROM vw_attachmentfile LIMIT 1)
WHERE title = 'vw_attach_usage'
LIMIT 1;

UPDATE datastore
SET `data` = `data` + (SELECT SUM(filesize) AS `data` FROM vw_attachmentthumb LIMIT 1)
WHERE title = 'vw_attach_usage'
LIMIT 1;

+ Reply

All times are GMT -4. The time now is 3:29 AM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: DB problem by upgrading

Issue Tools