Upgrading to 3.2.12 Session invalid. Please log in again.

[bendegreat]

I'm working on porting an existing OTRS system from Windows 7 to CentOS so I can go from 3.1.21 all the way to 5. I've followed all the instructions given in the documentation to update to 3.2 (ran the DB update scripts et c) but whenever I attempt to login I get the message "Session invalid. Please log in again."

In my log file I see a lot of messages with along the lines of

[Error][Kernel::System::DynamicField::DynamicFieldGet] [285] Unknown column 'internal_field' in 'field list', SQL: 'SELECT id, internal_field, name, label, field_order, field_type, object_type, config, valid_id, create_time, change_time FROM dynamic_field WHERE id = ?'

From what I can find on the error this is typically a MySql syntax problem but I don't see how that could be the case since the queries are coming from OTRS, not me.

Any advice would be appreciated. Thank you.

[wurzel]

Hi,

did you follow the path
upgrading to 3.2.x
then to 3.3.x
then to 4
then to 5

And were you able to logon on your 3.3.x or 4?

Try to delete caches + reset your browser. Browser caching sometimes use old sessions. Drives you crazy.

regards,
Flo

[bendegreat]

Hey Flo, thanks for the advice.

I updated to 3.3 and was still getting the error. I rebuilt config and delete cache several times with no effect and tried logging in from various computers and users. I ended up reverting the virtual machine to a state with 3.1.12 and redoing the whole update process. It worked but I have no idea what I did differently