Import Troubles

[Kaelon]

That didn't seem to do anything.

Database error in vBulletin 3.8.0 Beta 1:

Invalid SQL:

		INSERT INTO vault_revision
			(threadid, userid, reason, dateline, pagetext, minor, section, rollback, pending)
		VALUES
		(
			0,
			1,
			'',
			1223844959,
			'',
			0,
			'',
			0,
			0
		);

MySQL Error   : Duplicate entry '0-1223844959' for key 2
Error Number  : 1062
Request Date  : Sunday, October 12th 2008 @ 04:55:59 PM
Error Date    : Sunday, October 12th 2008 @ 04:56:03 PM
Script        : http://www.playbypost.com/forums/admincp/vaultwiki_import.php?do=import
Referrer      : http://www.playbypost.com/forums/admincp/vaultwiki_import.php
IP Address    : 71.232.39.188
Username      : Kaelon
Classname     : vB_Database
MySQL Version : 5.0.51a-community-log

Same SQL Error.

[Kaelon]

Actually, I don't notice a difference in your find/replace. Maybe that's why it's still producing the same error?

[pegasus]

Okay, I'm guessing you didn't have to delete any Book articles before. In that case, it's likely an error is occurring when it tries to create the thread. By the looks of it, it would seem the error is that the post message is too short. It seems there is a missing phrase.

In admincp/vaultwiki_import.php, find:

$vbphrase['ces_default_book_message'] 

Replace with:

'[comment]This is the default message for new Book articles.[/comment]' 

[Kaelon]

Nope, that didn't do it. That doesn't seem to address the root cause that your Importer is conflicting with key values.

Database error in vBulletin 3.8.0 Beta 1:

Invalid SQL:

		INSERT INTO vault_revision
			(threadid, userid, reason, dateline, pagetext, minor, section, rollback, pending)
		VALUES
		(
			85975,
			1,
			'',
			1223845967,
			'[comment]This is the default message for new Book articles.[/comment]',
			0,
			'',
			0,
			0
		);

MySQL Error   : Duplicate entry '85975-1223845967' for key 2
Error Number  : 1062
Request Date  : Sunday, October 12th 2008 @ 05:12:47 PM
Error Date    : Sunday, October 12th 2008 @ 05:12:51 PM
Script        : http://www.playbypost.com/forums/admincp/vaultwiki_import.php?do=import
Referrer      : http://www.playbypost.com/forums/admincp/vaultwiki_import.php
IP Address    : 71.232.39.188
Username      : Kaelon
Classname     : vB_Database
MySQL Version : 5.0.51a-community-log

[pegasus]

True, but it's actually conflicting now for a different reason. Before the thread wasn't actually created, so it was conflicting with other non-existent books (we had a bunch of zero-ids). Now that we fixed the 'message too short' error, the first Book is conflicting with itself because each book is in essence being created twice.

In vault/special_plugins.php, find:

    vault_article_modify($newpost['threadid'], $vbulletin->userinfo['userid'], TIMENOW);

    vault_create_revision(
        $newpost['threadid'],
        $vbulletin->userinfo['userid'],
        '',
        TIMENOW,
        $newpost['message']
    ); 

These lines can be removed completely. And you're going to have 1 Book to delete from your forums.

[Kaelon]

This time, we made it to importing article data, and it looks like we had another SQL Error:

Database error in vBulletin 3.8.0 Beta 1:

Invalid SQL:

			REPLACE INTO vault_article
				(threadid, bookid, lastmodified, lastmodifiedbyid, lastposterid)
			VALUES
			
		(
			75752,
			,
			1223825328,
			1,
			1
		),
               ... several hundred lines ...
		(
			75753,
			,
			1200079038,
			1,
			1
		)' at line 7
Error Number  : 1064
Request Date  : Sunday, October 12th 2008 @ 05:24:43 PM
Error Date    : Sunday, October 12th 2008 @ 05:24:49 PM
Script        : http://www.playbypost.com/forums/admincp/vaultwiki_import.php?do=import
Referrer      : http://www.playbypost.com/forums/admincp/vaultwiki_import.php
IP Address    : 71.232.39.188
Username      : Kaelon
Classname     : vB_Database
MySQL Version : 5.0.51a-community-log

[pegasus]

Okay, this time you should empty out the nuwiki_chapter / nuwiki_book tables, so it doesn't bother creating the Books again.

In admincp/vaultwiki_import.php, find:

$article['bookid'] 

Replace with:

intval($article['bookid']) 

[Kaelon]

Well, we completed the import this round, but none of the Wiki articles have any text in them. They all display "There is currently no text in this page." I even ran the Clean Articles Post Cache, but still, no articles display. Any thoughts?

[pegasus]

You need to Rebuild the Article Cache. You can do this from the Namespace Manager. Click "Rebuild All Namespaces."

[Kaelon]

Yay, it worked!

Thank you so much for your awesome support. Any other pitfalls, suggestions that I should be aware of?

[Kaelon]

And, tragically, another bug: "New Posts" returns a Fatal Error:

Fatal error: Call to undefined function special_search_complete() in /home/playbypo/public_html/forums/search.php(3743) : eval()'d code on line 10

[Kaelon]

Apparently, this search bug impacts all searches.

[Kaelon]

Another bug:

On the top of all of my individual threads is a "Header for Header" bar, that doesn't seem to do anything. It directs to an invalid "editing" link:

http://www.playbypost.com/forums/sho...rror&do=create

Can't I simply just turn off all Headers, everywhere?

[pegasus]

This requires a plugin edit. In the VaultWiki plugin at hook search_complete, find:

special_search_complete(); 

Add before:

require_once( DIR . '/vault/special_plugins_search.php'); 

[pegasus]

Another bug:

On the top of all of my individual threads is a "Header for Header" bar, that doesn't seem to do anything. It directs to an invalid "editing" link:

http://www.playbypost.com/forums/sho...rror&do=create

Can't I simply just turn off all Headers, everywhere?

Apparently the showthread version of the Header bar looks for an invalid article. The reason that link is so bad, though, is that I believe your Header forum is not set to "Wiki."

You can disable headers in all forums by running the following MySQL query:

UPDATE {PREFIX}forum SET forumheader_enabled = 0

Replace {PREFIX} with your forum's TABLE_PREFIX.