Issue: SELECT routeid,itemid FROM `vb4_vw_route` WHERE itemtypeid = 1 AND `itemid` IN ();

Issue Tools
- View Changes

February 24, 2016 1:25 PM

Alfa1

Distinguished Member

SELECT routeid,itemid FROM `vb4_vw_route` WHERE itemtypeid = 1 AND `itemid` IN ();

Import error:

Code:

Database error in vBulletin 3.8.7:

Invalid SQL:
SELECT routeid,itemid FROM `vb4_vw_route` WHERE itemtypeid = 1 AND  `itemid` IN ();

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, February 24th 2016 @ 07:21:08 PM
Error Date    : Wednesday, February 24th 2016 @ 07:21:09 PM
Script        : /admincp/wiki_cp.php?panel=impex&do=import&step=27&nostyle=1
Referrer      : /admincp/wiki_cp.php?panel=impex&do=import&step=26&nostyle=1&startat=1500

Issue Details

Issue Number 4554

Issue Type Bug

Project VaultWiki 4.x Series

Category Importing

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.8

Fixed Version 4.0.9

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)

February 24, 2016 1:42 PM
pegasus

VaultWiki Team
In the future, please try to copy the full contents of the progress window.

This error suggests to me that many wiki pages were not successfully imported. You will want to check your wiki when the import is done.

In vault/core/controller/import/handle/vw3/popularity/vw.php, find (2x):

Code:

$pagemap = $this->get_import_threadids(array_keys($update));

After each, add:

Code:

if (!$pagemap) return false;

There were numerous flaws in every importer variant, so the only option for a quick patch is to skip importing page view counts with the above edit.
Reply
February 24, 2016 7:29 PM

Alfa1

Distinguished Member

Well, that would be problematic. Some of our wiki articles have 800.000+ views. We need to be able to track popularity.
I have uninstalled and will do another import.

Reply

+ Reply

All times are GMT -4. The time now is 11:36 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: SELECT routeid,itemid FROM `vb4_vw_route` WHERE itemtypeid = 1 AND `itemid` IN ();

Issue Tools