Hi Leute,
wollte die Version 3.1.10 aus dem paket installieren, bei der Datenbankinstallation erhalte ich folgende Fehlermeldung:
Code: Alles auswählen
General Error
SQL ERROR [ mysql4 ]
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 'DEFAULT '0' NOT NULL, forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, ' at line 2 [1064]
SQL
CREATE TABLE phpbb_acl_users ( user_id DEFAULT '0' NOT NULL, forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, auth_role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, auth_setting tinyint(2) DEFAULT '0' NOT NULL ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysql.php
LINE: 181
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/tools.php
LINE: 1428
CALL: phpbb\db\driver\mysql->sql_query()
FILE: [ROOT]/phpbb/db/tools.php
LINE: 678
CALL: phpbb\db\tools->_sql_run_sql()
FILE: [ROOT]/install/install_install.php
LINE: 1216
CALL: phpbb\db\tools->sql_create_table()
FILE: [ROOT]/install/install_install.php
LINE: 99
CALL: install_install->load_schema()
FILE: [ROOT]/install/index.php
LINE: 409
CALL: install_install->main()
FILE: [ROOT]/install/index.php
LINE: 289
CALL: module->load()
Bin mit der fehlermeldung etwas ratlos.
thx und Grüße
Frank