Hello there,
Never mind, the reported error was my mistake, I uploaded to production a
buggy query related to:
http://www.mail-archive.com/otrs@otrs.org/msg29112.html
Sorry for making unnecesary noise
Leonardo Certuche
2010/1/14 Leonardo Certuche
Hello people,
Starting today we're getting the folllowing errors when trying to move a ticket between queues:
Unknown column 'sla_id' in 'field list', SQL: 'UPDATE ticket SET escalation_update_time = ? WHERE id = ?' Unknown column 'sla_id' in 'field list', SQL: 'UPDATE ticket SET freekey6 = ?, freetext6 = ?, change_time = current_timestamp, change_by = ? WHERE Unknown column 'sla_id' in 'field list', SQL: 'UPDATE ticket SET freekey5 = ?, freetext5 = ?, change_time = current_timestamp, change_by = ? WHERE Unknown column 'sla_id' in 'field list', SQL: 'UPDATE ticket SET freekey2 = ?, freetext2 = ?, change_time = current_timestamp, change_by = ? WHERE Unknown column 'sla_id' in 'field list', SQL: 'UPDATE ticket SET freekey1 = ?, freetext1 = ?, change_time = current_timestamp, change_by = ? WHERE Unknown column 'sla_id' in 'field list', SQL: 'UPDATE ticket SET escalation_time = ? WHERE id = ?' Unknown column 'sla_id' in 'field list', SQL: 'UPDATE ticket SET escalation_solution_time = ? WHERE id = ?' Unknown column 'sla_id' in 'field list', SQL: 'UPDATE ticket SET escalation_response_time = ? WHERE id = ?'
Has anyone faced the same issue? Any help on how to solve it is much appreciated
Thanks,
Leonardo Certuche