Re: MySQL import error

[tessthepup]

Hi Guys,

I am in the process of changing hosts and moving to 20i.

I am trying to import my zipped database backup into phpmyadmin but receiving this error. The table is not standard Phoenix Cart its an import module I am working on.

#1067 - Invalid default value for 'created_at'

This is the sql. I have googled the error but can not seem to find a fix that works.

CREATE TABLE store_manual_categories ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, parent_id int(11), feed_category_path text, created_at timestamp default 'current_timestamp()', PRIMARY KEY (id), KEY idx_parent_id (parent_id), KEY idx_name (name));

Any help would be appreciated.

Thanks

Mark

[burt]

What is

'current_timestamp()'

?

Change it to

CURRENT_TIMESTAMP

[tessthepup]

What is

'current_timestamp()'

?

Change it to

CURRENT_TIMESTAMP

@burt thanks Gary not sure why it did not work when I did it before but hey ho it works now lol