Hi Holger,
On Wed, Jul 09, 2003 at 10:22:54AM +0200, [EMAIL PROTECTED] 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! ;-)
_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
