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

10 Aug 2005

      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!

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

Christian Schoepplein