Fwd: Cron <otrs@www2> $HOME/bin/PostMasterPOP3.pl >> /dev/null

This one you can see has problems on the insert, as it did not escape the
single quote..
---------- Forwarded Message ----------
Subject: Cron

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
$HOME/bin/PostMasterPOP3.pl >> /dev/null Date: August 10, 2005 01:10 pm From: Cron Daemon To: supportnotices@linuxmagic.com 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, 'Áåç êîìèññèè
', '', 'support@linuxmagic.com', '', 'Ïðîäàåòñÿ êîòåäæ 460 êâì â ã. Òðîèöê', '<6cb601c59de5$45ca6251$81f93f52@ifg.com>', ?, '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 <<6cb601c59de5$45ca6251$81f93f52@ifg.com>>! 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!

On August 10, 2005 02:10 pm, Christian Schoepplein wrote:
Message: ERROR: Unterminated quoted string, SQL: 'INSERT INTO article
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.
Or :) the code could check to see if the version is older.. and escape the data.. (j/teasing) No, this is standard Debian Woody Packages.. Uses DBI Version 1.30
Best regards, Christian
-- "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. -- "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.
participants (2)
-
Christian Schoepplein
-
Michael Peddemors