Need Urgent Help - v3.0.4 Upgrade on Windows

[Gunz]

Hi,

I've gone thru all of the steps to upgrade OTRS from v2.4.7 to v3.0.4 on Windows (Server 2003). I'm up to the last step of doing a config import and I can't login.

I get the following error message with all of my user logins: Panic, user authenticated but no user data can be found in OTRS DB!! Perhaps the user is invalid.

I've tried doing a search on this error and all I can find are references to LDAP. I'm not using LDAP; I'm using Data Base Authentication.

When I go to the table level of MySql all my user data is there.

Please help I am stumped at this point!

--Wayne

[Gunz]

I've checked the Log. OTRS keeps throwing this error:

[Thu Dec 30 13:02:02 2010][Error][Kernel::System::User::GetUserData][202] Unknown column 'title' in 'field list', SQL: 'SELECT id, login, title, first_name, last_name, pw, valid_id, create_time, change_time FROM users WHERE LOWER(login) = ?'

I've believe this is a database error to do with "salutation" vs "title".

Is there a script to fix this or is it a manual fix?

[crythias]

what about your schema for users in the database? obviously, it's looking for a title field/column and you don't have one ... it won't kill anything to add it (case sensitive) to your users table.
Otherwise, you may decide to copy the CustomerUser entries from Defaults.pm to Config.pm and edit appropriately.

[Gunz]

I've solved it !!!

The DB update scripts must not have run properly... I've rerun them and all seems good now.

Thanks for responding.

[Hugacho]

hello gunz,

I have the same problem as you, I've gone thru all of the steps to upgrade OTRS from v2.4.7 to v3.0.4 on Windows (Server 2003).

Please help me with the solution or if possible send me the steps to update the version I would greatly appreciate it.

I enclose my e-mail: hugo_squerez@hotmail.com

Regards in advance

[jojo]

Hi Hugo,

please post a qualified error description as nobody could help you otherwise

[Hugacho]

Hi jojo,

thanks for your answer,

I get the following error message with all of my user logins: Panic, user authenticated but no user data can be found in OTRS DB!! Perhaps the user is invalid.

I followed all the steps for updating, I do not know where is my error.

Greetings and Thanks in advance.