Issue: VW4 Upgrade db error on Step 8

Issue Tools
- View Changes

September 30, 2015 1:27 AM

Kaelon

Regular Member

VW4 Upgrade db error on Step 8

On the upgrade from VW3 to VW4, on Step 8 (both auto and manual), I encounter the following Database error:

Code:

Database error in vBulletin 3.8.9:

Invalid SQL:
SELECT itemtypeid,itemid FROM `vw_route` WHERE routeid =;

MySQL Error   : 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
Error Number  : 1064
Request Date  : Wednesday, September 30th 2015 @ 12:32:03 AM
Error Date    : Wednesday, September 30th 2015 @ 12:32:04 AM
Script        : [url]http://www.domain.com/forums/vault/install/index.php[/url]
Referrer      : [url]http://www.domain.com/forums/vault/install/index.php[/url]
IP Address    : 108.49.103.253
Username      : Kaelon
Classname     : vB_Database_MySQLi
MySQL Version : 5.1.70-log

I tried modifying /vault/core/controller/install/db/create/route/vw.php to find:

Code:

'name' => 'vw_route',

and add after:

Code:

'engine' => 'MyISAM',

But this didn't seem to make a difference. Any other thoughts as to what might be going wrong here?

This happened during the original auto install when I had specified the path to the wiki-attachments directory. Is there a way to reset this install if it's broken?

Help! Thanks.

Issue Details

Issue Number 4386

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.4

Fixed Version 4.0.6

Milestone (none)

Software DependencyvBulletin 3.x

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

September 30, 2015 7:58 AM

pegasus

VaultWiki Team

Going by step numbers is meaningless in VaultWiki 4. Step numbers change all the time. Also since there is no direct upgrade from VW3 to VW4, I'm not sure whether you are using the installer, upgrading an old VW4 instance, or if you are using the VW3 importer.

You must post the complete contents of the progress window for us to know where the process stalled.

The database error above refers to a very generic query that occurs frequently in VW4. If there is a PHP backtrace to accompany the error, it would be very helpful.

If all else fails or you are not sure you can locate the additional information at this time, you may submit a request for Ticket Support service, so we can try it too and see what went wrong.

Reply
September 30, 2015 9:42 AM

Kaelon

Regular Member

Thanks, Pegasus. I was using the installer (auto-installer first), and when Step 8 crashed with the DB error, running it again actually starts it out immediately at Step 8. The progress window now only consists of Step 8 and the database error which appears immediately beneath it.

I will submit a Ticket Support service request and provide you with administrative access so that you can re-assess. Thanks so much for your help!

Reply
September 30, 2015 9:54 AM

Kaelon

Regular Member

I submitted ticket support, pegasus, but I'm not sure how to follow-up on my request (I'm not seeing the ticket appear on my Members Area). Please let me know where I can follow-up. Thanks!

Reply
October 1, 2015 11:23 AM

pegasus

VaultWiki Team

I was able to track down the problem to a major bug in the search index handler for vBulletin 3, the bug appeared in VW 4.0.4. I corrected the error on your site and posted a new build here for others who have trouble. VaultWiki 4 is now installed on your site.

Reply
October 1, 2015 11:30 AM

Kaelon

Regular Member

Thanks, Pegasus. After your installation, though, all threads are now coming up as blank pages. Any way you recommend that I troubleshoot this?

(Note: Disabling VaultWiki 4 allows threads to load and fixes this, but obviously, no VaultWiki.)

Reply
October 1, 2015 11:35 AM

pegasus

VaultWiki Team

I will have a look. Probably related to autolinks or character encodings.

Reply
October 1, 2015 11:35 AM

Kaelon

Regular Member

Thanks!

Reply

+ Reply

All times are GMT -4. The time now is 7:40 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: VW4 Upgrade db error on Step 8

Issue Tools