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!
--
Ralf Hildebrandt Charite Universitätsmedizin Berlin
[email protected] Campus Benjamin Franklin
http://www.charite.de Hindenburgdamm 30, 12203 Berlin
Geschäftsbereich IT, Abt. Netzwerk fon: +49-30-450.570.155
---------------------------------------------------------------------
OTRS mailing list: otrs-de - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs-de
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs-de
