Page 1 of 1

Cant log into ACP after update

Posted: Mon Jul 18, 2011 11:34 pm
by Chaos-Zero
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$)

Re: Cant log into ACP after update

Posted: Tue Jul 19, 2011 12:02 am
by Noxwizard
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');

Re: Cant log into ACP after update

Posted: Tue Jul 19, 2011 12:21 am
by Chaos-Zero
Thanks. That helped me out!