ciao a tutti questo รจ il mio primo post...
ho iniziato la procedura con il Converter per passare a Smf da Snitz ma mi da questo errore:
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting posts (this may take some time)... Unsuccessful!
This query:
SELECT
ft.TOPIC_ID AS ID_TOPIC, ft.FORUM_ID AS ID_BOARD, T_SUBJECT AS subject,
UNIX_TIMESTAMP(REPLACE(ft.T_DATE, '\0', '')) AS TposterTime, T_AUTHOR AS TID_MEMBER,
T_IP AS TposterIP, IFNULL(ftm.realName, '') AS TposterName,
REPLACE(REPLACE(T_MESSAGE, '\n', '<br />'), '\r', '') AS Tbody,
IFNULL(ftm.emailAddress, '') AS TposterEmail, fte.realName AS TmodifiedName,
UNIX_TIMESTAMP(REPLACE(ft.T_LAST_EDIT, '\0', '')) AS TmodifiedTime,
UNIX_TIMESTAMP(REPLACE(fr.R_DATE, '\0', '')) AS RposterTime, R_AUTHOR AS RID_MEMBER,
R_IP AS RposterIP, IFNULL(frm.realName, '') AS RposterName,
REPLACE(REPLACE(REPLACE(R_MESSAGE, '\n', ''), '\r', ''), M_SIG, '') AS Rbody,
IFNULL(frm.emailAddress, '') AS RposterEmail, fre.realName AS RmodifiedName,
UNIX_TIMESTAMP(REPLACE(fr.R_LAST_EDIT, '\0', '')) AS RmodifiedTime
FROM (`snitz`.FORUM_TOPICS AS ft, `snitz`.FORUM_REPLY AS fr)
LEFT JOIN `smf`.smf_members AS ftm ON (ftm.ID_MEMBER = ft.T_AUTHOR)
LEFT JOIN `smf`.smf_members AS fte ON (fte.ID_MEMBER = ft.T_LAST_EDITBY)
LEFT JOIN `smf`.smf_members AS frm ON (frm.ID_MEMBER = fr.R_AUTHOR)
LEFT JOIN `smf`.smf_members AS fre ON (fre.ID_MEMBER = fr.R_LAST_EDITBY)
WHERE fr.TOPIC_ID = ft.TOPIC_ID
ORDER BY IFNULL(fr.R_DATE, ft.T_DATE)
LIMIT 0, 100;
Caused the error:
Unknown column 'M_SIG' in 'field list'
non essendo pratico di DB non saprei proprio dove parare...
al limite potrei postare l'allegato del DB Mysql se qualcuno mi facesse questo piacere di dargli almeno una guardata...
Grazie