Error Logging into Admiistration Control Panel

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Ideas Centre
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Registered User
Posts: 1
Joined: Mon Apr 29, 2013 12:48 pm

Error Logging into Admiistration Control Panel

Post by rhys9tt »


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]


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


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()
User avatar
Support Team Member
Support Team Member
Posts: 22634
Joined: Fri Aug 29, 2008 9:49 am
Location: Watching cricket probably.

Re: Error Logging into Admiistration Control Panel

Post by Mick »

Please fill out the Support Request Template Generator and post it back here to enable us to assist you better.
"The more connected we get the more alone we become" - Kyle Broflovski©
User avatar
Registered User
Posts: 5757
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン

Re: Error Logging into Admiistration Control Panel

Post 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;
The worst thing about censorship is ███████████
Affin wrote:
Tue Nov 20, 2018 9:51 am
The problem is probably not my English but you do not want to understand correctly.
We will not come anybody anyway, nevertheless, it's best to shit this.

Return to “[3.0.x] Support Forum”