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.
You database user for SMF needs to be able to see the vB database too, ensure they are users of both
Thank you sir, that did the job.
Now to check it and learn this new package.
Regards
Welcome to SMF :D
Thanks for the welcome. I'm happy to have found SMF. Now let's see what I can do with it.
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
Try going to your admin panel, Forum Maintenence section, and click recount stats.
Nice set of forums. :D
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.
! vBulletin 2 and 3 converters were not properly converting the last post information. (vbulletin_to_smf.php, vbulletin3_to_smf.php)
-[Unknown]