phpBB Мod Error

phpBB : Critical Error 

Could not query log informations

DEBUG MODE

SQL Error : 1146 Table 'phpbb2.phpbb_logs' doesn't exist

SELECT * FROM phpbb_logs ORDER BY time DESC LIMIT 0, 50 

Line : 164
File : admin_logs.php

Adding/modifying tables to your database
Running query :: CREATE TABLE phpbb_logs ( id_log MEDIUMINT(10) NOT NULL DEFAULT '0' AUTO_INCREMENT, mode VARCHAR(50) NULL DEFAULT '', topic_id MEDIUMINT(10) NULL DEFAULT '0', user_id MEDIUMINT(8) NULL DEFAULT '0', username VARCHAR(255) NULL DEFAULT '', user_ip CHAR(8) DEFAULT '0' NOT NULL, time INT(11) NULL DEFAULT '0', PRIMARY KEY (id_log)) -> ERROR - QUERY FAILED ----> Invalid default value for 'id_log'

Running query :: CREATE TABLE phpbb_logs_config ( config_name varchar(255) NOT NULL, config_value varchar(255) NOT NULL, PRIMARY KEY (config_name)) -> GOOD - QUERY OK

Running query :: INSERT INTO phpbb_logs_config ( config_name, config_value) VALUES ('all_admin', 0) -> GOOD - QUERY OK

Running query :: ALTER TABLE phpbb_users ADD user_view_log TINYINT NOT NULL DEFAULT '0' -> GOOD - QUERY OK


COMPLETE - INSTALLATION IS ENDED

At least one query failed : check the error message and contact me if you need help to resolve the problem.

CREATE TABLE `phpbb_logs` (
   `id_log` MEDIUMINT(10) NOT NULL DEFAULT '0' AUTO_INCREMENT,
   `mode` VARCHAR(50) NULL DEFAULT '',
   `topic_id` MEDIUMINT(10) NULL DEFAULT '0',
   `user_id` MEDIUMINT(8) NULL DEFAULT '0',
   `username` VARCHAR(255) NULL DEFAULT '',
   `user_ip` CHAR(8) DEFAULT '0' NOT NULL,
   `time` INT(11) NULL DEFAULT '0',
   PRIMARY KEY (`id_log`)
   );

CREATE TABLE `phpbb_logs_config`(
   `config_name` varchar(255) NOT NULL,
   `config_value` varchar(255) NOT NULL,
   PRIMARY KEY (`config_name`)
   );

INSERT INTO `phpbb_logs_config` VALUES ('all_admin', 0);

ALTER TABLE `phpbb_users` ADD `user_view_log` TINYINT NOT NULL DEFAULT '0';