Page 1 of 1

Easy Guestbook conversion

Posted: 11 Mar 2010, 12:17
by 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.

Re: Easy Guestbook conversion

Posted: 11 Mar 2010, 17:51
by 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 :-( :idea: :(

Jan