Hallo Alexander. Mein Tipp: Nach der UPGRADING-Datei vorgehen ;-)
Im speziellen Fall die Punkte 8-10 beachten. Gruß Stefan Bedorf Am 11.05.2010 14:44, schrieb Alexander Pentermann: > Hallo, > > 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-Skripte für die DB in OTRS > verwendet (DBUpdate-to-2.4 und dann das DBUpdate-to-2.4-post). Doch die > SQL-Fehler bleiben. > > Hier die SQL-Fehler die beim Aufrufen des Dashboards auftreten. > > 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' > > > > Weiß wer Rat? > > Gruß > Alexander Pentermann > --------------------------------------------------------------------- > 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 > > NEU! ENTERPRISE SUBSCRIPTION - JETZT informieren und buchen! > http://www.otrs.com/de/support/enterprise-subscription/ > --------------------------------------------------------------------- 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 NEU! ENTERPRISE SUBSCRIPTION - JETZT informieren und buchen! http://www.otrs.com/de/support/enterprise-subscription/
