phpMyFAQ 2.6.14 + xampp 1.7.4

[Pegasus]

Hi
I just installed latest edition of xampp (1.7.4) that includes:
* Apache 2.2.17
* MySQL 5.5.8
* PHP 5.3.5
* phpMyAdmin 3.3.9
phpMyFAQ can't be installed, actually the tables are created but they are empty and after finishing to install phpMyFAQ I got this message:

DB error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NULL, display_name VARCHAR(50) NULL, email VARCHAR(100) NULL )' at line 3

Query:

CREATE TABLE faquserdata (
user_id INT(11) NOT NULL,
last_modified TIMESTAMP(14) NULL,
display_name VARCHAR(50) NULL,
email VARCHAR(100) NULL
)

I guess I must go back to xampp 1.7.3 with mysql 5.1

Bye
Fab.

[Thorsten]

Hi,

which extension did you select?

bye
Thorsten

[Thorsten]

Hi,

I fixed it for 2.6.15, thanks for the hint!

bye
Thorsten

[trf000]

I get the same error in my LAMP installation...

DB error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NULL, display_name VARCHAR(50) NULL, email VARCHAR(100) NULL )' at line 3

Query:

CREATE TABLE faquserdata (
user_id INT(11) NOT NULL,
last_modified TIMESTAMP(14) NULL,
display_name VARCHAR(50) NULL,
email VARCHAR(100) NULL
)

How can I fix this?

[Thorsten]

Hi,

here's the fix: https://github.com/thorsten/phpMyFAQ/co ... 1989398de1

bye
Thorsten