Error running cvd.sql script

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


  • 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


Log in to post a comment.