Hi Holger, On Wed, Jul 09, 2003 at 10:22:54AM +0200, Holger.Struck@sqs.de wrote:

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.

Cool! :)

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?

The normal string is: Old: 'open' New: 'closed successful' But a ' would brake the SQL syntax so it will be quoted with \'. On SAPDB you need to quote with ' instead of \ -=> '' instand of \'. How is the quoteing on mssql? Also ''?

regards holger

Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- Noch 67 Tage bis zum Gäubodenvolksfest! ;-)