[otrs] PostMasterPOP3.pl, next question

[Bryan Fullerton]

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 ([EMAIL PROTECTED])
New Ticket created!
TicketNumber: 2003030610000012
TicketID: 175
Priority: normal
State: new
CustomerID: [EMAIL PROTECTED]
From: "Domain Hostmaster" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: .ws "web site" domain Registry: #37 fastest growing co. un USA
MessageID: 
<[EMAIL PROTECTED]>
Queue: Raw
[...]

Thoughts?

Thanks,

Bryan

_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs