Page 1 of 1

Error Logging into Admiistration Control Panel

Posted: Mon Apr 29, 2013 12:51 pm
by rhys9tt
Hi,

Just tried logging into my admin control panel but now I get the following error, its been fine for years. Any idea whats causing it?

General Error
SQL ERROR [ mysql4 ]

Duplicate entry '16777215' for key 'PRIMARY' [1062]

SQL

INSERT INTO phpbb_log (user_id, log_ip, log_time, log_operation, log_data, log_type) VALUES (2, '81.149.204.220', 1367239750, 'LOG_ADMIN_AUTH_SUCCESS', '', 0)

BACKTRACE


FILE: includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: includes/functions.php
LINE: 3304
CALL: dbal_mysql->sql_query()

FILE: includes/functions.php
LINE: 2936
CALL: add_log()

FILE: adm/index.php
LINE: 33
CALL: login_box()

Re: Error Logging into Admiistration Control Panel

Posted: Mon Apr 29, 2013 1:11 pm
by Mick
Please fill out the Support Request Template Generator and post it back here to enable us to assist you better.

Re: Error Logging into Admiistration Control Panel

Posted: Mon Apr 29, 2013 1:42 pm
by AmigoJack
Your phpbb_log database table column log_id has reached the highest number (MySQL MEDIUMINT UNSIGNED = 0..16777215). Execute this command:

Code: Select all

ALTER TABLE phpbb_log MODIFY log_id INT NOT NULL auto_increment;
Tested.