DB problem in instalation

All about webserver configurations, PHP and databases.

Moderator: Thorsten

Post Reply
mavituna
Posts: 1
Joined: Tue Sep 23, 2014 12:21 pm

DB problem in instalation

Post by mavituna »

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"

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
Do you have any suggestions to solve this problem?
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: DB problem in instalation

Post by Thorsten »

Hi,

you can try to revert this fix:

https://github.com/thorsten/phpMyFAQ/co ... 54a1e0d7b3

Or upgrade to MySQL 5.6

Or wait for phpMyFAQ 2.8.14 :)

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Post Reply