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)
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