Jump to content

antmay

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

antmay's Achievements

Newbie

Newbie (1/5)

0

Reputation

  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.