DB problem in instalation
Posted: Tue Sep 23, 2014 12:37 pm
Hello;
We have received the following error when installing PHPMyFAQ.
MySQL Version is:
Server version: 5.5.38-0+wheezy1-log (Debian)
PHP Version is:
PHP Version 5.3.3-7+squeeze19
"DB error: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause"
Do you have any suggestions to solve this problem?
We have received the following error when installing PHPMyFAQ.
MySQL Version is:
Server version: 5.5.38-0+wheezy1-log (Debian)
PHP Version is:
PHP Version 5.3.3-7+squeeze19
"DB error: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause"
Code: Select all
CREATE TABLE faqinstances ( id INT(11) NOT NULL, url VARCHAR(255) NOT NULL, instance VARCHAR(255) NOT NULL, comment TEXT NULL, created TIMESTAMP, modified TIMESTAMP ON UPDATE CURRENT_TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci