Hi,
im trying to use otrs with sql server 2000.
most things working, but i got this error in my error.log if i try to fetch mail via pop3.
same error by creating a phone ticket.
[Error][Kernel::System::Ticket::History::AddHistoryRow][105] [Microsoft][ODBC SQL Server Driver][SQL Server]Falsche Syntax in der Nähe des open-Schlüsselwortes. (SQL-42000)(DBD: Execute immediate failed err=-1), SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, valid_id, create_time, create_by, change_time, change_by) VALUES ('Old: \'open\' New: \'closed successful\'', 30, 452, 482, 1, current_timestamp, 1, current_timestamp, 1)'
the problem are the ' in this part:
\'open\' New: \'closed successful\'
where do they come from?
or which module is responsible for it?
regards
holger