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 <leonardo.certuche@itcon-ltda.com>
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