migrare da Snitz forum a Smf..problema DB

  • Creatore Discussione Creatore Discussione WpStyle
  • Data di inizio Data di inizio

WpStyle

Utente Attivo
25 Gen 2004
611
0
16
Pistoia
www.animalfestival.net
Devo passare da Snitz Forum che usa DB Access a Smf che usa Mysql
tramite una guida su Aruba e dopo varie peripezie sono riuscito a convertire Access in Mysql ottenendo quindi un file miofile.sql
ho iniziato la procedura con il Converter di Smf per passare a Smf da Snitz, qualcosa è riuscito a convertire ma poi mi da questo errore:

Codice:
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 un'occhiata...

Grazie
 

Discussioni simili