MySQL error ...going from 4.1.14 to 4.1.15

[antmay]

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=InnoDB 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

 

[Echelon17]

Edit:

2 things are wrong with that statement. First off, remove the 'charset=latin1' reference, it won't work. Secondly, your use of the CURRENT_TIMESTAMP is incorrect. What are you trying to achieve?