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 ------------------------------------------------------- -- "Catch the Magic of Linux..." -------------------------------------------------------- Michael Peddemors - Senior Systems Developer LinuxAdministration - Internet Services NetworkServices - Programming - Security Wizard IT Services http://www.wizard.ca Linux Support Specialist - http://www.linuxmagic.com LinuxMagic is a Registered TradeMark of Wizard Tower TechnoServices Ltd. -------------------------------------------------------- (604)589-0037 Beautiful British Columbia, Canada This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error please notify the system manager. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. _______________________________________________ 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
