Cant log into ACP after update

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: 55
Joined: Tue Jan 13, 2009 6:44 pm

Cant log into ACP after update

Post by Chaos-Zero »

Support Request Template
What version of phpBB are you using? phpBB 3.0.9
What is your board's URL?
Who do you host your board with? I dont know
How did you install your board? I used the download package from
Is your board a fresh install or a conversion? Update from a previous version of phpBB3
Do you have any MODs installed? Yes
Is registration required to reproduce this issue? Yes
What version of phpBB3 did you update from? phpBB 3.0.8
What MODs do you have installed? Share Topic
What styles do you currently have installed? Avalon
What language(s) is your board currently using? English
Which database type/version are you using? I Don't Know
What is your level of experience? Comfortable with PHP and phpBB
What username can be used to view this issue? admins only
What password can be used to view this issue? No answer given
When did your problem begin? After updating from 3.08 to 3.09. Everything went fine and i created a new board in ACP after updating. Still everything was working and a few minutes later, i wanted to log in again to ACP and after clicking on the log in button, i got an error page.
Please describe your problem. After pressing the log in button for ACP i get this error:

General Error
SQL ERROR [ mysql4 ]

Table 'alex_forum.LOGIN_ATTEMPT_TABLE' doesn't exist [1146]


SELECT COUNT(*) AS attempts FROM LOGIN_ATTEMPT_TABLE WHERE attempt_time > 1311010267 AND attempt_ip = ''


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

FILE: includes/auth/auth_db.php
LINE: 87
CALL: dbal_mysql->sql_query()

FILE: includes/auth.php
LINE: 911
CALL: login_db()

FILE: includes/functions.php
LINE: 2848
CALL: auth->login()

FILE: adm/index.php
LINE: 33
CALL: login_box()
Generated by SRT Generator ($Rev$)
Last edited by Noxwizard on Tue Jul 19, 2011 12:34 am, edited 1 time in total.
Reason: Changed topic icon
User avatar
Support Team Leader
Support Team Leader
Posts: 10410
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster

Re: Cant log into ACP after update

Post by Noxwizard »

Your update is not complete. /includes/constants.php was not updated.

Open: /includes/constants.php

Code: Select all

define('LOG_TABLE',					$table_prefix . 'log');
After, add:

Code: Select all

define('LOGIN_ATTEMPT_TABLE',		$table_prefix . 'login_attempts');
[Support Template] - [Read Before Posting] - [phpBB Knowledge Base]
Do not contact me for private support, please share the question in our forums.
Registered User
Posts: 55
Joined: Tue Jan 13, 2009 6:44 pm

Re: Cant log into ACP after update

Post by Chaos-Zero »

Thanks. That helped me out!

Return to “[3.0.x] Support Forum”