News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

migrare da Snitz a Smf

Started by kodemondo, November 15, 2008, 10:32:44 AM

Previous topic - Next topic

kodemondo

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

Advertisement: