Nach Update auf 2.4.7 fehler in MYSQL

[oxi]

Hallo,

ich habe ein Upgrade durchgeführt und bekomme nun in den Logs folgende Meldung:

Code: Select all

 [Error][Kernel::System::Ticket::TicketSearch][Line:4761]: 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 (2, 2, 4, 5, 5, 6, 6, 7, 8, 9, 10, 11, 

MFG

[giga0069]

ich habe ein Upgrade durchgeführt und bekomme nun in den Logs folgende Meldung:

Code: Select all

 [Error][Kernel::System::Ticket::TicketSearch][Line:4761]: 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 (2, 2, 4, 5, 5, 6, 6, 7, 8, 9, 10, 11, 

MFG

Hallo oxi,

Du hast von 2.3.4 auf 2.4.7 upgedatet? Sind beide SQL-Skripts ohne Fehlermeldungen durchgelaufen? Also zunächst das DBUpdate-to-2.4 und dann das DBUpdate-to-2.4-post? Ich habe schon erlebt, dass das Skript abgebrochen ist und dann ein Teil der Änderungen schon durch war, aber ein Teil noch nicht.

Gruß giga0069

[oxi]

Habe beides ausgeführt. Immer wenn ich das Dashboard aufrufe kommen diese SQL-Fehler.

Nur um mein Anliegen zu schildern. Ich möchte gerne eine vorhandene OTRS 2.3.4 DB (MySQL) die hier noch vorhanden ist in ein neue System 2.4.7 einpflegen.
Mein Vorgehen war zunächst nach der UPGRADE Textdatei vorzugehen. Dies war leider ein Misserfolg.
Daraufhin habe ich einfach die zwei Update-Scripte für die DB in OTRS verwendet (DBUpdate-to-2.4 und dann das DBUpdate-to-2.4-post). Doch die SQL-Fehler bleiben wie oben beschrieben.
Weiß wer Rat?

[oxi]

Hier nochmals die Fehler:

Code: Select all

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 (2, 2, 4, 5, 5, 6, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16,' 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 sq.group_id IN (2, 2, 4, 5, 5, 6, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21) AND st.until_time >= 1273490529 ORDER BY st.until_time ASC LIMIT 25'
Mon May 10 13:37:09 2010	

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 (2, 2, 4, 5, 5, 6, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16,' 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 (2, 2, 4, 5, 5, 6, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21) AND tw.user_id IN (2) AND st.until_time <= 1273491369 LIMIT 10000'


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 (2) AND sq.group_id IN (2, 2, 4, 5, 5, 6, 6, 7,' 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 (2) AND sq.group_id IN (2, 2, 4, 5, 5, 6, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21) AND st.until_time <= 1273491369 LIMIT 10000'


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 (999999) AND sq.group_id IN (2, 2, 4, 5, 5, 6, 6, 7, 8, 9,' 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 (999999) AND sq.group_id IN (2, 2, 4, 5, 5, 6, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21) AND st.until_time <= 1273491369 LIMIT 10000'
	

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 (2) AND sq.group_id IN (2, 2, ' 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 (2) AND sq.group_id IN (2, 2, 4, 5, 5, 6, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21) AND st.until_time <= 1273491369 LIMIT 10000'


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 (2, 2, 4, 5, 5, 6, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16,' 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 (2, 2, 4, 5, 5, 6, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21) AND st.until_time <= 1273491369 LIMIT 10000'


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 (2) AND sq.group_id IN (2, 2, ' 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 (2) AND sq.group_id IN (2, 2, 4, 5, 5, 6, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21) AND st.until_time <= 1273491369 ORDER BY st.until_time DESC LIMIT 10'