Advertisement:

Author Topic: vBulletin 3.0.3 Conversion to SMF  (Read 12755 times)

Offline noppid

  • Semi-Newbie
  • *
  • Posts: 43
vBulletin 3.0.3 Conversion to SMF
« 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.

Code: [Select]
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.

Offline Grudge

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,742
  • Gender: Male
  • Unofficial nuisance
Re: vBulletin 3.0.3 Conversion to SMF
« Reply #1 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
I'm only a half geek really...

Offline noppid

  • Semi-Newbie
  • *
  • Posts: 43
Re: vBulletin 3.0.3 Conversion to SMF
« Reply #2 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

Offline Trekkie101

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 8,157
  • Gender: Male
  • Ad Astra!
    • https://www.facebook.com/DLRPRoundup on Facebook
    • @dlrproundup on Twitter
    • DLRP Roundup
Re: vBulletin 3.0.3 Conversion to SMF
« Reply #3 on: December 15, 2004, 02:34:56 PM »
Welcome to SMF  :D

Offline noppid

  • Semi-Newbie
  • *
  • Posts: 43
Re: vBulletin 3.0.3 Conversion to SMF
« Reply #4 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.

Offline noppid

  • Semi-Newbie
  • *
  • Posts: 43
Re: vBulletin 3.0.3 Conversion to SMF
« Reply #5 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

Offline Kirby

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 2,040
  • Gender: Male
Re: vBulletin 3.0.3 Conversion to SMF
« Reply #6 on: December 15, 2004, 03:59:57 PM »
Try going to your admin panel, Forum Maintenence section, and click recount stats.

Offline Trekkie101

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 8,157
  • Gender: Male
  • Ad Astra!
    • https://www.facebook.com/DLRPRoundup on Facebook
    • @dlrproundup on Twitter
    • DLRP Roundup
Re: vBulletin 3.0.3 Conversion to SMF
« Reply #7 on: December 15, 2004, 04:06:12 PM »
Nice set of forums.  :D

Offline noppid

  • Semi-Newbie
  • *
  • Posts: 43
Re: vBulletin 3.0.3 Conversion to SMF
« Reply #8 on: December 15, 2004, 04:23:39 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.

Offline [Unknown]

  • SMF Friend
  • SMF Master
  • *
  • Posts: 36,102
  • Gender: Male
Re: vBulletin 3.0.3 Conversion to SMF
« Reply #9 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]