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.
Get Involved
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
Chaos-Zero
Registered User
Posts: 55
Joined: Tue Jan 13, 2009 6:44 pm

Cant log into ACP after update

Post by Chaos-Zero » Mon Jul 18, 2011 11:34 pm

Support Request Template
What version of phpBB are you using? phpBB 3.0.9
What is your board's URL? http://www.generation-lost.com/forum
Who do you host your board with? I dont know
How did you install your board? I used the download package from phpBB.com
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]

SQL

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

BACKTRACE

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
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10347
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster
Contact:

Re: Cant log into ACP after update

Post by Noxwizard » Tue Jul 19, 2011 12:02 am

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

Open: /includes/constants.php
Find:

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.

Chaos-Zero
Registered User
Posts: 55
Joined: Tue Jan 13, 2009 6:44 pm

Re: Cant log into ACP after update

Post by Chaos-Zero » Tue Jul 19, 2011 12:21 am

Thanks. That helped me out!

Locked

Return to “[3.0.x] Support Forum”