Simple Machines Community Forum

SMF Support => Converting to SMF => vBulletin => Topic started by: Nibogo on October 13, 2010, 07:21:59 PM

Title: [SMF Converter] vBulletin 4.0
Post by: Nibogo on October 13, 2010, 07:21:59 PM
Software: vBulletin.
Version: 4.0
NOTE: You should test the converted forum before delete your vBulletin installation, if you need to do it.

Here's the converter from vBulletin 4.0 to SMF 2.0 RC3, this was tested under an small database so if you have any issues please report them here, data that will be converted:

Title: Re: [SMF Converter] vBulletin 4.0
Post by: coldy316 on October 22, 2010, 01:09:40 AM
thanks for the heads up on this, lately there is a few people that are moving away from vbulletin
to smf, this would defintely come in handy for those people..

Good luck to all the webmaster with this new converter
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Apllicmz on October 24, 2010, 04:28:50 PM
good work
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Nibogo on October 24, 2010, 04:46:56 PM
Quote from: coldy316 on October 22, 2010, 01:09:40 AM
thanks for the heads up on this, lately there is a few people that are moving away from vbulletin
to smf, this would defintely come in handy for those people..

Good luck to all the webmaster with this new converter

Quote from: Joomlamz on October 24, 2010, 04:28:50 PM
good work

Thanks :)
Title: Re: [SMF Converter] vBulletin 4.0
Post by: roosendaaldegekste.nl on November 12, 2010, 08:22:25 PM
I have used [SMF Converter] vBulletin 4 and successfully converted vbulletin 4.0.8 to SMF 2.0 RC4.

But after the successful conversion when i try to login to my new smf forum with old usernames and password it doesn't works.

following message appears after first try

Password security has recently been upgraded. Please enter your password again.

and it did not works again....then it says to reset ur pass using username or email.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: goldenboy48 on November 14, 2010, 01:54:10 AM
I think that's a consequence of converting. Passwords are not transferred over I think, so, you have to reset it.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Doburpally on November 20, 2010, 11:43:45 PM
I have successfully converted from vBulletin 4.0.8 to SMF 2.0 RC3
However when I install the upgrade from RC3 to RC4 Everything seems fine until I go into Admin CP > Forum > Posts and Topics, I get a Blank white page.

I have no idea why this is happening because it works 100% in RC3.

If I install RC4 from scratch there is no problems, when I convert or import all users and topics, posts etc thats when I get the blank page for Posts and Topics ???

Someone please help me.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Norv on November 21, 2010, 12:41:42 AM
Can you please try replacing the Sources/ManagePosts.php file you have on the live forum, with one from a RC4 package provided now for download?
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Doburpally on November 21, 2010, 05:35:41 AM
Quote from: Norv on November 21, 2010, 12:41:42 AM
Can you please try replacing the Sources/ManagePosts.php file you have on the live forum, with one from a RC4 package provided now for download?

I did exactly what you sugested, I backed up old file and uploaded Sources/ManagePosts.php and I still get the white screen.

If you want, I can provide you the URL with Access to Admin CP ;)

BTW, your hellp is appreciated.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Norv on November 21, 2010, 10:23:00 AM
Thank you. Can you please eventually PM me? I would appreciate to access the forum files with a FTP account, if possible, as well. Please however, do so only if you're comfortable with it.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Doburpally on November 21, 2010, 11:38:49 AM
access details sent via pm ;)
Title: Re: [SMF Converter] vBulletin 4.0
Post by: ramazan85 on November 28, 2010, 03:25:32 AM
"Vbulletin 4 > SMF 2" error when translating

QuoteSorry, the database connection information used in the specified installation of SMF cannot access the installation of vBulletin 3.7. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.

The error that was received from the Database was: SELECT command denied to user 'xxxxx_smf'@'localhost' for table 'user'

http://download.simplemachines.org/index.php?thanks;filename=smf_2-0-rc4_vbulletin37_converter.zip (http://download.simplemachines.org/index.php?thanks;filename=smf_2-0-rc4_vbulletin37_converter.zip)
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Norv on November 28, 2010, 04:42:31 AM
Please see:
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
Title: Re: [SMF Converter] vBulletin 4.0
Post by: ngoclanbaby86 on December 07, 2010, 08:49:05 AM
I try upgrade my forums from VBB 3.8.6 to 4.1.0 and use this one to convert SMF 2RC3
but  error Converting members... Successful.
Converting administrators... Unsuccessful!
This query:
UPDATE `smf`.smf_members
SET id_group = 1
WHERE id_member IN ();
Caused the error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3[code]

Who can help me.

it only successful table members
Title: Re: [SMF Converter] vBulletin 4.0
Post by: MasterXBKC on December 07, 2010, 08:24:09 PM
Recalculating forum statistics... Duplicate key name 'ip_index'

VB 4
Title: Re: [SMF Converter] vBulletin 4.0
Post by: ThorstenE on December 08, 2010, 02:30:18 AM
Quote from: MasterXBKC on December 07, 2010, 08:24:09 PM
Recalculating forum statistics... Duplicate key name 'ip_index'

VB 4
please check out:
http://www.simplemachines.org/community/index.php?topic=242961.msg2867944#msg2867944
Title: Re: [SMF Converter] vBulletin 4.0
Post by: ThorstenE on December 08, 2010, 02:36:26 AM
ngoclanbaby86,
please remove this part from vbulletin4_to_smf.sql
/******************************************************************************/
--- Converting administrators...
/******************************************************************************/

---{
$request = convert_query("
SELECT userid AS id_member
FROM {$from_prefix}administrator");
$admins = array();
while ($row = convert_fetch_assoc($request))
$admins[] = $row['id_member'];
convert_free_result($request);

convert_query("
UPDATE {$to_prefix}members
SET id_group = 1
WHERE id_member IN (" . implode(',', $admins) . ")");
---}

After the conversion you should fix the missing admin privilegues: I accidentally deleted my admin account, what do I do? (http://docs.simplemachines.org/index.php?topic=466.0)
Title: Re: [SMF Converter] vBulletin 4.0
Post by: ngoclanbaby86 on December 08, 2010, 10:28:56 AM
@ TE: thank you verry much.
I sloved successful my problem.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Jed11 on December 27, 2010, 11:08:44 PM
My story...

Many years ago I had a vBulletin forum.  Not knowing anything about how it worked, I purchased the license and hired someone to install it, convert it from the simple and obscure board I was using, and keep it updated for me.  A couple of years goes by and some guys across the street decide they want to put my board out of business so they hire my guy to set up an almost identical board for them.  Although my guy felt he was perfectly justified in taking on the job while I was still paying him, I wasn't persuaded by his argument and fired him.  When the backend of the board started notifying me of updates I realized I lacked the credentials to access my license.  Not only did he create my competition, but he stole my license.

That's when I found SMF... and began learning how all this works.

I successfully converted my board from VBulletin to SMF and all was good.  Years pass, social networking... facebook, etc.  take their toll and my forum's activity diminished substantially.  (I did put my competition out though).  So... deciding the effort to keep the forum up was not worth the reward, I gave it to a member that had been a good supporter for a longtime.  Months pass and he begins to use the board I gave him to infringe upon my other internet properties against our understanding.  On top of that,  my old members complain to me that they liked our board better than the one it had become and wanted me to start it back.

In order to take advantage of the newest and latest,  I purchased a license for vBulletin4 because I have forever been fussing with the incompatibility of my CMS with the forum software.  Finally!... a turnkey package that completely integrated my CMS with my forum... or so I thought...

Eight months have passed and I've shut down the CMS, blogging portion of vBulletin4, installed my old CMS again, and living with a forum software I despise... bloated, buggy, and missing many specific abilities I had grown to take for granted with SMF.

If I ever get back to SMF I swear I never switch again!

I've been working for several weeks to convert back to SMF, and have found several ways to do it successfully, with one caveat... passwords do not migrate.  I get messages regularly from users who forget their passwords and think I have to reset it and send them a new one.  The thought of everyone being required to set their own passwords is enough to make me forget the idea.  I read frequently of people asking legitimate questions about how to do something and being told "why would you want to do that" or "it's easy for a member to just do so and so..."  Maybe for other members of other boards, but I imagine most of the questions from board owners come from people similar to me... they may or may not know why... but regardless... they DO know that it is. 

If there is never to be away to migrate the passwords, then there is never going to be an acceptable way for me to get back to SMF... period. 

That said... here's what I've done...

migrated vb4 to phpBB, phpBB to smf
migrated vb4 to myBB, myBB to smf
migrated vb4 to vb3 (with passwords), vb3 to smf
migrated vb4 to smf (today) using the information in this thread

End result... all posts, members, etc. converted (save the attachment issue)  but passwords all require reset.

The only option I have found that I haven't tried is buying a license for IPB and converting vb4 to IPB in the hopes the IPB will convert to smf with the passwords.

I apologize for being so lengthy, but my issue is one echoed on many boards of many months and too many people have been extolling their success of creating a converter that leaves this glaring problem unresolved and unmentioned. 

So... my simple question is this... is a converter that includes the migration of the passwords an impossible task, or one that has not reached maturity? 

Shall I continue to wait, or give up and lie in the bed I have already made?   
Title: Re: [SMF Converter] vBulletin 4.0
Post by: ThorstenE on December 28, 2010, 02:39:41 AM
passwords conversion is possible, but we need to know some things about the password encryption.

could you please create a "test" user and generate a password "test".. then please check the vbb user table via phpMyAdmin and post the information from these two columns: password & salt

afaik they use md5(md5($pass).$salt)

please edit vbulletin4_to_smf.sql and find:
TRUNCATE {$to_prefix}members;
Add after:
ALTER TABLE {$to_prefix}members
CHANGE COLUMN password_salt password_salt varchar(32) NOT NULL default '';

that should at least convert the salt and password properly, maybe we need an additional line of code in Sources/LogInOut.php
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Jed11 on December 28, 2010, 07:57:01 AM
TE:

I created a test user as you suggested with password "test" and it produced the following two columns in the user table:

password
57c29b97958b13008b4e4992335f3725

salt
iEsU|?JW.w8p-c}R9.7D=zZXWQ7iQj

I'll try you altered code shortly and be back with the results.  Thanks for your help.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Jed11 on December 28, 2010, 11:19:56 AM
I tried just now and get:

Quote
Converting members... Unsuccessful!
This query:
ALTER TABLE ``.smf_membersCHANGE COLUMN password_salt password_salt varchar(32) NOT NULL default '';
Caused the error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLUMN password_salt password_salt varchar(32) NOT NULL default ''' at line 1


Any idea what the error could be?
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Jed11 on December 28, 2010, 11:26:25 AM
I found there error.

where ".smf_membersChange Column" change to ".smf_members Change Column"

Just needed a space between "members" and "Change"

Now I'm getting this error during the conversion of the attachments:

Quote
Converting attachments...
Unsuccessful!
This query:
SELECT
postid AS id_msg, counter AS downloads, filename, filedata, userid,
attachmentid
FROM ``.attachment
LIMIT 0, 500;
Caused the error:

Unknown column 'postid' in 'field list'

Title: Re: [SMF Converter] vBulletin 4.0
Post by: Jed11 on December 28, 2010, 12:06:33 PM
Changed "postid" to "contentid" and got past that one to the next one... "filedata"  a little research on that one tells me it should only be used if the content of the attachment is stored in the database (mine is not) so I deleted "filedata" and got through to the end of the converter.

I loaded up the forum with everything converted, tried to log in and my password was not accepted. 

The passwords did not migrate.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: NanoSector on December 28, 2010, 12:10:55 PM
I don't get why people pay for vBulletin, to convert to free software later...

Anyhow;
@Jed11: I lost admin account, what can I do? (http://docs.simplemachines.org/index.php?topic=466)
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Jed11 on December 28, 2010, 12:25:22 PM
Sheesh Simple Series team!  With 1,410 posts maybe you should read more and post less!  As I stated a half a dozen posts up:

Quote
I read frequently of people asking legitimate questions about how to do something and being told "why would you want to do that" or "it's easy for a member to just do so and so..." 

Count yourself in that category of people making comments irrelevant to the solution of the problem being discussed.  Your link to the "Lost Admin Account" instructions is useless to this discussion.

Do you have any idea how to migrate user passwords?
Title: Re: [SMF Converter] vBulletin 4.0
Post by: NanoSector on December 28, 2010, 12:31:15 PM
Quote from: Jed11 on December 28, 2010, 12:25:22 PM
Sheesh Simple Series team!  With 1,410 posts maybe you should read more and post less!  As I stated a half a dozen posts up:

Quote
I read frequently of people asking legitimate questions about how to do something and being told "why would you want to do that" or "it's easy for a member to just do so and so..." 

Count yourself in that category of people making comments irrelevant to the solution of the problem being discussed.  Your link to the "Lost Admin Account" instructions is useless to this discussion.

Do you have any idea how to migrate user passwords?
May I have a personal opinion? Thank you. I never directed my post at anyone.

My link indeed is useful; if you can't access your admin acount anymore, you can follow these steps to recover it, or maybe create a new one.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Jed11 on December 28, 2010, 12:37:08 PM
Useless post.

If anyone can help with the migration of passwords I would be most appreciative. I have a fully migrated board, but all the passwords still have to be reset by the users.  I'm looking for a solution.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: ThorstenE on December 29, 2010, 03:04:59 AM
Jed11,
I'll check the password encoding later.. can you re-convert the entire board or do you already use SMF as your forum? As far as I can see the salt was cut off by the converter, therefore salt and paswords don't match (and are useless even with a proper login fix). At least the members table needs to be converted again.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Jed11 on December 29, 2010, 08:03:51 AM
Quote from: TE on December 29, 2010, 03:04:59 AM
Jed11,
I'll check the password encoding later.. can you re-convert the entire board or do you already use SMF as your forum? As far as I can see the salt was cut off by the converter, therefore salt and paswords don't match (and are useless even with a proper login fix). At least the members table needs to be converted again.

Thanks TE.  I've got everything up on a test site ready to try or retry anything that might work.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: ThorstenE on December 30, 2010, 03:48:34 AM
Jed11,
I've done some tests and passwords are working as expected :)
your posted password and salt is already supported by SMF 2 RC4 by default:


// vBulletin 3 style hashing?  Let's welcome them with open arms \o/.
$other_passwords[] = md5(md5($_POST['passwrd']) . $user_settings['password_salt']);

however the converter needs to be slightly changed to convert the salts:
in vbulletin4_to_smf.sql find:
/******************************************************************************/
--- Converting members...
/******************************************************************************/

TRUNCATE {$to_prefix}members;

Add after:
ALTER TABLE {$to_prefix}members
CHANGE COLUMN password_salt password_salt varchar(32) NOT NULL default '';

then restart the converter.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Jed11 on December 30, 2010, 04:28:20 PM
TE:

I appreciate your help on this, but my passwords are still not migrating.  Straight conversion with the change you've provided results in a converted forum except user's passwords.  It's as if your change had no effect here.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: NanoSector on December 30, 2010, 04:31:52 PM
If I may post something I think is not really correct (but hey, here comes a PHP/SQL noob):

/******/
--- Converting members...
/*******/
In this code, it looks like you make a multiline comment, close it immediately, make a --- statement, and do the same as before...

Is the --- statement used for displaying stuff, or is it another comment?
Title: Re: [SMF Converter] vBulletin 4.0
Post by: ThorstenE on December 31, 2010, 02:00:38 AM
Quote from: Jed11 on December 30, 2010, 04:28:20 PM
I appreciate your help on this, but my passwords are still not migrating.  Straight conversion with the change you've provided results in a converted forum except user's passwords.  It's as if your change had no effect here.
That's weird.. the "test" password worked fine for me. Would you please attach your vBullein4_to_smf.sql?
Found this article: http://www.vbulletinguru.com/?s=vbulletin+4+password+encryption
Maybe their passwords encryption has changed again, which version of vBulletin exactly do you use?

@Simple Series team:
the syntax is a special SMF converter code and handeled by convert.php
Title: Re: [SMF Converter] vBulletin 4.0
Post by: NanoSector on December 31, 2010, 06:54:11 AM
Quote from: TE on December 31, 2010, 02:00:38 AM
@Simple Series team:
the syntax is a special SMF converter code and handeled by convert.php
Ah, right. Just ignore my noobiness ;)
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Jed11 on December 31, 2010, 02:05:09 PM
Quote
That's weird.. the "test" password worked fine for me. Would you please attach your vBullein4_to_smf.sql?
Found this article: http://www.vbulletinguru.com/?s=vbulletin+4+password+encryption
Maybe their passwords encryption has changed again, which version of vBulletin exactly do you use?

That would be my guess.  I hadn't seen the article (thanks for the link).  vB4 has been so buggy they've been popping out updates and patches so frequently it's hard to keep up.  I'm running 4.1.0 so I'd bet they've altered the structure of the encryption. 

I've attached the vBulletin4_to_smf.sql I used for this last conversion attempt. 

I'm really close to deciding to bite the bullet and advise my members to reset their passwords.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: ThorstenE on January 01, 2011, 05:30:57 AM
I believe I've found the solution :) (my tests worked fine)..
in Sources/LogInOut.php find:

// vBulletin 3 style hashing?  Let's welcome them with open arms \o/.
$other_passwords[] = md5(md5($_POST['passwrd']) . $user_settings['password_salt']);


add after:
$other_passwords[] = md5(md5($_POST['passwrd']) . stripslashes($user_settings['password_salt']));

then use the attached version of vbulletin37_to_smf.sql.


Title: Re: [SMF Converter] vBulletin 4.0
Post by: Jed11 on January 01, 2011, 02:43:31 PM
TE:

Success!!!! You did it!  VB4.1.0 to SMF 2.0 RC4 complete with attachments and passwords.  This is a full converter for me.  Most excellent work!
Title: Re: [SMF Converter] vBulletin 4.0
Post by: ThorstenE on January 01, 2011, 04:39:08 PM
You're welcome :)
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Jed11 on January 02, 2011, 06:18:21 PM
Well, another followup post is due here... as posted above I had success performing a complete conversion on my test site so today I went in head first for the real thing.  My actual application was a little more complicated... I first merged a database from a smf 2.0 RC2 to my VB 4.1.0 using the Impex system with Vbulletin.  Everything migrated as it should - so my next step was to convert the two merged boards as a VB 4.1.0 to a smf 2.0 RC4. 

I got the following error:

QuoteRecalculating forum statistics... Duplicate key name 'ip_index'

A google search brought me to another one of your posts TE... addressing it here:

http://www.simplemachines.org/community/index.php?topic=242961.msg2867944#msg2867944

I replaced the code as instructed and the coversion was flawless.  All issues with attachments passing from VB4 to SMF and all password problems were resolved.

I've attached the convert.php and the vbulletin4_to_smf.sql with all the changes in case it may benefit someone else.  The only thing you need to remember in addition to the attached two files is to be sure and alter your /Sources/LogInOut.php file as TE explains in this thread.

Thanks again for all the help on this.



Title: Re: [SMF Converter] vBulletin 4.0
Post by: Jed11 on January 03, 2011, 01:36:56 PM
This is indirectly related to the conversion and I didn't know where to put it...

I merged a SMF forum with a vBulletin and everything appeared ok.  However, when I coverted the new vBulletin forum to SMF the threads are not in chronological order.  Once a post is made to a thread it's bumbed to the top, buy most of the latest threads are at or near the end instead of at the front.  Is there a way to change this?

Also, I'd like to create a links menu at the top of my board similar to the SMF board here where it shows:

Home Community Download Customize Support Online About Contribute Development

Could someone point me in the right direction?
Title: Re: [SMF Converter] vBulletin 4.0
Post by: ThorstenE on January 04, 2011, 02:44:09 AM
Merging Boards is often far from perfect, because the unique ID (id_topic, id_msg ..) is not rebuild. this results in unordered topics... maybe this modification can help (have not checked myself):
http://custom.simplemachines.org/mods/index.php?mod=1677

the menu:
http://custom.simplemachines.org/mods/index.php?mod=2564
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Jed11 on January 04, 2011, 11:09:53 AM
Man that menu mod worked perfectly!  Thanks!

The other mod for the ordering of topics is good for smf 2.0 RC1, but no mention of RC4.  It alters the default ordering or smf.  I want to keep the default ordering - I just need a way to rebuild the unique ID based on the date of the last post.  Appears such a creature doesn't exist?
Title: Re: [SMF Converter] vBulletin 4.0
Post by: tulie on January 15, 2011, 05:14:44 AM
Quote from: Jed11 on January 02, 2011, 06:18:21 PM
Well, another followup post is due here... as posted above I had success performing a complete conversion on my test site so today I went in head first for the real thing.  My actual application was a little more complicated... I first merged a database from a smf 2.0 RC2 to my VB 4.1.0 using the Impex system with Vbulletin.  Everything migrated as it should - so my next step was to convert the two merged boards as a VB 4.1.0 to a smf 2.0 RC4. 

I got the following error:

QuoteRecalculating forum statistics... Duplicate key name 'ip_index'

A google search brought me to another one of your posts TE... addressing it here:

http://www.simplemachines.org/community/index.php?topic=242961.msg2867944#msg2867944

I replaced the code as instructed and the coversion was flawless.  All issues with attachments passing from VB4 to SMF and all password problems were resolved.

I've attached the convert.php and the vbulletin4_to_smf.sql with all the changes in case it may benefit someone else.  The only thing you need to remember in addition to the attached two files is to be sure and alter your /Sources/LogInOut.php file as TE explains in this thread.

Thanks again for all the help on this.





Hi,

Can I use the attached file for a successful conversion of VB to SMF with password conversion as well? or do I have to create a test user and go through the whole process you've highlighted again?

Thank you.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: ThorstenE on January 15, 2011, 08:38:04 AM
yep, you can use that file..
Title: Re: [SMF Converter] vBulletin 4.0
Post by: lisandro on January 28, 2011, 12:14:35 PM
i have install smf 1.1.12 withe new database
and download convert form http://download.simplemachines.org/index.php?thanks;filename=smf_1-1-12_vbulletin_converter.zip

I have this problem when i specify a password.
I think I've identified the correct password.
How do I fix this?.
thanks
sorry for my English

QuoteSorry, the database connection information used in the specified installation of SMF cannot access the installation of vBulletin 2. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: Incorrect database name ''
Title: Re: [SMF Converter] vBulletin 4.0
Post by: ThorstenE on January 28, 2011, 12:39:45 PM
lisandro, that converter is the wrong one (AFAIK that version is for vBulletin 2.0 or older). the 4.0 converter is attached to the first post from this topic, unfortunately only for SMF 2.0.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: lisandro on January 28, 2011, 01:32:02 PM
Quote from: TE on January 28, 2011, 12:39:45 PM
lisandro, that converter is the wrong one (AFAIK that version is for vBulletin 2.0 or older). the 4.0 converter is attached to the first post from this topic, unfortunately only for SMF 2.0.

thanks,but I still have a problem after pressing continue button.
QuoteFatal error: Call to undefined function loadDatabase() in /home/xxx/domains/xxx.com/public_html/convert.php on line 414
Title: Re: [SMF Converter] vBulletin 4.0
Post by: ThorstenE on January 28, 2011, 01:59:37 PM
I'm not 100% sure but related to the error message I suspect you're using the 2.0 converter from this topic and your SMF version is 1.1.12? you need to install SMF 2.0 first.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: lisandro on January 28, 2011, 09:53:25 PM
i need install SMF 2.0 ? . 1.1 is not compatibility ?
Title: Re: [SMF Converter] vBulletin 4.0
Post by: ThorstenE on January 29, 2011, 01:02:55 AM
the converter from this topic is a 2.0 version, working only with SMF 2.0 (RC4) as your destination forum. A vBuelletin 4.x to 1.1.12 converter is AFAIK not available, sorry.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Zero13 on February 02, 2011, 09:56:43 AM
Hi, I can not move from this point .. I've tried in the hosting, locally and even with version 3.7 of vBulletin to SMF converter.

I appreciate any ideas or input.  :-\
Thank you very much!

vBulletin 4.0 to SMF Converter
My vBulletin version: 4.1.1
My SMF version: 2.0 RC4

Quote
Converting...
Converting topics...
Successful.
Converting posts (this may take some time)...Wrong value type sent to the database. Integer expected. (id_member)
Title: Re: [SMF Converter] vBulletin 4.0
Post by: ThorstenE on February 02, 2011, 10:46:27 AM
Zero13,
can you please try the attachments from this post?
http://www.simplemachines.org/community/index.php?topic=404729.msg2899909#msg2899909
Title: Re: [SMF Converter] vBulletin 4.0
Post by: NanoSector on February 06, 2011, 09:31:53 AM
Did that work, Zero13?
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Zero13 on February 07, 2011, 08:22:46 AM
Hi, I'm not replying earlier, continues to fail at the same point, to convert messages / post :(

Thank TE, I tested these new scripts .. and I've tried both the hosting and in local .. and nothing

Converting topics...
Successful.
Converting posts (this may take some time)...Wrong value type sent to the database. Integer expected. (id_member)
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Zero13 on February 09, 2011, 07:48:28 AM
Anyone can help me?
:-\
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Beacher on March 16, 2011, 03:14:04 PM
Thanks to all ;) i'm another vbulletin that convert to smf ;)
Title: Re: [SMF Converter] vBulletin 4.0
Post by: program5 on May 17, 2011, 11:28:15 AM
When I switched to Vbulletin 4 , there was no possibility to recover passwords, and avatars.
Today, I 'm back to SMF , with no password - attachment - avatar problems.
Thank You TE and thank You Jed11

SMF is the best software , proven once again !

Note : a direct upgrade attempt to rc5 will fail.
Convert to rc3 first. Then upgrade.

Title: Re: [SMF Converter] vBulletin 4.0
Post by: iobit on May 27, 2011, 12:10:30 PM
Hello,
works for vb  4.1.x SMF 2 Rc5?
thanks
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Antes on May 27, 2011, 01:48:36 PM
Latest i tried on vB 4.0.5 to SMF 2 RC5 (Dev), everything was perfect.

Use those

http://www.simplemachines.org/community/index.php?action=dlattach;topic=404729.0;attach=165421
http://www.simplemachines.org/community/index.php?action=dlattach;topic=404729.0;attach=165422

(or at least try on localhost)
Title: Re: [SMF Converter] vBulletin 4.0
Post by: USFAddicts on July 23, 2011, 02:01:58 PM
EDIT: Fixed my problem!

Now when I try to login on the newly converted SMF Forum.  I cannot login to the admin panel, I tried both accounts from the SMF and the admin account from vBulletin.

Any help?
Title: Re: [SMF Converter] vBulletin 4.0
Post by: crew2cry on August 14, 2011, 04:40:05 AM
I have tried the converter but i was unable to login with the old user ids
can you provide the one that is working
i am converting vbulletin 4.0.7 to smf 2 rc5
Title: Re: [SMF Converter] vBulletin 4.0
Post by: venice12 on September 29, 2011, 11:07:14 AM
Wha is this mean ?
Unsuccessful!
This query:
;
Caused the error:
Query was empty
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Oldiesmann on October 07, 2011, 09:34:04 PM
What is it doing when you're getting that error?
Title: Re: [SMF Converter] vBulletin 4.0
Post by: UndiFineD on October 28, 2011, 06:35:38 PM
thank you, this thing worked wonderful, though it was hard to find the attachments
Title: Re: [SMF Converter] vBulletin 4.0
Post by: _saiko on November 05, 2011, 07:08:50 AM
Is there a way to redirect from old vbulletin links (showthread.php) to the SMF links?
I migrated from vB 3.8 to SMF 2.0.1.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: malc34 on November 06, 2011, 03:44:45 PM
I want to convert my vBulliten forum to SMF, but I have no clue what I'm doing.. I did the whole basic installation so far but I guess I need to install this instead, can anyone maybe help me via email,aim,etc?
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Antes on November 06, 2011, 05:18:59 PM
Hello malc34

Why don't you check out wiki :) You can find lot of good information about converting & converters...

http://wiki.simplemachines.org/smf/Converting
Title: Re: [SMF Converter] vBulletin 4.0
Post by: anshar on November 09, 2011, 05:14:33 AM
Converting vbb 4.0.8 with couple of plugins to SMF 2.0.1, but it's stopped on following error:

Link: convert.php?step=1&substep=11&start=600

Converting posts (this may take some time)...
Successful.
Converting polls...Wrong value type sent to the database. Integer expected. (expire_time)

Any ideas?
Title: Re: [SMF Converter] vBulletin 4.0
Post by: anshar on November 17, 2011, 06:22:35 AM
Wow, nobody can help?
Title: Re: [SMF Converter] vBulletin 4.0
Post by: aztoyota on December 19, 2011, 11:26:56 PM
Converting members...Wrong value type sent to the database. Integer expected. (posts) is the error I get. Reinstalled and tried 4 times to no success. Converting from 4.0.2.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: fairwea1 on December 23, 2011, 09:34:01 PM
Is there any chance of throwing the correct vbulletin4 converter into the download section of this site? This thread is confusing as to which files I'm supposed to use.

Title: Re: [SMF Converter] vBulletin 4.0
Post by: afcbob on May 13, 2012, 02:57:33 PM
Need help getting converted from vbulletin to smf i have installed the smf and downloaded the 2 files but what do i do next sorry new at this
Title: Re: [SMF Converter] vBulletin 4.0
Post by: NanoSector on May 13, 2012, 03:04:55 PM
Quote from: afcbob on May 13, 2012, 02:57:33 PM
Need help getting converted from vbulletin to smf i have installed the smf and downloaded the 2 files but what do i do next sorry new at this
Hi afcbob!

You know how to open your SMF install, right? Like http://mysite.com/index.php ?
Now, get rid of the "index.php" part and replace it with "convert.php", on your own site obviously. That will start the converter.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: afcbob on May 13, 2012, 03:11:11 PM
Ok thats great got that done how do a get the images back in my posts
Title: Re: [SMF Converter] vBulletin 4.0
Post by: alpheus on July 11, 2012, 11:35:50 AM
Quote from: roosendaaldegekste.nl on November 12, 2010, 08:22:25 PM
I have used [SMF Converter] vBulletin 4 and successfully converted vbulletin 4.0.8 to SMF 2.0 RC4.

But after the successful conversion when i try to login to my new smf forum with old usernames and password it doesn't works.

following message appears after first try

Password security has recently been upgraded. Please enter your password again.

and it did not works again....then it says to reset ur pass using username or email.

I converted to Smf 2.0.2 successfully but I have same problem too! I can't login to smf with new password. What can I do please?
Title: Re: [SMF Converter] vBulletin 4.0
Post by: gerzok on July 29, 2012, 06:17:58 AM
Quote from: alpheus on July 11, 2012, 11:35:50 AM
Quote from: roosendaaldegekste.nl on November 12, 2010, 08:22:25 PM
I have used [SMF Converter] vBulletin 4 and successfully converted vbulletin 4.0.8 to SMF 2.0 RC4.

But after the successful conversion when i try to login to my new smf forum with old usernames and password it doesn't works.

following message appears after first try

Password security has recently been upgraded. Please enter your password again.

and it did not works again....then it says to reset ur pass using username or email.

I converted to Smf 2.0.2 successfully but I have same problem too! I can't login to smf with new password. What can I do please?

Seem problem, I convert my vbulletin to SMF with this tools few weeks ago and i can't login now. I had to return to vbulletin from scratch. any idea about how to fox it?  :-\ 
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Mariano on August 06, 2012, 10:57:44 PM
Thanks Jed11 for your modifications. It worked great (so far) but smileys and attachments were not converted.
I converted my forum from vBulletin 4.1.11 to SMF 1.1.12. Posts, profiles, threads and forums are displaying correctly.

I need to change my website's DNS first to know what it's not working, tough. I'll let you know if I have problems (I hope not).

Thanks a lot!

Title: Re: [SMF Converter] vBulletin 4.0
Post by: Peter_AUS on September 06, 2012, 05:01:38 AM
Just want to say thank you for providing such an easy way to move the majority of vBulletin 4.2.x over to SMF using the Converter the SQL file and the change in the source file that needs to be changed to achieve this.

What is missing, are instructions for how to do this conversion for people that are trying to find out.

So what I did, by reading and surmising what was meant was to put both the files required to do the conversion in the root of SMF.
I then made the change to add the line to the source file mentioned in the threads above.
What I found out when I ran the converter was that I couldn't access the vBulletin database, why, because the admin name wasn't allowed to in the MSQL Database area, so I added my smf admin database user to the vBulletin database user will allow all and then ran the converter again, with then no hiccups.

As said above smiles don't come across, nor do the thanks given by people so I am looking through the mods for a Thanks Mod.

What would be nice is maybe a list of essential mods that people think would be good to add in to the SMF core for administrative, permissions, profile, security etc. that are known to work well, as that would help all of us, make sure that hackers and spammers don't get in whilst converting over to SMF when we have used mods in vBulletin that aren't included in their core product either.

Thanks again for making my life not so difficult with the conversion, which I have only done on a test bed so far, still need to work some things out administratively and mods before doing it to my real site.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: arapboy on January 04, 2013, 11:42:10 AM
hi !

How can I fix this error?

I'd appreciate if you help

Converting members...Unknown column 'member_name' in 'field list'


Title: Re: [SMF Converter] vBulletin 4.0
Post by: jldrake on January 25, 2013, 09:45:32 PM
4.2 Vbulletin to latest SMF,

Passwords do not seem to be converting. I tried the fixes listed in the earlier posts. Anybody have a fix?

Everything else converted perfectly.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Konferge on February 01, 2013, 04:20:24 PM
Anyone know if it's possible to do the conversion when the vBulletin forum and SMF forum are run with 2 different hosting companies?  I assumed I could just copy the vbulletin database to the SMF database server, but the converter is looking for the install path, and I'm not sure why it would need that.  Thanks in advance for any help.

Konferge
Title: Re: [SMF Converter] vBulletin 4.0
Post by: amerawad111 on March 03, 2013, 08:42:31 PM
all steps is ok
but when copy attachment this error is appear

Warning: copy(/home/mydomin.com/public_html/up/8/9878.attach) [function.copy]: failed to open stream: No such file or directory in /home/mydomin.com/public_html/phpbb/convert.php(1264) : eval()'d code on line 44

i put 777 permeation to attachment file on smf folder and the same error appear
Title: Re: [SMF Converter] vBulletin 4.0
Post by: kaytaro on March 28, 2013, 03:41:21 PM
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of vBulletin 4.0. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.
...........................................

uh.... wtf? how do you give the database permission to access it?

edit: now i get this

This converter was unable to find SMF in the path you specified.

Please double check the path, and that it is already installed there.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: MechSpecs on April 04, 2013, 12:29:43 PM
I was able to get the database to convert (finally) and all my users and posts / polls etc. worked except for the passwords

Is there an UPDATED set of instructions for vBulletin 4.2.0 (Patch 2) to SMF 2.0.4?

EDIT: Nevermind... I now have this working as per Jed11 helpful files!
Title: Re: [SMF Converter] vBulletin 4.0
Post by: banks on April 27, 2013, 11:25:53 PM
I AM Having Issues As Well When I Run The Converter.
vBulletin 4.0 To SMF The Latest Version

The Converter I AM Using Is The Latest One.

When I Enter ALL THE CORRECT Info I Get :


Converting...
Successful.
Recalculating forum statistics...
Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.


When I Download The Converter I Have 2 Files :

vbulletin_to_smf.sql
convert.php

I Place The convert.php In My SMF Root Then Run The Install.

Am I Missing Something?
Title: Re: [SMF Converter] vBulletin 4.0
Post by: banks on April 29, 2013, 11:14:42 AM
Converting...
Successful.
Recalculating forum statistics...


Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: emanuele on April 29, 2013, 11:56:27 AM
Funny that both of you have the same email address to contact.

Are you on the same host?
Is a win or linux server?

An internal server error in my mind is usually connected to a file permissions issue (i.e. wrong setting for file permissions) or some htaccess screwing up something.
Check that all the SMF files have the proper permissions: http://wiki.simplemachines.org/smf/Installing#Set_File_and_Folder_Permissions

If you have any htaccess remove it and try again.

How many posts do you have on your forum?
How many users?
Title: Re: [SMF Converter] vBulletin 4.0
Post by: rubycluck on June 25, 2013, 10:00:24 AM
Can someone please tell me which are the best 2 files to download to convert from vBulletin to SMF, there's so many posts in this thread giving updated or altered files it's very confusing. Are these 2 files to replace those given in the vBulletin converter in the Downloads section, I assume for vb4 it's the last one with no version specified?

And also any edits to files required.

vbull v4.1.3 to latest SMF

I think it would be great if someone posted the latest 2 working files for download along with step by step instructions, and if then it's found edits are required the original post is edited so when people download they know they're getting the latest working files.

I'm hesitant to try the converter because I'm not that spectacular at sorting things out when they go wrong. Although I'm not a complete idiot. I guess an average Admin like most on here.

Failing all that, is there a senior poster (expert) on here that would do the dirty deed for me and convert my vBulletin v4.1.3 into the latest SMF?

The reason I want to convert is I have 2 forums, one SMF which never gets any spammers and is easy to update. The other is a vBulletin and gets hundreds of spammers a day despite having AKISMET key, Spam-o-Matic, Q&A on registration and God knows what security installed, oh and an htaccess file blocking complete countries.

I've got none of that hassle wih the SMF forum and it plods away secure and happy ever since it was installed back in 2008.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Boxer2 on July 18, 2013, 04:21:23 PM
Have som eproblems with conversion from 4.1.5 to SMF

Here are problems, can anyone help?

Notice: Undefined index: convert_script in /home/school/public_html/forum/convert.php on line 982

Warning: Invalid argument supplied for foreach() in /home/school/public_html/forum/convert.php on line 985

Notice: Undefined index: convert_script in /home/school/public_html/forum/convert.php on line 997
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /home/school/public_html/forum/convert.php on line 2504

Notice: Undefined variable: result in /home/school/public_html/forum/convert.php on line 2505

Notice: Undefined index: db_fetch_assoc in /home/school/public_html/forum/convert.php on line 1396

Fatal error: Function name must be a string in /home/school/public_html/forum/convert.php on line 1396
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Boxer2 on July 19, 2013, 03:59:58 PM
Enibody?
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Tomy Tran on July 20, 2013, 12:50:08 AM
Love what, Phuong?
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Harvester on April 14, 2014, 09:28:22 PM
I went to the download section for converters and dont see a download for vb 4.x   Im using 4.2.1   I only have 3000 posts and 130 members but I would like to import the data to my SMF 2.0.7. Where would I download the converter from and do instructions come with it?

Any help would be greatly appreciated

Thanks, Jared
Title: Re: [SMF Converter] vBulletin 4.0
Post by: margarett on April 14, 2014, 09:39:26 PM
I never really tried VB converter but, based on previous posts, the files here should work:
http://www.simplemachines.org/community/index.php?topic=404729.msg2899909#msg2899909
Title: Re: [SMF Converter] vBulletin 4.0
Post by: MediaSVI on January 21, 2015, 06:51:29 PM
There are no instructions on what to do with these 2 files? How are people to know what to do with them and make them work?
Title: Re: [SMF Converter] vBulletin 4.0
Post by: margarett on January 21, 2015, 07:28:04 PM
Converting to SMF (http://wiki.simplemachines.org/smf/Converting)
;)
Title: Re: [SMF Converter] vBulletin 4.0
Post by: coldy316 on February 13, 2015, 06:34:57 PM
has anyone tried this with the Vb 4.2.2  convert to smf 2.0.9 yet ??

after reading so many topics posts people are having trouble with this converter  will
this work on the latest versions of Vbulletin and SMF
Title: Re: [SMF Converter] vBulletin 4.0
Post by: margarett on February 13, 2015, 06:38:18 PM
I did convert a big VB 4.something some time ago.

The good with converters is that you can always try, no problems, as it will keep your original setup untouched ;)
Title: Re: [SMF Converter] vBulletin 4.0
Post by: coldy316 on February 13, 2015, 06:44:14 PM
Quote from: margarett on February 13, 2015, 06:38:18 PM
I did convert a big VB 4.something some time ago.

The good with converters is that you can always try, no problems, as it will keep your original setup untouched ;)


will it conflict with two admins registered on the freshly new smf forum as there names are already in the forum database ??
I normally get someone to do the database thingy as I have no experience in this field..


Title: Re: [SMF Converter] vBulletin 4.0
Post by: margarett on February 13, 2015, 06:59:55 PM
Yes, all members in SMF's database will be removed, as will posts, topics, boards, etc...
Title: Re: [SMF Converter] vBulletin 4.0
Post by: The Factor on March 02, 2015, 09:15:23 PM
Thanks for all the work on this converter.  Worked well except for attachment s so far.

http://www.simplemachines.org/community/index.php?topic=534203.msg3796587#msg3796587

Brent Dacus
Title: Re: [SMF Converter] vBulletin 4.0
Post by: bubus66 on May 17, 2016, 03:36:08 AM
Hey What's the problem that can not be converted?

(http://s5.postimg.org/p03ke4olf/N_vtelen.jpg) (http://postimg.org/image/p03ke4olf/)
Title: Re: [SMF Converter] vBulletin 4.0
Post by: margarett on May 17, 2016, 05:51:03 PM
Don't worry about that, the conversion ran successfully (for the part that matters).
Now go to your SMF converted forum and try to login with your admin user (maybe you need to reset your password). After you login, make sure you run the maintenance tasks "recount totals" and "find and fix errors". That will perform the tasks that failed at the end of the conversion ;)

Don't forget to remove the converter files too ;)
Title: Re: [SMF Converter] vBulletin 4.0
Post by: bubus66 on May 19, 2016, 07:45:39 AM
Thank you said you did it and now I ran into this error

(http://s5.postimg.org/hiq84jqmb/N_vtelen.jpg) (http://postimg.org/image/hiq84jqmb/)
Title: Re: [SMF Converter] vBulletin 4.0
Post by: margarett on May 20, 2016, 08:49:03 AM
Sorry I don't understand. Why are you running the converter again? It did ran successfully the first time (and I don't know why that error triggers now, if it's the same setup)
Title: Re: [SMF Converter] vBulletin 4.0
Post by: GL700Wing on May 22, 2017, 07:29:15 AM
Just discovered this converter does not work with SMF 2.0.14 - following errors in first step:
[22-May-2017 11:09:10 UTC] PHP Notice:  Undefined property: mysqli_result::$EOF in ~/convert.php on line 2732
[22-May-2017 11:09:10 UTC] PHP Notice:  Undefined property: mysqli_result::$Fields in ~/convert.php on line 2736
[22-May-2017 11:09:10 UTC] PHP Notice:  Trying to get property of non-object in ~/convert.php on line 2737
[22-May-2017 11:09:10 UTC] PHP Fatal error:  Call to undefined method mysqli_result::MoveNext() in ~/convert.php on line 2742

Uninstalled SMF 2.0.14 update and the converter works perfectly again with SMF 2.0.13
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Macabreo on June 06, 2017, 07:31:51 AM
Thank you for tool. Works great.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: Dzonny on September 30, 2017, 08:28:23 AM
Hello there.

Can you double-check if the mysql user for your forum has permissions to access the vBulletin database? As far as I'm aware databases should not be merged, it should work fine for you like it is now
Title: Re: [SMF Converter] vBulletin 4.0
Post by: twitch1 on September 30, 2017, 09:17:10 AM
That was part of the problem, thank you!
Title: Re: [SMF Converter] vBulletin 4.0
Post by: NCDiesel on March 17, 2018, 11:07:24 PM
Trying to convert a vbulletin 4.2  board to SMF 2.0.14.   Both forum's software installations are on the same machine, both databases are on the same database server, both forums work fine individually(the SMF board is empty but works).  I have one single database user on the database server and it had full admin privileges for both databases.   Trying to convert I get this error:

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of vBulletin 2. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.

The error that was received from the Database was: Incorrect database name ''

I get this error at the top of the page:


Notice: Undefined variable: dbname in /home/XXXXXXXX/XXXXXXXX/forum/convert.php(452) : eval()'d code on line 1

(the "XXX"s were added by me for privacy)

Researching this error here in the SMF community shows lots of mentions of this error but very little in the way of fixes.  It appears that the convertor is not finding or reading the config.php file in the vbulletin installation, but there is nothing definitive that I can see.

Any ideas?
Title: Re: [SMF Converter] vBulletin 4.0
Post by: NCDiesel on March 18, 2018, 11:31:47 AM
A late night session fixed this.

1 - I used the "I only have a database backup of vbulletin" method.  This seemed more simple and direct.
2 - Someone posted a mildly different version of the convertor on this board.  https://www.simplemachines.org/community/index.php?topic=535265.20 (https://www.simplemachines.org/community/index.php?topic=535265.20).  Using this I got farther.
3 - Then I was required to do a little php programming to comment out the massaging of some return values that were erroring out and seemed to be unnecessary(see functions like convert_fetch_assoc).  Errors were specific to the use of EOF and Fields attributes.  These are using some techniques that seem to be deprecated or have at least changed using php 7.1.  I simply changed the routines(2 or 3 of them) to return the result unmolested.  This was was a total and complete hack so I wont post what I did. Someone who understands them better should post a fix.

Anyways, board converted fine after this!  I have all my images, users, etc and I have yet to find anything wrong or wonky.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: MisterVertigo on August 20, 2018, 05:23:21 PM
My apologies for posting in an old thread, but I'm currently testing converting a vBulletin 4.2.1 to SMF. I've had to try a few times, but just about everything appears to be working (or appears to anyway) except for just a few small things.

First, I have an issue with the polls on my threads. For some reason, the first letter of each poll option is missing. So instead of three options of "Yes, No, Maybe" I get "es, o, aybe" The results appear to be OK, just the labels. It's REALLY strange.

Second, I have an issue with escaped characters like single and double quotes. Each of our members have an admin-set custom title that they cannot change. It's their first and last name, and if they have a nickname, it's in double-quotes in between. For example, John "Nickname" Doe. However, it appears as John \"Nickname\" Doe after the conversion. I can go into the Member account and manually enter the value and it shows up perfectly. The same thing happens in Poll choices, with words like "Can't" showing up as "Can\'t".

Third, we have a post template that we use on our current forums that creates an HTML table (like a form) in a post using BB code. When I look at a converted thread the post shows all of the BB code instead of actually converting it. If I edit the post without making any changes, and then save again, the post looks normal with the BB code being converted to HTML.

None of these are real deal-breakers, but it sure would be great if I had a way to convert these items properly. Has anyone else ran into any issues like these? Thank you all in advance!
Title: Re: [SMF Converter] vBulletin 4.0
Post by: FF|Skyrider on March 12, 2019, 05:35:07 PM
Trying to convert vB 4.2.5 to the latest SMF.. it's stuck at "converting members" though.. it's like it's not doing anything.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: vbgamer45 on March 12, 2019, 05:44:24 PM
Try the convert.php from
https://github.com/SimpleMachines/converters/tree/master/SMF2.0/Vbulletin/3.7
Title: Re: [SMF Converter] vBulletin 4.0
Post by: cnkrc on April 03, 2020, 02:15:04 PM
 Hello,

Just downloaded 4.0 converter for SMF 2.0.17. First 5 steps completed; however I got 'converting topic... unsuccessful!':
SELECT
t.threadid AS id_topic, t.forumid AS id_board, t.sticky AS is_sticky,
t.pollid AS id_poll, t.views AS num_views, t.postuserid AS id_member_started,
CASE WHEN (ISNULL(ul.userid) OR TRIM(ul.userid) = '') THEN 0 ELSE ul.userid END AS id_member_updated,
t.replycount AS num_replies,
IF(t.open, 0, 1) AS locked, MIN(p.postid) AS id_first_msg,
MAX(p.postid) AS id_last_msg
FROM `muziktek_vb428`.thread AS t
INNER JOIN `muziktek_vb428`.post AS p ON (p.threadid = t.threadid)
LEFT JOIN `muziktek_vb428`.user AS ul ON (ul.username = t.lastposter)
GROUP BY t.threadid
HAVING id_first_msg != 0
AND id_last_msg != 0
LIMIT 0, 500;
Caused the error:
1055.

Do you have any solution or suggestion?
Title: Re: [SMF Converter] vBulletin 4.0
Post by: vbgamer45 on April 03, 2020, 02:29:43 PM
Quick fix if you have access to your mysql config such as my.cnf or my.ini is to set
sql_mode =""
Then restart MySQL
Title: Re: [SMF Converter] vBulletin 4.0
Post by: bubus66 on May 27, 2020, 11:53:32 AM
Hi I want to ask for a little help.

I wanted to convert VBulliten 4.2.3 to SMF 2.17. I get the error shown in the picture.

Thanks in advance.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: vbgamer45 on May 27, 2020, 12:29:27 PM
Are you using the latest convert.php from the the SMF site from convertors?
Title: Re: [SMF Converter] vBulletin 4.0
Post by: bubus66 on May 27, 2020, 12:38:27 PM
Thanks for downloading it https://download.simplemachines.org/index.php?converters;id=3
Title: Re: [SMF Converter] vBulletin 4.0
Post by: vbgamer45 on May 27, 2020, 12:45:16 PM
Did you use that one?
Title: Re: [SMF Converter] vBulletin 4.0
Post by: bubus66 on May 27, 2020, 12:49:08 PM
Yes you can also do this https://www.simplemachines.org/community/index.php?topic=404729.msg2817673#msg2817673 it posted what's in the picture the other isn't doing anything
Title: Re: [SMF Converter] vBulletin 4.0
Post by: robertpatton on October 03, 2021, 11:02:08 AM
@ TE: my solution was solved according to your experienced answer which helps me better than others.

Title: Re: [SMF Converter] vBulletin 4.0
Post by: dorans on January 31, 2023, 11:33:13 AM
Hi!
Is it possible to convert VB 4.2.5 to the latest SMF with this converter?
Title: Re: [SMF Converter] vBulletin 4.0
Post by: vbgamer45 on January 31, 2023, 11:49:07 AM
No you would have to go to SMF 2.0.19 then upgrade to SMF 2.1
Title: Re: [SMF Converter] vBulletin 4.0
Post by: dorans on January 31, 2023, 11:51:58 AM
OK thanks :)
Title: Re: [SMF Converter] vBulletin 4.0
Post by: dorans on February 12, 2023, 05:23:25 AM
get this error and the path is correct.

Unable to find the settings for vBulletin 4.0. Please double check the path and try again.
Smf is at "smf.ddddd.com" vb is at "ddddd.com"
Any ideas?
Title: Re: [SMF Converter] vBulletin 4.0
Post by: dorans on February 13, 2023, 01:43:51 PM
Help :)
Title: Re: [SMF Converter] vBulletin 4.0
Post by: vbgamer45 on February 13, 2023, 02:09:07 PM
The scripts looks for present of these two files in the path
"/admin/config.php", "/includes/config.php"
Title: Re: [SMF Converter] vBulletin 4.0
Post by: dorans on February 13, 2023, 04:14:04 PM
VB has admincp and no config.php ?
"/includes/config.php" I put 777
Title: Re: [SMF Converter] vBulletin 4.0
Post by: vbgamer45 on February 13, 2023, 04:41:09 PM
Edit the .sql file and remove the reference to "/admin/config.php", and see if that helps
Title: Re: [SMF Converter] vBulletin 4.0
Post by: dorans on February 13, 2023, 05:02:50 PM
Thanks for the effort anyway.

No unfortunately I still get the message "
Unable to find the settings for vBulletin 4.0. Please double check the path and try again." If I put the domain var.www.vhost....domain

If I put var.www.vhost... httpdocs then this message goes...

"Sorry, the database connection information used in the specified installation of SMF cannot access the installation of vBulletin 4.0. This may either mean that the installation does not exist, or that the Database account used does not have permissions to access it.

The error that was received from the Database was: 1142"
Title: Re: [SMF Converter] vBulletin 4.0
Post by: vbgamer45 on February 13, 2023, 05:30:13 PM
Make sure your SMF database user has permission to access the vbulletin database.
Title: Re: [SMF Converter] vBulletin 4.0
Post by: dorans on February 13, 2023, 06:11:50 PM
As far as I can see, he is right, now I have created a forum in the VB database, the same database, only a different prefix, both forums work and again the same message... I will have to wait for a colleague who understands better than me. I don't do something well for days...
Thank you for your time... :)