PDA

View Full Version : migrare da Snitz forum a Smf..problema DB


lillo68
16-11-2008, 13:26
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:
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 un'occhiata...

Grazie

cionci
16-11-2008, 15:57
Ti sposto nella sezione adatta

lillo68
16-11-2008, 16:24
scusami...:(
grazie