Page 1 of 1

[Solved] Error After DB Migration

PostPosted: Tue Apr 25, 2006 11:43 am
Author: CoolAzzrob
I get this when I try to log in after installing the latests version of IM and migrating my users and messages from my previous IM installation. Any ideas how to fix it?

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_rank. user_activate_date, user_expire_date, user_regdate, user_login_tries, user_last_login_try FROM phpbb_users WHERE username = 'media
Line : 85
File : login.php

PostPosted: Tue Apr 25, 2006 12:08 pm
Author: Michaelo
The phpbb_user table is missing this entryuser_login_tries I think is was a recent update.
Add: using phpmyadmin in user table (phpbb_users)
user_login_tries smallint(5) unsigned NOT NULL default 0
Mike

PostPosted: Tue Apr 25, 2006 7:02 pm
Author: CoolAzzrob
Thanks that did the trick. Now on to other error messages.

Re: [Solved] Error After DB Migration

PostPosted: Wed Apr 26, 2006 3:19 pm
Author: Helter
i think you skipped a few steps in your upgrade. By the error, im assuming you are updating from a 132 site to a 140 site?

If i remember correctly, there are 3 db update files in the upgrade from 132 file. then you will need to run the security update. All the files are available in the dl section in 140/updates

PostPosted: Fri Apr 28, 2006 10:49 am
Author: CoolAzzrob
No, I was just updating IM 140 after having to switch hosting companies.