When running MySQL on the .mysql file, I got the following error:

ERROR 1064 at line 2: You have an error in your SQL syntax near 'COMMENT 'Short name'
 , description varchar(255) NULL DEFAULT NULL COMMENT 'Shor' at line 3

Comments

Bèr Kessels’s picture

Bèr Kessels commented

I just installed the module, but had no such error. Are you sure its not your local mysl thjat pops this error? Maybe you copy-pasted something wrong.

sulleleven’s picture

sulleleven commented

what version mysql?

I had no such problem adding the database tables. How did you go about it? command line or a php script such as phpmyadmin?

veridicus’s picture

veridicus commented

I don't know much about the details of MySQL admin options, but maybe your server is set to not allow column comments. It seems to not like the keyword COMMENT. On a standard MySQL install comments are allowed. I like to comment as much of my code as possible and I noticed column comments are used a little in other modules.

If many MySQL setups won't allow it I can change it to commented sql. It's just nice to have the info directly in the database in addition to the script if possible. So let us know if your setup somehow disables the option to COMMENT columns.

sillygwailo’s picture

sillygwailo
Location Toronto, ON
commented

I'm closing this as the reporter, because I was able to install it on my localhost box no problem, so it's a MySQL configuration problem rather than a problem with the MySQL schema, and it's not critical to get it installed on the host I was trying to install it on. Whether or not it helps, though, here's the MySQL version information, and I attempted installation through the command line:

mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)

Mad Maks’s picture

Mad Maks commented

i have also the error:

 MySQL retourneerde:
#1064 - You have an error in your SQL syntax near 'COMMENT 'Short name'
,description varchar(255) NULL DEFAULT NULL COMMENT 'Short' at line 3

i have: MySQL 3.23.58

what do i have to do to get it right.

veridicus’s picture

veridicus commented

Take out the COMMENT and everything past it on each line. MySQL's documentation doesn't mark COMMENT as anything special or optional. But I guess since 2 people have had this problem I'll take them out of the sql file.

ideas1’s picture

ideas1 commented

I have the same problem, I deleted the Comment and everything after and it still gives me a an error.

Mad Maks’s picture

Mad Maks commented

your new sgl file in the cvs worked, thanks

veridicus’s picture

veridicus commented