Jump to content

antmay

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Posts posted by antmay

  1. Hi all,
    I'm new to the mySQL and have a question for anyone who can help me.
    The syntax in question is...

    ERROR 1064 at line 19: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
    HITS int(11) N

    And the actual statement is...

    CREATE TABLE PLD_CATEGORY (
    ID int(11) NOT NULL auto_increment,
    TITLE varchar(100) NOT NULL default '',
    TITLE_URL varchar(100) default NULL,
    DESCRIPTION varchar(255) default NULL,
    PARENT_ID int(11) NOT NULL default '0',
    `STATUS` int(11) NOT NULL default '1',
    DATE_ADDED timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
    HITS int(11) NOT NULL default '0',
    PRIMARY KEY (ID),
    KEY PLD_CATEGORY_TITLE_IDX (TITLE),
    KEY PLD_CATEGORY_TITLE_URL_IDX (TITLE_URL),
    KEY PLD_CATEGORY_DESCRIPTION_IDX (DESCRIPTION),
    KEY PLD_CATEGORY_PARENT_ID_IDX (PARENT_ID),
    KEY PLD_CATEGORY_STATUS_IDX (`STATUS`),
    KEY PLD_CATEGORY_HITS_IDX (HITS)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=135 ;

    The sql file is from version 4.1.14 and the problem is occuring in version 4.1.15

    Thanks,
    Anthony
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.