SMF Support > Converting to SMF
[SMF Converter] Vanilla 2
kevl:
Please? Someone :-X
--- Quote from: kevl on November 11, 2011, 08:43:31 PM ---OK got a little further -
Converting members... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts...Wrong value type sent to the database. Integer expected. (id_board)
--- Quote from: kevl on November 11, 2011, 05:35:53 PM ---Hello,
I am getting this same error from thread:
http://www.simplemachines.org/community/index.php?topic=405111.0
Using this new converter. I am stumped.
----------------------------------
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'
----------------------
--- End quote ---
--- End quote ---
kevl:
Really??? No one can help with this? ???
Oldiesmann:
For being such a simple system, Vanilla's codebase is extremely complex and confusing :o
It looks like they've moved users' role info to its own table, so try this...
In the vanilla_to_smf.sql file
Find
--- Code: --- CASE m.RoleID WHEN 4 THEN 1 ELSE 0 END AS id_group, m.Password AS passwd,
--- End code ---
Replace
--- Code: --- CASE mr.RoleID WHEN 4 THEN 1 ELSE 0 END AS id_group, m.Password AS passwd,
--- End code ---
Find
--- Code: ---FROM {$from_prefix}User AS m;
--- End code ---
Replace
--- Code: ---FROM {$from_prefix}User AS m
LEFT JOIN {$from_prefix}UserRole AS mr ON (m.UserID = mr.UserID);
--- End code ---
kjaonline:
Hello I'm getting this error.
--- Code: ---Notice: Use of undefined constant PATH_LOCAL_CACHE - assumed 'PATH_LOCAL_CACHE' in /home/kjalcord/public_html/tipidcdo.com/conf/config-defaults.php on line 26
--- End code ---
madzilla:
Just curious as to whether this will work on 2.0.17.3? I think the config files are in different locations.
Regardless, when I try to run it I get the open_basedir error despite Vanilla being in /forum and SMF being in /newforum.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version