phpBB broken in cPanel 10.8.2-C118

viptexting

Well-Known Member
Sep 19, 2005
74
0
156
phpBB is broken in cPanel 10.8.2-C118....

Error in obtaining userdata

DEBUG MODE

SQL Error : 1054 Unknown column 'user_login_tries' in 'field list'

SELECT user_id, username, user_password, user_active, user_level, user_login_tries, user_last_login_try FROM phpbb_users WHERE username = 'asilentcry_admin'

Line : 65
File : login.php
 

viptexting

Well-Known Member
Sep 19, 2005
74
0
156
There is something seriously wrong with this install...

Had to add the following to columns to the phpbb_users table:

user_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
user_last_login_try int(11) DEFAULT '0' NOT NULL,

And then add the following table:

CREATE TABLE phpbb_sessions_keys (
key_id varchar(32) DEFAULT '0' NOT NULL,
user_id mediumint(8) DEFAULT '0' NOT NULL,
last_ip varchar(8) DEFAULT '0' NOT NULL,
last_login int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (key_id, user_id),
KEY last_login (last_login)
);

Then now I can finally login to admin it reports itself as 2.0.17 even though this is supposed to be 2.0.19:

Your installation does not seem to be up to date. Updates are available for your version of phpBB, please visit http://www.phpbb.com/downloads.php to obtain the latest version.
The latest available version is phpBB 2.0.20. You are running phpBB 2.0.17.

Seams like this is a screwed up, mixed up version of 2.0.17 and 2.0.19!!!
 

viptexting

Well-Known Member
Sep 19, 2005
74
0
156
Quick fix...

Just patch to version 2.0.20 from phpBB site...

Probably Quicker fix...

Don't use the dodgy cPanel installers and just install version 2.0.20 from the phpBB site ;-)