Here is the output of PostMasterPOP3.pl
C:\OTRS\otrs\bin>c:\OTRS\Perl\bin\perl.exe PostMasterPOP3.pl
Message 1/1 ([EMAIL PROTECTED])
ERROR: OTRS-PM3-10 Perl: 5.8.8 OS: MSWin32 Time: Wed Oct 24 13:59:19 2007
Message: No PriorityID for 3 normal found!
Traceback (5016):
Module: Kernel::System::Priority::PriorityLookup (v1.9) Line: 280
Module: Kernel::System::Ticket::TicketCreate (v1.269) Line: 387
Module: Kernel::System::PostMaster::NewTicket::Run (v1.63) Line: 148
Module: Kernel::System::PostMaster::Run (v1.65) Line: 324
Module: main::FetchMail (v1.25) Line: 206
Module: PostMasterPOP3.pl (v1.25) Line: 125
DBD::mysql::db do failed: Column 'ticket_priority_id' cannot be null at C:/OTRS/
otrs/Kernel/System/DB.pm line 387.
ERROR: OTRS-PM3-10 Perl: 5.8.8 OS: MSWin32 Time: Wed Oct 24 13:59:19 2007
Message: Column 'ticket_priority_id' cannot be null, SQL: 'INSERT INTO ticket (
tn, title, create_time_unix, type_id, queue_id, ticket_lock_id, user_id, respon
sible_user_id, group_id, ticket_priority_id, ticket_state_id, ticket_answered,
escalation_start_time, escalation_response_time, escalation_solution_time, timeo
ut, service_id, sla_id, valid_id, create_time, create_by, change_time, change_b
y) VALUES ('2007102410000011', 'test', 1193227159, 1, 2, 1, 1, 1, 1, NULL, 1,
0, 1193227159, 0, 0, 0, NULL, NULL, 1, current_timestamp, 1, current_timestam
p, 1)'
Traceback (5016):
Module: Kernel::System::Ticket::TicketCreate (v1.269) Line: 447
Module: Kernel::System::PostMaster::NewTicket::Run (v1.63) Line: 148
Module: Kernel::System::PostMaster::Run (v1.65) Line: 324
Module: main::FetchMail (v1.25) Line: 206
Module: PostMasterPOP3.pl (v1.25) Line: 125
ERROR: OTRS-PM3-10 Perl: 5.8.8 OS: MSWin32 Time: Wed Oct 24 13:59:20 2007
Message: create db record failed!!!
Traceback (5016):
Module: Kernel::System::Ticket::TicketCreate (v1.269) Line: 489
Module: Kernel::System::PostMaster::NewTicket::Run (v1.63) Line: 148
Module: Kernel::System::PostMaster::Run (v1.65) Line: 324
Module: main::FetchMail (v1.25) Line: 206
Module: PostMasterPOP3.pl (v1.25) Line: 125
ERROR: OTRS-PM3-10 Perl: 5.8.8 OS: MSWin32 Time: Wed Oct 24 13:59:20 2007
Message: Can't process mail, see log sub system!
Traceback (5016):
Module: main::FetchMail (v1.25) Line: 209
Module: PostMasterPOP3.pl (v1.25) Line: 125
Connection to srvhkm.trend.nl closed.
2007/10/24, Peter Hoogkamer <[EMAIL PROTECTED]>:
> Here is what the server 2003 eventlog tells me. An application error
> with perl.exe
> Faulting application perl.exe, version 5.8.8.819, faulting module
> mysql.dll, version 0.0.0.0, fault address 0x000032b9.
>
>
> Could that be the problem??
>
>
> 2007/10/24, Peter Hoogkamer <[EMAIL PROTECTED]>:
> > Priorities are still listed under Admin-area->Priorities.
> > I will post the output of the POP3Master.pl script.
> >
> > Peter
> >
> > 2007/10/24, Torsten Thau <[EMAIL PROTECTED]>:
> > > -----BEGIN PGP SIGNED MESSAGE-----
> > > Hash: SHA1
> > >
> > > Peter Hoogkamer schrieb:
> > > > Hello everybody,
> > > >
> > > > Since a few days I am not able to create a ticket from email picked up
> > > > by the POP3 account. When I execute POP3Master.pl it says that it
> > > > cannot handle a ticket priority of NULL and cannot create the entry in
> > > > the database.
> > > >
> > > > I think the solution will be to set a default priority of 3 for
> > > > tickets that are created from mail. But I cannot seem to find where to
> > > > configure this.
> > >
> > > You can do this in a postmaster filter, but the actual problem is: where
> > > did your "priority 3" go? Ist it still available in the admin-area under
> > > priorities?
> > >
> > >
> > > regards, Torsten Thau
> > >
> > > - --
> > > Torsten Thau, Dipl. Inform.
> > > c.a.p.e. IT Labs GbR - Annaberger Str. 240 - D-09125 Chemnitz
> > > phone: +49 371 5347 623
> > > cell: +49 176 66 680 680
> > > personal pgp-key: 0x93E0A174
> > > fax: +49 371 5347 625
> > > http://www.cape-it.de
> > > -----BEGIN PGP SIGNATURE-----
> > > Version: GnuPG v1.4.6 (GNU/Linux)
> > >
> > > iD8DBQFHHxTcvXo8m5PgoXQRAh02AJ9GaIpaub1d1OOtAdRG9iaFvuh0gQCfcyj3
> > > VASfChb5qjwVXCuvJnRLE0s=
> > > =1q8P
> > > -----END PGP SIGNATURE-----
> > > _______________________________________________
> > > 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
> > > Support or consulting for your OTRS system?
> > > => http://www.otrs.com/
> > >
> >
>
_______________________________________________
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
Support or consulting for your OTRS system?
=> http://www.otrs.com/