#1064 - You have an error in your SQL syntax

Hi,

I have read all previous post relating to this, but I am still unable to get my head around the problem and need a little hand holding.

I exported a db before having a server turned off. On a new server I am now trying to import the db via phpMyAdmin.

Unfortunately I do not have access to the old derver to make another backup in a compatible mode.

Here is the error I am getting, is all lost?

Thanks,

Luv2.


Error

SQL-query :  

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 defaultCURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`HITS` int( 11 ) NOT NULL default '0',
`SYMBOLIC` int( 11 ) NOT NULL default '0',
`SYMBOLIC_ID` int( 11 ) NOT NULL default '0',
`newsFile` varchar( 5 ) NOT NULL default '',
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 AUTO_INCREMENT =193DEFAULT CHARSET = latin1

MySQL said:


#1064 - You have an error in your SQL syntax near 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `HITS` int(11) NOT NULL default' at line 8