Simple Machines Community Forum

SMF Support => Converting to SMF => vBulletin => Topic started by: MrMike on October 29, 2008, 09:59:05 PM

Title: Hmmm...doesn\'t look like all the boards came over from VB 3.7 (??)
Post by: MrMike on October 29, 2008, 09:59:05 PM
I'm converting from VB 3.7.3 to SMF 1.1.6 and although most of it looks like it's going okay, it seems like it didn't bring over the "top level" boards. I have 66 boards total:
The 51 under the "State" category and the 2 under the "Private" category seem to have transferred, but the 11 top level ones appear to be missing. I haven't received any errors during the import, so I'm not sure what to think.

I used the "vbulletin37_to_smf.sql" found in this post:

http://www.simplemachines.org/community/index.php?topic=262571.msg1712521#msg1712521

Is there a later one that I didn't see, or is this problem perhaps due to something else??

EDIT:  Looking in the "Boards" admin section, it looks like the missing boards got imported as categories, not as message boards. Consequently, they're missing all their posts... :(

Any ideas or suggestions on how to fix or correct this?


Title: Re: Hmmm...doesn't look like all the boards came over from VB 3.7 (??)
Post by: SleePy on October 31, 2008, 06:43:41 PM
Odd, Does vBulletin allow boards with no categories?

You should be able to salvage the topics if you go to Admin -> Forum Maintenance
Then click "Find and Repair Errors". This may take some time depending on the size of your forum.
Title: Re: Hmmm...doesn't look like all the boards came over from VB 3.7 (??)
Post by: MrMike on November 01, 2008, 11:25:38 AM
Quote from: SleePy on October 31, 2008, 06:43:41 PM
Odd, Does vBulletin allow boards with no categories?
It does. This was a conversion from DCForum => Vbulletin => SMF. With 300,000 posts it took about 5 or 6 hours start to finish, including some SMF forum config (which couldn't be done until after the import completed).

Top-level forums in DCForum come over into VBulletin with no trouble; importing from there into SMF is problematic at best. The "Find and Repair Errors" feature in SMF didn't work, unfortunately.

I did, however, manage to get this sorted out:
Title: Re: Hmmm...doesn't look like all the boards came over from VB 3.7 (??)
Post by: SleePy on November 02, 2008, 08:52:40 PM
Hmm.
Do you mind sending me a database dump from just the "forum" table?
I would like to look at it so see if I can't overcome this by creating a default category and putting these boards in it.
Title: Re: Hmmm...doesn't look like all the boards came over from VB 3.7 (??)
Post by: MrMike on November 03, 2008, 10:55:01 AM
Quote from: SleePy on November 02, 2008, 08:52:40 PMDo you mind sending me a database dump from just the "forum" table?
Errrrr.... I'd have been glad to do this but I wiped out the VBulletin database after the initial conversion took place. If you want it really really bad, I'll see if I can run the VB export from DCForum again. It'll be big- 70 80 megs zipped.
Title: Re: Hmmm...doesn't look like all the boards came over from VB 3.7 (??)
Post by: ThorstenE on November 03, 2008, 02:11:47 PM
Is your DCForum+ still alive? I have written a DCForum+ converter during the last days and have successfully converted my small test-system.. Are you interested in Beta-Testing? I can send you the converter files..
Title: Re: Hmmm...doesn't look like all the boards came over from VB 3.7 (??)
Post by: MrMike on November 03, 2008, 05:55:18 PM
My DCForum board is technically still alive (the database still exists), but no longer in use. I could beta test the converter for you as long as it didn't affect my live SMF board (maybe have it output to a file or something). I'd be hesitant to fiddle around with my live install of SMF as it took over a year to get free of DCForum. I could send you a dump of the DCForum database if you want it (76 megs).
Title: Re: Hmmm...doesn't look like all the boards came over from VB 3.7 (??)
Post by: ThorstenE on November 04, 2008, 12:09:42 AM
a dump from a big DCForum+ board would be great :) (helps a lot in debugging the converter) can you send me a link where I can download it? I also can send you FTP details from my webserver, so you can upload it..
Title: Re: Hmmm...doesn't look like all the boards came over from VB 3.7 (??)
Post by: MrMike on November 04, 2008, 12:14:33 AM
Quote from: TE on November 04, 2008, 12:09:42 AMI also can send you FTP details from my webserver, so you can upload it..
Let's try that, and if I can't get it to upload successfully I'll put it someplace you can download it. Please PM me your FTP details and I'll see if I can send it up to you.