Issue: DB Error on MW Import

Issue Tools
- View Changes

March 10, 2010 3:55 AM

Webbstre

Junior Member

DB Error on MW Import

While I am here... I failed at importing my english wiki. This is the report that was automatically e-mailed to me:

Code:

Database error in vBulletin 4.0.2:

Invalid SQL:

SELECT threadid, import_page_id
FROM vb4_2_thread
WHERE import_page_id IN (
41,39,42,44,45,40,43,59,125,158,174,176,238,241,247,248,249,255,256,329,336,338,340,351,352,353,365,374,375,380,402,444,446,455,460,467,495,524,539,803,809,
37,1,20,22,25,16,21,58,,94,5,52,119,239,160,183,73,254,144,118,62,246,339,186,270,192,147,152,335,167,400,189,159,331,296,493,332,196
);

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 '94,5,52,119,239,160,183,73,254,144,118,62,246,339,186,270,192,147,152,335,167,40' at line 5
Error Number  : 1064
Request Date  : Wednesday, March 10th 2010 @ 12:54:34 AM
Error Date    : Wednesday, March 10th 2010 @ 12:54:35 AM
Script        : http://twotest.runicgamesfansite.com/admincp/vaultwiki_setup.php?do=import
Referrer      : http://twotest.runicgamesfansite.com/admincp/vaultwiki_setup.php?do=import&package=mediawiki&step=3&startat=800
IP Address    : 180.5.25.22
Username      : Webbstre
Classname     : vB_Database
MySQL Version : 5.1.39-log

Issue Details

Issue Number 1246

Issue Type Bug

Project VaultWiki 3.x Series

Category Importing

Status Fixed

Priority 1 - Security / Login / Data Loss

Affected Version 3.0.0 Beta 6

Fixed Version 3.0.0 Beta 6

Milestone VaultWiki 3.0.0

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

March 10, 2010 9:52 AM
pegasus

VaultWiki Team
Fixed in the current ZIP. In vault/special_import_mediawiki.php, find:

Code:

$pagecache[$page['import_page_id']] = $page; $parentcache[$page['parent_page_id']] = $page['import_page_id'];

Add before:

Code:

if (!$page['parent_page_id']) { continue; }

It looks like this is only possible when the importer reaches a talk page and it tries to import it, even though that particular talk page is for a page that was already removed from the wiki.
Reply
March 10, 2010 12:07 PM

pegasus

VaultWiki Team

The importer was still very beta-ish until this morning because of some new features that were added to it. I recommend downloading Beta 6 again and replacing the files (no product update needed) before making your next attempt.

Reply
March 11, 2010 3:29 AM

Webbstre

Junior Member

Thank you! The update worked well, as did the htaccess settings maker.

Reply

+ Reply

All times are GMT -4. The time now is 9:43 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 Error on MW Import

Issue Tools