Login Error

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Registered User
Posts: 19
Joined: Sat Oct 08, 2005 1:54 am

Login Error

Post by ABCDiamond » Tue Apr 25, 2006 5:01 am

I have just restored my database, following a change of webhosting.

I get this error when trying to log in.
Error in obtaining userdata


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

Line : 65
File : login.php

And, when I tried to create another user, in an attempt to see if I can access that way, it does not show the picture with the validation code to continue.

Any ideas ?

User avatar
Posts: 4670
Joined: Tue Sep 21, 2004 12:05 pm
Location: Tampere, Finland
Name: Martti Lokka

Post by lurttinen » Tue Apr 25, 2006 5:19 am

Your forum files are never version than the database you have.

Download a phpBB package from the downloads page.
Inside it you will find a /install directory.

Uplad the install directory with all it's contents and run /install/update_to_latest.php

This will update your database to the latest version.
Signature is here

Registered User
Posts: 19
Joined: Sat Oct 08, 2005 1:54 am

Post by ABCDiamond » Tue Apr 25, 2006 7:10 am

Thanks for that. All fixed now :)

At least until i try to move my database to another domain name :)


Return to “2.0.x Support Forum”