Updateproblem 3.1.7 -> 3.2.9
Ein Ubuntu Update von raring -> saucy hat mir in die Suppe gespuckt OTRS ging dabei von 3.1.7 -> 3.2.9
Ich erhalte aktuell den Fehler:
Mar 28 11:45:32 vb-otrs OTRS-CGI-10[30656]: [Notice][Kernel::System::Auth::DB::Auth] User: admin authentication ok (REMOTE_ADDR: 141.42.231.227). Mar 28 11:45:32 vb-otrs OTRS-CGI-10[30656]: [Error][Kernel::System::AuthSession::DB::CreateSessionID][Line:226]: Unknown column 'data_key' in 'field list', SQL: '#012 SELECT session_id, data_key, data_value#012 FROM sessions#012 WHERE data_key = 'UserType'#012 OR data_key = 'UserLastRequest'#012 ORDER BY id ASC'
Mar 28 11:45:32 vb-otrs OTRS-CGI-10[30656]: [Error][Kernel::System::AuthSession::DB::CreateSessionID][Line:328]: Unknown column 'data_key' in 'field list', SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?)'
Mar 28 11:45:32 vb-otrs OTRS-CGI-10[30656]: [Error][Kernel::System::AuthSession::DB::GetSessionIDData][Line:159]: Unknown column 'id' in 'field list', SQL: '#012 SELECT id, data_key, data_value, serialized#012 FROM sessions#012 WHERE session_id = ?#012 ORDER BY id ASC' Mar 28 11:45:32 vb-otrs OTRS-CGI-10[30656]: [Notice][Kernel::System::AuthSession::DB::CheckSessionID] SessionID: '10c3285ae9b6b2068cd963fcbd0bb3ccba' is invalid!!!
ie Migration:
otrs@vb-otrs:~/scripts$ ./DBUpdate-to-3.2.pl
Migration started...
Step 1 of 10: Refresh configuration cache... If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry! Subroutine Load redefined at /usr/share/otrs/Kernel/Config/Files/ZZZAAuto.pm line 7. done.
Step 2 of 10: Check framework version... done.
Step 3 of 10: Cleanup UserPreferences... done.
Step 4 of 10: Updating toolbar configuration... done.
Step 5 of 10: Updating AgentTicketZoom window configuration... done.
Step 6 of 10: Dropping obsolete columns from article_search... Check if columns exist. Columns are not present, no need to drop them. done.
Step 7 of 10: Dropping unused indexes on article_flag... SET @FKExists := (SELECT COUNT(*) FROM information_schema.table_constraints WHERE table_schema = DATABASE() AND table_name = 'article_flag' AND constraint_name = 'FK_article_flag_article_id_id') OK SET @FKSQLStatement := IF( @FKExists > 0, 'ALTER TABLE article_flag DROP FOREIGN KEY FK_article_flag_article_id_id', 'SELECT ''INFO: Foreign key constraint FK_article_flag_article_id_id does not exist, skipping.''' ) OK PREPARE FKStatement FROM @FKSQLStatement OK EXECUTE FKStatement OK SET @FKExists := (SELECT COUNT(*) FROM information_schema.table_constraints WHERE table_schema = DATABASE() AND table_name = 'article_flag' AND constraint_name = 'FK_article_flag_create_by_id') OK SET @FKSQLStatement := IF( @FKExists > 0, 'ALTER TABLE article_flag DROP FOREIGN KEY FK_article_flag_create_by_id', 'SELECT ''INFO: Foreign key constraint FK_article_flag_create_by_id does not exist, skipping.''' ) OK PREPARE FKStatement FROM @FKSQLStatement OK EXECUTE FKStatement OK DROP INDEX article_flag_create_by ON article_flag OK DROP INDEX article_flag_article_id_article_key ON article_flag OK ALTER TABLE article_flag ADD CONSTRAINT FK_article_flag_article_id_id FOREIGN KEY (article_id) REFERENCES article (id) OK ALTER TABLE article_flag ADD CONSTRAINT FK_article_flag_create_by_id FOREIGN KEY (create_by) REFERENCES users (id) OK Step 8 of 10: Migration cache backend configuration... done.
Step 9 of 10: Clean up the cache... done.
Step 10 of 10: Refresh configuration cache another time... If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry! Subroutine Load redefined at /usr/share/otrs/Kernel/Config/Files/ZZZAAuto.pm line 7. done.
Migration completed!
participants (1)
-
Ralf Hildebrandt