Hallo,
Hatte vor mein phpBB nach SMF zu konvertieren.
Meines Wissens (die Instalation ist doch schon ein paar Jährchen her), hatte ich keine Mods installiert, aber die Fehlermeldung die ich bekomme behauptet auch die SQL-Syntax wäre nicht korrekt...?
Bin leider nicht grad der SQL-Pro, aber kann hier vielleicht jemand damit was anfangen?
MfG,
Skatepunk
Converting ranks... Successful.
Converting groups... Successful.
Converting members... Unsuccessful!
This query:
SELECT
u.user_id AS ID_MEMBER, SUBSTRING(u.username, 1, 80) AS memberName,
SUBSTRING(u.username, 1, 255) AS realName,
SUBSTRING(u.user_password, 1, 64) AS passwd, u.user_lastvisit AS lastLogin,
u.user_regdate AS dateRegistered,
SUBSTRING(u.user_from, 1, 255) AS location,
u.user_posts AS posts, IF(u.user_level = 1, 1, mg.ID_GROUP) AS ID_GROUP,
u.user_new_privmsg AS instantMessages,
SUBSTRING(u.user_email AS emailAddress, 1, 255) AS emailAddress,
u.user_unread_privmsg AS unreadMessages,
SUBSTRING(u.user_msnm AS MSN, 1, 255) AS MSN,
SUBSTRING(u.user_aim AS AIM, 1, 16) AS AIM,
SUBSTRING(u.user_icq, 1, 255) AS ICQ,
SUBSTRING(u.user_yim, 1, 32) AS YIM,
SUBSTRING(u.user_website, 1, 255) AS websiteTitle,
SUBSTRING(u.user_website, 1, 255) AS websiteUrl,
u.user_allow_viewonline AS showOnline, u.user_timezone AS timeOffset,
IF(u.user_viewemail = 1, 0, 1) AS hideEmail, u.user_avatar AS avatar,
REPLACE(u.user_sig, '\n', '<br />') AS signature,
u.user_sig_bbcode_uid AS signature_uid, u.user_avatar_type,
u.user_notify_pm AS pm_email_notify, u.user_active AS is_activated,
'' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS messageLabels,
'' AS personalText, '' AS timeFormat, '' AS usertitle, '' AS memberIP,
'' AS secretQuestion, '' AS secretAnswer, '' AS validation_code,
'' AS additionalGroups, '' AS smileySet, '' AS passwordSalt,
'' AS memberIP2
FROM `Datenbank`.phpbb_users AS u
LEFT JOIN `Datenbank`.phpbb_ranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
LEFT JOIN `Datenbank`.smf_membergroups AS mg ON (BINARY mg.groupName = CONCAT('phpBB ', r.rank_title))
WHERE u.user_id != -1
GROUP BY u.user_id
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 emailAddress, 1, 255) AS emailAddress,
u.user_unread_privms
Einfach mal suchen...
[gelöst] problem mit converter von phpbb2 (http://www.simplemachines.org/community/index.php?topic=108253.0)
Convert wbb 2.3.5 zu SMF 1.1 RC3 fehlgeschlagen (http://www.simplemachines.org/community/index.php?topic=110145.0)
[gelöst] IPB 1.3 > SMF 1.1 RC3 - Converter-Problem (http://www.simplemachines.org/community/index.php?topic=109698.0)
argh, Suchfunktion... :-[
Danke :)