News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Error converting

Started by Løque, February 28, 2009, 06:23:57 PM

Previous topic - Next topic

Løque

When i try to convert phpbb3 to smf i get this error:

Converting posts (this may take some time)... Unsuccessful!
This query:

    INSERT INTO `forum`.smf_messages
    (ID_MSG, ID_TOPIC, posterTime, ID_MEMBER, SUBSTRING(m.subject, 1, 255), posterEmail, posterName, ID_BOARD, posterIP, body, modifiedName, icon)

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 'SUBSTRING(m.subject, 1, 255), posterEmail, posterName, ID_BOARD, posterIP, body,' at line 2
:)

SleePy

Which converter did you use? Have you tried the latest ones on the downloads page?
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Advertisement: