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
-------------------------------------------------------
--
"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.
