Posted by ulyx on 12/13/06 12:12

Thank you for your time and help.
I have read links that u have posted and tryed this:

CREATE TABLE `ae_gallery` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(64) character set utf8 NOT NULL,
`ext` varchar(8) character set utf8 NOT NULL,
`image_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
ON UPDATE CURRENT_TIMESTAMP,
`data` mediumblob NOT NULL,
PRIMARY KEY (`id`)
);

and i get the same error ( i get just #1064 and text description ).

If i remove DEFAULT CURRENT_TIMESTAMP
ON UPDATE CURRENT_TIMESTAMP
everything is working perfect.

How to add/change this field manualy ?

[Back to original message]