Issue: Fatal error on NuWiki import, step 2

Issue Tools
- View Changes

November 12, 2010 9:30 PM

Alfa1

Distinguished Member

Fatal error on NuWiki import, step 2

Now I am getting this error:

Code:

Fatal error: Call to a member function query_write() on a non-object in /public_html/test2/forum/vault/import/nuwiki.php on line 270

Issue Details

Issue Number 2073

Issue Type Bug

Project VaultWiki 3.x Series

Category Importing

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 3.0.5

Fixed Version 3.0.6

Milestone (none)

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

November 12, 2010 9:44 PM
pegasus

VaultWiki Team
There is code in place that should prevent duplicate revisions from being uploaded, so it should be fine to rerun the step after this fix.

In vault/import/nuwiki.php, find:

Code:

$this->db->query_write("

Replace with:

Code:

$this->registry->db->query_write("

The bytes-changed metric may be incorrect for some revisions that were already imported before this fix. This should issue would no longer exist after the upgrade to VaultWiki 4 since the metric will be calculated differently.
Reply
November 12, 2010 10:12 PM

Alfa1

Distinguished Member

Thanks. Is Vaultwiki 4 around the corner then?

Reply

November 12, 2010 10:15 PM

Alfa1

Distinguished Member

When running it again I get this:

Code:

Database error in vBulletin 3.8.6:

Invalid SQL:

					UPDATE vb6_vault_revision
					SET lastrevisionid = CASE revisionid
					WHEN 474 THEN 645
WHEN 277 THEN 519
WHEN 276 THEN 646
WHEN 644 THEN 473
WHEN 275 THEN 333
WHEN 272 THEN 479
WHEN 271 THEN 536
WHEN 270 THEN 369
WHEN 268 THEN 360
WHEN 269 THEN 363
WHEN 265 THEN 368
WHEN 264 THEN 374
WHEN 263 THEN 629
WHEN 261 THEN 460
WHEN 259 THEN 634
WHEN 405 THEN 577
WHEN 478 THEN 648
WHEN 260 THEN 461
WHEN 262 THEN 459
WHEN 467 THEN 638
WHEN 257 THEN 477
					WHERE revisionid IN (474,277,276,644,275,272,271,270,268,269,265,264,263,261,259,405,478,260,262,467,257);

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 'WHERE revisionid IN (474,277,276,644,275,272,271,270,268,269,265,264,263,261,259' at line 24
Error Number  : 1064
Request Date  : Saturday, November 13th 2010 @ 04:13:09 AM
Error Date    : Saturday, November 13th 2010 @ 04:13:16 AM
Script        : /forum/admincp/vaultwiki_setup.php?do=import
Referrer      : /forum/admincp/vaultwiki_setup.php?do=import
IP Address    : 
Username      : Alfa1
Classname     : vB_Database
MySQL Version : 5.0.90-log

I guess I should start over with a new copy of my database? Or should I wait for Vaultwiki 4?

November 12, 2010 10:24 PM
pegasus

VaultWiki Team
You should not need to start with a new database or wait for VaultWiki 4 if you are fine with one metric being off -- next to revisions it usually has +/- integer, to indicate the change in byte-size for the revision. For any messed up metrics, it will instead say +total_size

This should be the last error here, since this was the only new step added to the import process since your tests on other versions. Find:

Code:

" . implode("\n", $updated) . "

Add after:

Code:

END
Reply
November 13, 2010 9:32 PM

Alfa1

Distinguished Member

I will keep on copying my database and performing a test migration / import until I get a flawless result and all the bugs are ironed out.

I did try the code above out on the current migration test, and it doesn't give an error anymore.

Reply

+ Reply

All times are GMT -4. The time now is 12:31 PM.

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: Fatal error on NuWiki import, step 2

Issue Tools