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.
Anti-Spam Guide
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: 17824
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff

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

There are no ‘threads’ in phpBB, they are topics.
Forza Garibaldi

User avatar
AmigoJack
Registered User
Posts: 4880
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 ███████████

Locked

Return to “[3.0.x] Support Forum”

Who is online

Users browsing this forum: Tbot [Bot], Yahoo [Bot] and 72 guests