convert myisam to innodb, error 1067

comeback

I converted my database in innodb with phpMyAdmin.

There are several table that does not It Works, and give me an error

I use the command

ALTER TABLE wp_comments ENGINE=InnoDB;

I have this message

1067 - Invalid default value for 'comment_date'

I have other error messages, but still the number 1067

Do you have an idea of the problem?

Thank you

TheLinuxBug

http://bfy.tw/5DTj

or

http://stackoverflow.com/questions/9192027/invalid-default-value-for-create-date-timestamp-field

Cheers!

comeback

I put in my.cnf

[mysqld]
sql-mode="ALLOW_INVALID_DATES"