Hi guys,
Could someone please help me? I and trying to upgrade my website from OSMAx1.7 to the new OS2 RC3. I've use mysqldiff to upgrade my database but when I try to import
the new file to my database I am getting the following error message;
Error
SQL query:
#
# DDL START
#
ALTER TABLE address_book ADD entry_company_tax_id varchar( 32 ) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci AFTER entry_company,
MySQL said:
#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 ' ' at line 3
I looked at the online sql manual to see if I could figure out how to fix the problem but the manual just tells you what the error number message means but it doesn't
tell you how to fix the problem. I'm not a coder or programmer so I am having a hard time figuring the out any help would be greatly appreciated guys. This is the
script that is getting the error message, This was created by mysqldiff:
#
# DDL START
#
ALTER TABLE address_book
ADD entry_company_tax_id varchar(32) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci AFTER entry_company,
COMMENT='InnoDB free: 9216 kB';





LinkBack URL
About LinkBacks










Bookmarks