Hi

I maintain a PHP MySQL opensource project and am currently betaing a new version. I ahve the follwoing code:

This works fine for me running MySQL 4.1.7 and 4.1.18 - but I have just had an error reported:

SQL Error DB function failed with error number 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, PRIMARY K SQL=CREATE TABLE `jos_wats_highlight` ( `watsid` int(11) NOT NULL default '0', `ticketid` int(11) NOT NULL default '0', `datetime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`watsid`,`ticketid`) );
SQL =
CREATE TABLE `jos_wats_highlight` (
`watsid` int(11) NOT NULL default '0',
`ticketid` int(11) NOT NULL default '0',
`datetime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`watsid`,`ticketid`)
);

Does anyone know what is causing this? They are using MySQL 4.0.24

Thanks!

most likely cause of error: that syntax is not supported prior to 4.1

but it isn't needed anyway, it merely describes the behaviour of the 1st timestamp column in any table

Thanks, seems to have solved problems

glad to see your still here on the forums always giving helpful advice