Simple Machines Community Forum

SMF Support => Converting to SMF => vBulletin => Topic started by: noppid on December 15, 2004, 01:30:22 PM

Title: vBulletin 3.0.3 Conversion to SMF
Post by: noppid on December 15, 2004, 01:30:22 PM
I'm tring to convert a vB 3.0.3 DB to SMF. I'm using a fresh install of SMF. The install goes fine and the upgrade starts ok, but gives errors at runtime and leaves the forums blank.

Here's some errors.


Converting members...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/lakecs/public_html/smf/vbulletin3_to_smf.php on line 289

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/lakecs/public_html/smf/vbulletin3_to_smf.php on line 299
successful.
Converting categories...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/lakecs/public_html/smf/vbulletin3_to_smf.php on line 406

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/lakecs/public_html/smf/vbulletin3_to_smf.php on line 416
successful.
Converting boards...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/lakecs/public_html/smf/vbulletin3_to_smf.php on line 499

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/lakecs/public_html/smf/vbulletin3_to_smf.php on line 520
successful.
Converting topics...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/lakecs/public_html/smf/vbulletin3_to_smf.php on line 603

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/lakecs/public_html/smf/vbulletin3_to_smf.php on line 613

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/lakecs/public_html/smf/vbulletin3_to_smf.php on line 622

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/lakecs/public_html/smf/vbulletin3_to_smf.php on line 636
successful.
Converting messages... (this may take some time)
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/lakecs/public_html/smf/vbulletin3_to_smf.php on line 724

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/lakecs/public_html/smf/vbulletin3_to_smf.php on line 734
successful.
Converting polls...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/lakecs/public_html/smf/vbulletin3_to_smf.php on line 809

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/lakecs/public_html/smf/vbulletin3_to_smf.php on line 819
successful.
Converting poll options ...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/lakecs/public_html/smf/vbulletin3_to_smf.php on line 866

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/lakecs/public_html/smf/vbulletin3_to_smf.php on line 881
successful.
Converting previous poll votes...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/lakecs/public_html/smf/vbulletin3_to_smf.php on line 950

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/lakecs/public_html/smf/vbulletin3_to_smf.php on line 960
successful.
Converting personal messages...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/lakecs/public_html/smf/vbulletin3_to_smf.php on line 1036

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/lakecs/public_html/smf/vbulletin3_to_smf.php on line 1046
successful.
Converting personal messages (step 2)...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/lakecs/public_html/smf/vbulletin3_to_smf.php on line 1112

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/lakecs/public_html/smf/vbulletin3_to_smf.php on line 1122
successful.
Converting topic notifications...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/lakecs/public_html/smf/vbulletin3_to_smf.php on line 1192

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/lakecs/public_html/smf/vbulletin3_to_smf.php on line 1202
successful.
Converting board notifications...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/lakecs/public_html/smf/vbulletin3_to_smf.php on line 1263

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/lakecs/public_html/smf/vbulletin3_to_smf.php on line 1273
successful.
Converting board access... successful.
Converting smileys... successful.
Recalculating forum statistics... successful.


Any Advice?

Thanks and regards.
Title: Re: vBulletin 3.0.3 Conversion to SMF
Post by: Grudge on December 15, 2004, 02:19:40 PM
You database user for SMF needs to be able to see the vB database too, ensure they are users of both
Title: Re: vBulletin 3.0.3 Conversion to SMF
Post by: noppid on December 15, 2004, 02:27:55 PM
Thank you sir, that did the job.

Now to check it and learn this new package.

Regards
Title: Re: vBulletin 3.0.3 Conversion to SMF
Post by: Trekkie101 on December 15, 2004, 02:34:56 PM
Welcome to SMF  :D
Title: Re: vBulletin 3.0.3 Conversion to SMF
Post by: noppid on December 15, 2004, 02:36:39 PM
Thanks for the welcome. I'm happy to have found SMF. Now let's see what I can do with it.
Title: Re: vBulletin 3.0.3 Conversion to SMF
Post by: noppid on December 15, 2004, 03:57:02 PM
One thing seems to be wrong after the import. If you look in the last post column you will see posts for other forums listed as last, but the links go to the correct post and forum.

Is this a last post bug or an import anomoly?

You may see it here. http://www.lakecs.com/smf

Thanks
Title: Re: vBulletin 3.0.3 Conversion to SMF
Post by: Kirby on December 15, 2004, 03:59:57 PM
Try going to your admin panel, Forum Maintenence section, and click recount stats.
Title: Re: vBulletin 3.0.3 Conversion to SMF
Post by: Trekkie101 on December 15, 2004, 04:06:12 PM
Nice set of forums.  :D
Title: Re: vBulletin 3.0.3 Conversion to SMF
Post by: noppid on December 15, 2004, 04:23:39 PM
Quote from: Kirby on December 15, 2004, 03:59:57 PM
Try going to your admin panel, Forum Maintenence section, and click recount stats.

I did try that with no joy.

I posted in each forum and it picked up the new posts. I think they may have been moved posts from the import, just a guess. But it's ok now.

Thanks....We're moving on and it's looking good so far. Not too tough to figure out.
Title: Re: vBulletin 3.0.3 Conversion to SMF
Post by: [Unknown] on December 17, 2004, 02:45:04 PM
 ! vBulletin 2 and 3 converters were not properly converting the last post information. (vbulletin_to_smf.php, vbulletin3_to_smf.php)

-[Unknown]