Easy Guestbook conversion

[bigjens]

Hi Forum,
i am sorry to bring this issue up again but i am a bit lost here. I am trying to import an Easy Guestbook databse into the Phoca database. I am building the import file as described in the conversion guide from Jan Broos and i get the following error when i try to import the file:

Code: Select all

#1064 - 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 ' `gbtext`, `gbdate`, `published`, `0000-00-00 00:00:00`, `gbid`, , `0`, `0000-00' at line 1

Any help appreciated here. Thanks!
BigJ.

[Jan]

Hi, the only advice I can add you is checking all the columns in database (if there are columns which are in sql queries). As I didn't do the coversation yet, no more ideas there

Jan