Hi everybody,
I get an strange error when I try to do the convertion, do you know what can be happen?
QuoteConverting members... Unsuccessful!
This query:
SELECT
uid AS id_member, SUBSTRING(username, 1, 255) AS member_name,
SUBSTRING(username, 1, 255) AS real_name,
SUBSTRING(password, 1, 64) AS passwd, email AS email_address,
postnum AS posts, SUBSTRING(usertitle, 1, 255) AS usertitle,
lastvisit AS last_login, IF(usergroup = 4, 1, 0) AS id_group,
regdate AS date_registered, SUBSTRING(website, 1, 255) AS website_url,
SUBSTRING(website, 1, 255) AS website_title,
SUBSTRING(icq, 1, 255) AS icq, SUBSTRING(aim, 1, 16) AS aim,
SUBSTRING(yahoo, 1, 32) AS yim, SUBSTRING(msn AS msn, 1, 255) AS msn,
SUBSTRING(signature, 1, 65534) AS signature, hideemail AS hide_email,
SUBSTRING(buddylist, 1, 255) AS buddy_list,
SUBSTRING(regip, 1, 255) AS member_ip,
SUBSTRING(regip, 1, 255) AS member_ip2,
SUBSTRING(ignorelist, 1, 255) AS pm_ignore_list,
timeonline AS total_time_logged_in,
IF(birthday = '', '0001-01-01', CONCAT_WS('-', RIGHT(birthday, 4), SUBSTRING(birthday, LOCATE('-', birthday) + 1, LOCATE('-', birthday, LOCATE('-', birthday) + 1) - LOCATE('-', birthday) - 1), SUBSTRING(birthday, 0, LOCATE('-', birthday) - 1))) AS birthdate
FROM vw_users
LIMIT 0, 500;
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 'AS msn, 1, 255) AS msn,
SUBSTRING(signature, 1, 65534) AS signature, hideemail ' at line 10
Thank you!
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
Sorry, but I read it before and I don't understand where my error is solved in this link :(
I would be very grateful I you could explain me,
Thank you.
edit the mybb_to_smf.sql and find
SUBSTRING(msn AS msn, 1, 255) AS msn,
replace it with:
SUBSTRING(msn, 1, 255) AS msn,