Error in obtaining userdata [moved]

[crazynipples]

Error in obtaining userdata

--------------------------------------------------------------------------------

I am using the below.
phpBB
PHP/MySQL based forum

Description: (v2.0.19)

This is a cPanel packaged module. (v0.1)

And i am getting the below when signing into the forums with the admin i provided and password.

General Error

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 = 'crazynipple'

Line : 65
File : login.php

please help me, I have tryed and tried again and always the same error

 

[innovative2001]

Hello

It seems to the permissions issue on the database. The phpBB scripts are not allowed to add a column that is why you are getting these errors. You will have to now use phpMyAdmin to insert the queries yourself.

Please, Try running the two SQL commands.

ALTER TABLE phpbb_users ADD COLUMN user_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL;

ALTER TABLE phpbb_users ADD COLUMN user_last_login_try int(11) DEFAULT '0' NOT NULL;

Thanks

Martin

Technical Support Executive
Accuwebhosting.com