I upgraded from OTRS 0.5 beta 8 to OTRS 1.0.1, including the PostgreSQL
upgrade script. PostMasterPOP3.pl is correctly fetching and inserting
messages from my mail server, but it's generating a traceback each time
there's a message to fetch:
DBD::Pg::st execute failed: ERROR: Relation "charset" does not exist
at /usr/local/otrs/Kernel/System/DB.pm line 192.
ERROR: OTRS-PM3-10 Perl: 5.6.1 OS: freebsd Time: Thu Mar 6 18:20:02
2003
Message: ERROR: Relation "charset" does not exist, SQL: 'SELECT
ar.text0, sa.value0, sa.value1, ar.text1, ch.charset FROM
auto_response_type art, auto_response ar, queue_auto_response qar,
system_address sa, charset ch WHERE qar.queue_id = 2 AND art.id =
ar.type_id AND qar.auto_response_id = ar.id AND
ar.system_address_id = sa.id AND ar.charset_id = ch.id AND art.name
= 'auto reply''
Traceback (14773):
Module: Kernel::System::AutoResponse::AutoResponseGetByTypeQueueID
Line: 193
Module: Kernel::System::Ticket::Article::CreateArticle Line: 128
Module: Kernel::System::PostMaster::NewTicket::Run Line: 105
Module: Kernel::System::PostMaster::Run Line: 203
Module: main::FetchMail Line: 165
Module: /usr/local/otrs/bin/PostMasterPOP3.pl Line: 94
DBD::Pg::st fetchrow_array failed: no statement executing at
/usr/local/otrs/Kernel/System/DB.pm line 205.
DBD::Pg::st execute failed: ERROR: Relation "charset" does not exist
at /usr/local/otrs/Kernel/System/DB.pm line 192.
ERROR: OTRS-PM3-10 Perl: 5.6.1 OS: freebsd Time: Thu Mar 6 18:20:02
2003
Message: ERROR: Relation "charset" does not exist, SQL: 'SELECT
ar.text0, sa.value0, sa.value1, ar.text1, ch.charset FROM
auto_response_type art, auto_response ar, queue_auto_response qar,
system_address sa, charset ch WHERE qar.queue_id = 5 AND art.id =
ar.type_id AND qar.auto_response_id = ar.id AND
ar.system_address_id = sa.id AND ar.charset_id = ch.id AND art.name
= 'auto follow up''
Traceback (14773):
Module: Kernel::System::AutoResponse::AutoResponseGetByTypeQueueID
Line: 193
Module: Kernel::System::Ticket::Article::CreateArticle Line: 128
Module: Kernel::System::PostMaster::FollowUp::Run Line: 70
Module: Kernel::System::PostMaster::Run Line: 177
Module: main::FetchMail Line: 165
Module: /usr/local/otrs/bin/PostMasterPOP3.pl Line: 94
DBD::Pg::st fetchrow_array failed: no statement executing at
/usr/local/otrs/Kernel/System/DB.pm line 205.
message 1/3 (otrs@mailbox.samurai.com)
New Ticket created!
TicketNumber: 2003030610000012
TicketID: 175
Priority: normal
State: new
CustomerID: RandyN5242@netscape.com
From: "Domain Hostmaster"