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.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
rhys9tt
Registered User
Posts: 1
Joined: Mon Apr 29, 2013 12:48 pm

Error Logging into Admiistration Control Panel

Post by rhys9tt » Mon Apr 29, 2013 12:51 pm

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()

User avatar
Mick
Support Team Member
Support Team Member
Posts: 21085
Joined: Fri Aug 29, 2008 9:49 am
Location: Watching cricket - definitely

Re: Error Logging into Admiistration Control Panel

Post by Mick » Mon Apr 29, 2013 1:11 pm

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
AmigoJack
Registered User
Posts: 5573
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: Error Logging into Admiistration Control Panel

Post by AmigoJack » Mon Apr 29, 2013 1:42 pm

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.
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.

Locked

Return to “[3.0.x] Support Forum”