[SMF Converter] Vanilla 1.1.x

[JayBachatero]

Software: Vanilla
Version: 1.1.x

This is a converter for Vanilla board.  This just convert Members, Boards, Topics, Posts and Basic Settings.  I add any add-ons support, so this will just convert a vanilla install of Vanilla .

Notes:
- Set SMF to UTF-8 mode since Vanilla is set to UTF-8 by default.

Changelog
! Convert some basic settings.
! Initial upload.

convert.php
Use this convert.php with the .sql file attached in this topic.

[johnblade]

Thank you so much, this is just what I've been needing!  With this I can make the switch back to SMF!

I had some difficulties at first because it wasn't finding the right Vanilla tables because the prefix for some reason wasn't in the Vanilla configuration file.

So I changed the SQL file to: ---~ from_prefix: "`$Configuration[DATABASE_NAME]`.LUM_"

and it worked a treat.

[JayBachatero]

Umm.  I guess that if you don't change the prefix the variable doesn't get created.  Need to make a change for that.

[shirasnetwork]

Guys... any one know how to fix this error.

Notice: Undefined index: DATABASE_TABLE_PREFIX in /home/****/public_html/forums/convert.php(398) : eval()'d code on line 1
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 '.User' at line 2

[SleePy]

What version of Vanilla are you using?
This converter was made for the 1.1 version.

The error says that the database table prefix variable it was looking for couldn't be found.

[tmchukudzi]

Software: Vanilla
Version: 1.1.x

This is a converter for Vanilla board.  This just convert Members, Boards, Topics, Posts and Basic Settings.  I add any add-ons support, so this will just convert a vanilla install of Vanilla .

Thanks... finally a converter.... how does this work, exactly? How do I install it?

[SleePy]

http://docs.simplemachines.org/index.php?board=4.0

[tmchukudzi]

http://docs.simplemachines.org/index.php?board=4.0

merci...'preciate it

[tmchukudzi]

i'm getting an error, #1064 - 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 '---~ name: "vanilla"
---~ version: "SMF 1.1"
---~ settings: "/conf/database.' at line 1

[SleePy]

Try to redownload the file with a different browser.
The file is corrupted.

[tmchukudzi]

i was using firefox before, now i've tried IE and it's the same error...

[SleePy]

Are you trying to run it in phpmyadmin?

The script does not get run in phpmyadmin. You use the attached convert.php with it.
Both of these get uploaded to the SMF folder and ran through the browser. The .sql has instructions for the convert.php file on how to complete the conversion.

[tmchukudzi]

Ok, thanks, so could you tell me what to do, exactly, step by step, if you don't mind? Sorry to bother you...this is a little frustrating and my boss wanted it three hours ago....when I click on the convert.php link, i get to a page that does not have vanilla in the list. The .sql says 'the convert.php does everything for you.' if someone could explain it to me like i was a 2 year old and had no clue what any of this stuff is, that would be nice. i'm new to this forum so i don't exactly know how everything works and where everything is.thanks in advance.

[SleePy]

The convert.php is the page you want.
It should say path to vanilla which is your key that it has the right .sql file.

You just tell it the path to vanilla, then SMF (shouldn't need changed if you uploaded convert.php to the same directory as your SMF files) and then your SMF mysql password (for security reasons).

[tmchukudzi]

ok, now i have a SELECT command denied error. i've tried to add the smf database to the vanilla database as recommended on the common errors page but it doesn't seem to be working, am i doing it wrong? how do i add one database to another? i have cpanel.

[tmchukudzi]

..any chance i could just pay someone to do this for me? i'm sure it would take seconds but it's frustrating me and i'm working for someone..

[JayBachatero]

If you can't add the SMF database user to the vanilla database then I suggest that you install SMF in the same database as vanilla with the same credentials.

[tmchukudzi]

sigh. i don't know what you're talking about, but i'll do what i can and if it doesn't work out then it doesn't. thanks.

[vivek_cbe]

Thank you so much, this is just what I've been needing!  With this I can make the switch back to SMF!

I had some difficulties at first because it wasn't finding the right Vanilla tables because the prefix for some reason wasn't in the Vanilla configuration file.

So I changed the SQL file to: ---~ from_prefix: "`$Configuration[DATABASE_NAME]`.LUM_"

and it worked a treat.

thanks to you buddy, this worked like a charm!

[SleePy]

sigh. i don't know what you're talking about, but i'll do what i can and if it doesn't work out then it doesn't. thanks.

Don't be afraid to ask your host for help on how to have the same mysql user be able to access two databases. Since these things may differ for each host, it is best to ask them so you are getting the specifics on how to accomplish this

The converter uses a single mysql connection to the same mysql database. So it uses the same login conditionals that SMF uses. This is why the MySQL user for SMF has to have access to the Vanilla database.

[palofdru]

nice running into this! any reason why it wasnt with the downloads on the converter page?

http://www.simplemachines.org/download/?converters

[SleePy]

It doesn't appear it is in SVN, so it didn't get generated to be put on the downloads page with the next release of SMF.

I will get it in SVN so when the next release of SMF occurs it will be put on the downloads page

[jonnyblue]

First of all, thanks for this converter. It worked great!

The only problem I encountered is that the passwords are not valid, users having to reset them.

Is there a way to avoid this?

[ThorstenE]

mhh, I think the vanilla forum works with md5 encryption for the passwords (and SMF can handle these passwords).. Maybe they changed their encryption in the latest release? Do you have any infos about their encryption?

[jonnyblue]

They still use md5 hash in 1.1.5. It's weird because the password works for some users, but not for others.

[SleePy]

It may be possible that Vanilla changed how they hash their passwords (even if they still use md5 that they do it with a salt or in a different order).

[layusn1]

I hate to dig up old threads but...I have installed the smf and it is working but the convert.php is.  I get these errors...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/content/l/a/y/layusn1/html/smf/convert.php on line 799

Notice: Undefined index: DATABASE_TABLE_PREFIX in /home/content/l/a/y/layusn1/html/smf/convert.php(407) :eval()'d code on line 1

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Vanilla. 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: Table 'amm0708001535892.User' doesn't exist[/]

Any ideas?  I have a forum of over 3000 members that are really tired of Vanilla and I don't want to start losing them.  I am using version 1.1.5  My mysql database is amm0708001535892.  I don't know if it is the convert.php causing the .user addition.  If so is there a way to fix it?  I would really like to get this converted.  Thanks all.

[ThorstenE]

I think the converter is unable to detect the database prefix from your vanilla installation..
DATABASE_TABLE_PREFIX

can you check this file please: /conf/database.php
is there a line or something similar in it?

Code Select Expand

$Configuration['DATABASE_TABLE_PREFIX'] = 'vanilla_';

If your vanilla doesn't use a table prefix you can also change the vanilla_to_smf.sql:

find:

Code Select Expand

---~ from_prefix: "`$Configuration[DATABASE_NAME]`.$Configuration[DATABASE_TABLE_PREFIX]"
and replace it with:

Code Select Expand

---~ from_prefix: "`$Configuration[DATABASE_NAME]`."

[paratus13]

I am trying to convert from vanilla 1.1.10 and this is the error I get:

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Vanilla. 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: SELECT command denied to user 'bro1008107511003'@'97.74.215.186' for table 'User'

I did what we suggested:

find:
Code: [Select]
---~ from_prefix: "`$Configuration[DATABASE_NAME]`.$Configuration[DATABASE_TABLE_PREFIX]"
and replace it with:
Code: [Select]
---~ from_prefix: "`$Configuration[DATABASE_NAME]`."

and still get the error.

[Oldiesmann]

Pay attention to that error message. It means that the user connecting to that database doesn't have permission to SELECT things from that table. Make sure you give that user SELECT privileges for all tables in the Vanilla database.

[Norv]

Please see:
Common conversion errors.