I'm using mySQL 4.2 on Win Server 2008 R2. When I try running the cvd.sql script I get the following error:
ERROR 1064 (42000) at line 72: You have an error in your SQL syntax; check the m
anual that corresponds to your MySQL server version for the right syntax to use
near '(14) NOT NULL,
`Created` datetime NOT NULL default '0000-00-00',
`Start` dat' at line 14
I've checked this script against the mySQL manual but can find nothing wrong with the syntax mentioned in the above error. Could this be a bug or am I missing something obvious from this script?
Please help. Many thanks, J
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm using mySQL 4.2 on Win Server 2008 R2. When I try running the cvd.sql script I get the following error:
ERROR 1064 (42000) at line 72: You have an error in your SQL syntax; check the m
anual that corresponds to your MySQL server version for the right syntax to use
near '(14) NOT NULL,
`Created` datetime NOT NULL default '0000-00-00',
`Start` dat' at line 14
I've checked this script against the mySQL manual but can find nothing wrong with the syntax mentioned in the above error. Could this be a bug or am I missing something obvious from this script?
Please help. Many thanks, J
this is because of timestamp(14). check the syntax for timestamp in MS Server db.
In mysql 5.5, it is only timestamp and not timestamp(14)
Regards,
Pranav
To add to the above….
I can see that `Start` dat' is not the correct syntax but I can't find that term anywhere on the scripts