News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

vBulletin 3.0.3 Conversion to SMF

Started by noppid, December 15, 2004, 01:30:22 PM

Previous topic - Next topic

noppid

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.

Grudge

You database user for SMF needs to be able to see the vB database too, ensure they are users of both
I'm only a half geek really...

noppid

Thank you sir, that did the job.

Now to check it and learn this new package.

Regards

Trekkie101


noppid

Thanks for the welcome. I'm happy to have found SMF. Now let's see what I can do with it.

noppid

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

Kirby

Try going to your admin panel, Forum Maintenence section, and click recount stats.

Trekkie101


noppid

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.

[Unknown]

 ! vBulletin 2 and 3 converters were not properly converting the last post information. (vbulletin_to_smf.php, vbulletin3_to_smf.php)

-[Unknown]

Advertisement: