Hi Michael, On Mi, Aug 10, 2005 at 02:04:03 -0700, Michael Peddemors wrote: >This one you can see has problems on the insert, as it did not escape the >single quote.. > >---------- Forwarded Message ---------- > >Subject: Cron <[EMAIL PROTECTED]> $HOME/bin/PostMasterPOP3.pl >> /dev/null >Date: August 10, 2005 01:10 pm >From: Cron Daemon <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] > >DBD::Pg::db do failed: ERROR: Unterminated quoted string at > /web/home_dirs/otrs/Kernel/System/DB.pm line 330. ERROR: OTRS-PM3-10 Perl: > 5.6.1 OS: linux Time: Wed Aug 10 13:10:10 2005 > > Message: ERROR: Unterminated quoted string, SQL: 'INSERT INTO article > (ticket_id, article_type_id, article_sender_type_id, a_from, a_reply_to, > a_to, a_cc, a_subject, a_message_id, a_body, a_content_type, content_path, > valid_id, incoming_time, create_time, create_by, change_time, change_by) > VALUES (1306, 1, 3, 'Áåç êîìèññèè <[EMAIL PROTECTED]>', '', > '[EMAIL PROTECTED]', '', 'Ïðîäàåòñÿ êîòåäæ 460 êâì â ã. Òðîèöê', > '<[EMAIL PROTECTED]>', ?, 'text/plain\; format=flowed\; > charset="windows-1251"\; reply-type=original', ?, 1, 1123704610, > current_timestamp, 1, current_timestamp, 1)' > > Traceback (27859): > Module: Kernel::System::Ticket::Article::ArticleCreate (v1.87) Line: 135 > Module: Kernel::System::PostMaster::NewTicket::Run (v1.52) Line: 208 > Module: Kernel::System::PostMaster::Run (v1.50) Line: 256 > Module: main::FetchMail (v1.16) Line: 198 > Module: /home/otrs/bin/PostMasterPOP3.pl (v1.16) Line: 126 > >ERROR: OTRS-PM3-10 Perl: 5.6.1 OS: linux Time: Wed Aug 10 13:10:10 2005 > > Message: No article found for TicketID 1306! > > Traceback (27859): > Module: Kernel::System::Ticket::Article::ArticleLastCustomerArticle > (v1.87) Line: 751 Module: > Kernel::System::Ticket::Article::SendCustomerNotification (v1.87) Line: 1621 > Module: Kernel::System::Ticket::StateSet (v1.172) Line: 2394 > Module: Kernel::System::PostMaster::NewTicket::Run (v1.52) Line: 231 > Module: Kernel::System::PostMaster::Run (v1.50) Line: 256 > Module: main::FetchMail (v1.16) Line: 198 > Module: /home/otrs/bin/PostMasterPOP3.pl (v1.16) Line: 126 > >ERROR: OTRS-PM3-10 Perl: 5.6.1 OS: linux Time: Wed Aug 10 13:10:10 2005 > > Message: Need ID or Name! > > Traceback (27859): > Module: Kernel::System::Queue::QueueGet (v1.49) Line: 726 > Module: Kernel::System::Ticket::Article::SendCustomerNotification (v1.87) > Line: 1623 Module: Kernel::System::Ticket::StateSet (v1.172) Line: 2394 > Module: Kernel::System::PostMaster::NewTicket::Run (v1.52) Line: 231 > Module: Kernel::System::PostMaster::Run (v1.50) Line: 256 > Module: main::FetchMail (v1.16) Line: 198 > Module: /home/otrs/bin/PostMasterPOP3.pl (v1.16) Line: 126 > >ERROR: OTRS-PM3-10 Perl: 5.6.1 OS: linux Time: Wed Aug 10 13:10:10 2005 > > Message: Can't process email with MessageID > <<[EMAIL PROTECTED]>>! Please create a bug report with > this email (var/spool/) on http://bugs.otrs.org/! > > Traceback (27859): > Module: Kernel::System::PostMaster::NewTicket::Run (v1.52) Line: 236 > Module: Kernel::System::PostMaster::Run (v1.50) Line: 256 > Module: main::FetchMail (v1.16) Line: 198 > Module: /home/otrs/bin/PostMasterPOP3.pl (v1.16) Line: 126 > >-------------------------------------------------------
What version of DBD::Pg have you installed.
We recommend to update to version 1.4.2 or newer, because older versions
cause exactly the problems from above.
Best regards,
Christian
--
((otrs)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg
http://www.otrs.de/ :: Manage your communication!
signature.asc
Description: Digital signature
_______________________________________________ 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
