I am working on an upgrade from 3.1.6 (on CentOS5 32bit with mysql 5.1.53) to 3.2.6 (on CentOS6.5 64bit with mysql 5.1.73) to finaly endup with a V3.3.x on the new box. I finalized the steps 1 to 12 (skipped 10) from https://github.com/OTRS/otrs/blob/rel-3_2/UPGRADING.md successfully. But I endup with an error message in otrs.log
Unknown column 'data_key' in 'field list', SQL: '
SELECT session_id, data_key, data_value
FROM sessions
WHERE data_key = 'UserSessionStart'
OR data_key = 'UserLastRequest'
ORDER BY id ASC'
which looks similar to the one in the German section: viewtopic.php?f=35&t=23222&p=91468&hili ... %27#p91468
But the 2nd advise in this thread did not help in my case:
- remove Browser Caches
- run otrs.DeleteCache.pl (nicht unbedingt notwendig, kann helfen)
- run otrs.LoaderCache.pl
- hardcore: rm -rf /opt/otrs/var/tmp
- httpd deamon restart
When I look at the sessions table it only has 2 columns, so the error message makes sense
:mysql> desc sessions;
+---------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| session_id | varchar(150) | NO | PRI | NULL | |
| session_value | text | NO | | NULL | |
+---------------+--------------+------+-----+---------+-------+
2 rows in set (0.03 sec)
My German is not that strong as it was in my Dutch highschool days, but did I read to drop and recreate the table in the database?
Thanks in advance for your response!