Wie in meinem anderen Thread zu einem anderen Thema schon gesagt hab ich vor kurzem die Pflege eines OTRS "geerbt". Upgrade von 2.1.5 auf 2.4.9 hat soweit auch gut geklappt - zumindest gibt es keine Nutzungseinschränkungen.
Was mir allerdings aufgefallen ist sind ein paar Fehlermeldungen im Syslog:
Code: Select all
Apr 1 09:17:23 mhs-otrs2 OTRS-CGI-10[6456]: [Error][Kernel::System::Ticket::TicketSearch][Line:4768]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND st.ticket_lock_id IN (2) AND st.user_id IN (32) AND sq.group_id IN (1, 4,' at line 1, SQL: 'SELECT DISTINCT st.id, st.tn, st.until_time FROM ticket st, queue sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( ) AND st.ticket_lock_id IN (2) AND st.user_id IN (32) AND sq.group_id IN (1, 4, 5, 6) AND st.ticket_state_id IN (6, 7, 8) AND st.until_time <= 1301642183 ORDER BY st.until_time DESC LIMIT 10'
Apr 1 09:17:23 mhs-otrs2 OTRS-CGI-10[6456]: [Error][Kernel::System::Ticket::TicketSearch][Line:4768]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND sq.group_id IN (1, 4, 5, 6) AND st.ticket_state_id IN (6, 7, 8) AND st.' at line 1, SQL: 'SELECT DISTINCT count(*) FROM ticket st, queue sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( ) AND sq.group_id IN (1, 4, 5, 6) AND st.ticket_state_id IN (6, 7, 8) AND st.until_time <= 1301642183 LIMIT 10000'
Apr 1 09:17:23 mhs-otrs2 OTRS-CGI-10[6456]: [Error][Kernel::System::Ticket::TicketSearch][Line:4768]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND st.ticket_lock_id IN (2) AND st.user_id IN (32) AND sq.group_id IN (1, 4,' at line 1, SQL: 'SELECT DISTINCT count(*) FROM ticket st, queue sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( ) AND st.ticket_lock_id IN (2) AND st.user_id IN (32) AND sq.group_id IN (1, 4, 5, 6) AND st.ticket_state_id IN (6, 7, 8) AND st.until_time <= 1301642183 LIMIT 10000'
Apr 1 09:17:23 mhs-otrs2 OTRS-CGI-10[6456]: [Error][Kernel::System::Ticket::TicketSearch][Line:4768]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND st.queue_id IN (6) AND sq.group_id IN (1, 4, 5, 6) AND st.ticket_state_i' at line 1, SQL: 'SELECT DISTINCT count(*) FROM ticket st, queue sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( ) AND st.queue_id IN (6) AND sq.group_id IN (1, 4, 5, 6) AND st.ticket_state_id IN (6, 7, 8) AND st.until_time <= 1301642183 LIMIT 10000'
Apr 1 09:17:23 mhs-otrs2 OTRS-CGI-10[6456]: [Error][Kernel::System::Ticket::TicketSearch][Line:4768]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND st.responsible_user_id IN (32) AND sq.group_id IN (1, 4, 5, 6) AND st.ti' at line 1, SQL: 'SELECT DISTINCT count(*) FROM ticket st, queue sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( ) AND st.responsible_user_id IN (32) AND sq.group_id IN (1, 4, 5, 6) AND st.ticket_state_id IN (6, 7, 8) AND st.until_time <= 1301642183 LIMIT 10000'
Apr 1 09:17:23 mhs-otrs2 OTRS-CGI-10[6456]: [Error][Kernel::System::Ticket::TicketSearch][Line:4768]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND sq.group_id IN (1, 4, 5, 6) AND tw.user_id IN (32) AND st.ticket_state_i' at line 1, SQL: 'SELECT DISTINCT count(*) FROM ticket st, queue sq , ticket_watcher tw WHERE sq.id = st.queue_id AND st.id = tw.ticket_id AND st.ticket_state_id IN ( ) AND sq.group_id IN (1, 4, 5, 6) AND tw.user_id IN (32) AND st.ticket_state_id IN (6, 7, 8) AND st.until_time <= 1301642183 LIMIT 10000'
Jemand n Tip?
Danke vorab!
Peter