[Solved] Error After DB Migration

[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 = 'mediaLine : 85
File : login.php

[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

[CoolAzzrob]

Thanks that did the trick. Now on to other error messages.

[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

[CoolAzzrob]

No, I was just updating IM 140 after having to switch hosting companies.