Error running cvd.sql script

Developers
2012-12-30
2014-08-07
  • Jaafar Altaie
    Jaafar Altaie
    2012-12-30

    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

     
    • Pranav
      Pranav
      2014-08-07

      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

       
  • Jaafar Altaie
    Jaafar Altaie
    2012-12-31

    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