Hello :)
Fresh install of SMF 2
Vanilla forum 2.0.9
Same server, separate databases
The message I am getting on the convert is Unable to find the settings for Vanilla. Please double check the path and try again.
PATH TO SMF /home/*****/public_html/community
PATH TO VANILLA /home/*****/public_html/forum
Have I done that bit right? Help gratefully received please.
Hello there, and welcome to SMF!
Can you please tell, does your Vanilla installation have a folder /conf, with a file database.php and/or settings.php in it?
That seems to be
/home/*****/public_html/forum/conf/database.php,
respectively
/home/*****/public_html/forum/conf/settings.php
The config.php, yes, the database.php no, that is not in conf folder
config.php?
You might want to try then... in vanilla_to_smf.sql:
---~ settings: "/conf/database.php", "/conf/settings.php"
---~ settings: "/conf/config.php", "/conf/settings.php"
then restart the converter.
I will do that, thank you
er there is no settings.php there either, just the config.php
No database.php anywhere I can see, nor settings.php
That's okay, please try the code replacement above. It could also be without settings.php, but the enumeration is there only to give an extra chance (maybe the first file will be found, maybe the second), it doesn't hurt.
You can however, since it's obviously this one, simplify it as you say:
---~ settings: "/conf/config.php"
I tried that :( I now get a white page of death and nothing else.
If I go into the new community area nothing has changed. Looks like it doesn't work for me :(
It surely should work, it's just a bit unexpected for the moment. My Vanilla has differently named configuration files... :)
If you want, you can try any of:
1) send me in a PM the content of the config file (feel free to alter passwords and such, however please keep the format intact), perhaps I can figure out what is wrong with it
2) or, you could create a new file (lets not mess this config.php one, so that your Vanilla installation won't be affected in any way), name it, lets say, config2.php, and add to it:
<?php
$Configuration['DATABASE_NAME'] = 'your_database_name';
$Configuration['DATABASE_TABLE_PREFIX'] = 'your_vanilla_table_prefix';
?>
(If you don't know any, please see in config.php - open it in a reasonable code editor (like Notepad++ on windows), and you should see the data in it)
Then please adapt again the converter, to point to config2.php this time. (sorry :))
---~ settings: "/conf/config2.php"
Ok with your help I am getting there :)
I made a config2 and put it in the folder
I then tried convert but my database user for SMF did not have permission to use the Vanilla database so I easily remedied that by giving permission and it accepted. However
I have been using a WP3 bridge, Proxy Connect SSO, and that may have caused the next error so am unsure what to do next. I have disabled the bridge but that made no difference.
-------------------------
Converting members...
Unsuccessful!
This query:
SELECT
m.UserID AS id_member, m.Name as member_name, m.DateFirstVisit AS date_registered,
(m.CountDiscussions + m.CountComments) AS posts, m.DateLastActive AS last_login,
CASE m.RoleID WHEN 4 THEN 1 ELSE 0 END AS id_group, m.Password AS passwd,
CONCAT_WS(' ', m.FirstName, m.LastName) AS real_name, m.Email AS email_address,
CASE m.UtilizeEmail WHEN 1 THEN 0 ELSE 1 END as hide_email, m.Picture AS avatar,
m.RemoteIp AS member_ip, m.RemoteIp AS member_ip2, '' AS password_salt,
'' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS message_labels,
'' AS personal_text, '' AS time_format, '' AS usertitle, '' AS secret_question,
'' AS secret_answer, '' AS validation_code, '' AS additional_groups, '' AS smiley_set
FROM `*****_vanilla`.GDN_User AS m
LIMIT 0, 500;
Caused the error:
Unknown column 'm.RoleID' in 'field list'
-----------------------------------
By the way, I wanted to say I really appreciate the help you are giving me!
:(
I'm afraid this may take a little longer however, than I thought. It's not the bridge. I installed Vanilla 2.0.11 and I see that in the 2.0 line they have made quite a number of database changes. Our converters were written for Vanilla 1.1.x..
I'll come back on this asap.
Aw thank you!
I'm much interested in this too, and would love if a 2.X.X supported converter!
would really like a 2.xx converter! :D
Just a little bump, ever so small, just to see if anyone is upgrading this within the forseeable future as I am stuck with a forum I dont want and I REALLY want to use SMF instead :)
Quote from: 1stAngel on October 21, 2010, 09:37:23 AM
Just a little bump, ever so small, just to see if anyone is upgrading this within the forseeable future as I am stuck with a forum I dont want and I REALLY want to use SMF instead :)
Sorry for the delay, if no one else do it I could give it a look, if you can send me a copy of your database that would help me a lot :)
Not sure what you mean database.... you mean my vanilla sql?
Quote from: 1stAngel on October 24, 2010, 06:26:30 PM
Not sure what you mean database.... you mean my vanilla sql?
Yep, if possible it could be useful, if you can't do it don't worry :)
I can do it. How should I send it?
If isn't pretty big you could email me the compressed database: nibogo2 [at] gmail [dot] com
No, its not big as its a pretty new forum, not a lot on it, but I missed SMF so much I wanted that back but cant lose this LOL
I will send as soon as I have downloaded it.
Received thanks, I'll work on it as soon as possible :)
Hmm just realised I have some mods on it and that may screw up the Vanilla you are working on. You may have to remove those from the SQL first
It shouldn't really be a problem, I think. Vanilla is free and is available for download, so we have a brand new copy as well (and a converter should of course work on those as well). So if the in-progress converter would work with some fields added by mods, it would choke on the fresh install - this way he'd know. :)
The important point of real-world data, such as your database, is to see what surprises can the real data hold. The converters aren't always ready for any surprise (even breakage) that may appear in the databases of the other software.
Ok cool :) No worries. Thank you for explaining, I appreciate it.
Yep, as Norv said real databases are pretty useful to know have some cases when the converter may fail, that's why now I'll try to have a real database to test the converters first :)
About mods don't worry, they shouldn't be a problem ;)
MANY thanks to you. I now have a forum working on SMF!! I really appreciate this guys, you are awesome!!
Quote from: 1stAngel on October 26, 2010, 03:10:55 PM
MANY thanks to you. I now have a forum working on SMF!! I really appreciate this guys, you are awesome!!
Glad you like it, the public release will be do it pretty soon (maybe tonight)
is it possible to get the early release sent on pm?
been waiting for this for days now :P, tried doing my own changes to the converter but it seemed a bit more advance then expected
Here's the converter: http://www.simplemachines.org/community/index.php?topic=407112.0