Urgent help

[warleb]

I am upgrading my protx payment module and got the following error. This is very strange. Can anyone assist with this at all?? It's very urgent..

 

Error

SQL query:

 

CREATE TABLE `protx_direct` (

 

`id` int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,

`customer_id` int( 11 ) NOT NULL default '0',

`order_id` int( 11 ) NOT NULL default '0',

`vendortxcode` varchar( 40 ) default NULL ,

`txtype` varchar( 16 ) default NULL ,

`value` decimal( 15, 4 ) default NULL ,

`vpstxid` varchar( 50 ) default NULL ,

`status` varchar( 10 ) default NULL ,

`statusdetail` varchar( 100 ) default NULL ,

`txauthno` varchar( 10 ) default NULL ,

`securitykey` varchar( 10 ) default NULL ,

`avscv2` varchar( 50 ) default NULL ,

`address_result` varchar( 20 ) default NULL ,

`postcode_result` varchar( 20 ) default NULL ,

`CV2_result` varchar( 20 ) default NULL ,

`3DSecureStatus` varchar( 12 ) default NULL ,

`CAVV` varchar( 32 ) default NULL ,

`txtime` timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,

UNIQUE KEY `id` ( `id` )

) ENGINE = MYISAM AUTO_INCREMENT =1

 

MySQL said:

 

#1064 - 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,

UNIQUE KEY `i

[dittones]

Steve,

Try UNIQUE KEY id ( id )

 

I hope this helps...

Roman

dittone.com

[♥FWR Media]

Not a clue.

 

I tried this on both MySQL 4.1 and 5.0.37 in STRICT mode worked fine.