Simple Machines Community Forum

SMF Support => Converting to SMF => vBulletin => Topic started by: ProtomanP1 on October 24, 2009, 09:38:05 AM

Title: Convert vB to SMF Through Backup
Post by: ProtomanP1 on October 24, 2009, 09:38:05 AM
I used to have a vBulletin 3.8.3 forum, but it crashed.

I still have a backup from before the crash as in a sql file.

Can I use the backup file to get my old forums on SMF?


How?
Title: Re: Convert vB to SMF Through Backup
Post by: Norv on October 24, 2009, 10:23:10 AM
You can restore the backup into a database, because the converter needs to connect to that database and work with it.

Please note that it may be easier if you restore it into a database with the same name and server as the former vBulletin's database, because the converter will use a vBulletin config file to identify it.
Title: Re: Convert vB to SMF Through Backup
Post by: ProtomanP1 on October 24, 2009, 10:51:40 AM
Okay I rebuilt the database thru the back up.

Now how do I point the converter to the new database? where is it located?
Title: Re: Convert vB to SMF Through Backup
Post by: Norv on October 24, 2009, 03:39:57 PM
Please check out:
Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject)

Specifically for vBulletin, the converter looks for the files:
your_vBulletin_folder/admin/config.php
your_vBulletin_folder/includes/config.php
(any of them would suffice). It will read the database data from there.

Please note also that in case you want to convert to SMF 1.1.10, the converter files as listed for download here will be fine: http://www.simplemachines.org/community/index.php?topic=262571.0
In case you wish to convert to SMF 2.0, you may find useful to use the files attached here.
Title: Re: Convert vB to SMF Through Backup
Post by: ProtomanP1 on October 24, 2009, 06:51:42 PM
okay m8 thanks alot!

Only I got another problem now

when converting i get this error

Unknown column 'memberName' in 'field list'

Title: Re: Convert vB to SMF Through Backup
Post by: Norv on October 24, 2009, 06:58:18 PM
It sounds like you are trying to convert to SMF 2.0 ?

If that is the case please note:
Quote from: Norv on October 24, 2009, 03:39:57 PM

In case you wish to convert to SMF 2.0, you may find useful to use the files attached here.
See my post above (http://www.simplemachines.org/community/index.php?topic=344214.msg2325733#msg2325733) for the converter files for SMF 2.0.
Title: Re: Convert vB to SMF Through Backup
Post by: ProtomanP1 on October 24, 2009, 07:09:59 PM
I must have clicked the wrong link, i could swear I did it right lol.

Again I get an error though

Recalculating forum statistics... Table 'aiclan_SMF.smf_{db_prefix}topics' doesn't exist

Title: Re: Convert vB to SMF Through Backup
Post by: Norv on October 24, 2009, 07:27:56 PM
Oops. Please try using this file instead.
Title: Re: Convert vB to SMF Through Backup
Post by: ProtomanP1 on October 24, 2009, 07:34:32 PM
How can I ever thank you?

Best service I ever had
Title: Re: Convert vB to SMF Through Backup
Post by: Norv on October 25, 2009, 08:17:11 AM
Good to hear it works! :)

Marking this as solved, but please feel free to ask for more assistance in case you may need.
Title: Re: Convert vB to SMF Through Backup
Post by: leonpadi on November 10, 2009, 05:49:06 AM
Yeap i confirm one more succeeded conversion from 3.8.3 to SMF 2 :)
I used those 2 files mentioned in this thread... ;)
Title: Re: Convert vB to SMF Through Backup
Post by: Norv on November 10, 2009, 07:38:09 AM
Cheers, good to hear, and welcome to SMF! :)