[otrs] Bug or problem?

[Jeff Shepherd]

We've been using OTRS for several months now, however, just recently 
(about two weeks ago) I started getting the following email on an 
intermittent basis.  Is there a problem with OTRS or with my configuration?

<SNIP>

ERROR: OTRS-PM3-36 Perl: 5.8.5 OS: linux Time: Tue Mar  6 12:45:01 2007

 Message: No TypeID for 1 found!

 Traceback (667): 
   Module: Kernel::System::Ticket::PriorityLookup (v1.233) Line: 3571
   Module: Kernel::System::Ticket::TicketCreate (v1.233) Line: 348
   Module: Kernel::System::PostMaster::NewTicket::Run (v1.58) Line: 152
   Module: Kernel::System::PostMaster::Run (v1.60) Line: 246
   Module: main::FetchMail (v1.23) Line: 206
   Module: /opt/otrs/bin/PostMasterPOP3.pl (v1.23) Line: 125

Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 379.
DBD::mysql::db do failed: You have an error in your SQL syntax near ' 1,  0, 1173210301, 0, 1,  current_timestamp, 1, current_timestamp, 1)' at line 1 at /opt/otrs/Kernel/System/DB.pm line 372.
ERROR: OTRS-PM3-36 Perl: 5.8.5 OS: linux Time: Tue Mar  6 12:45:01 2007

 Message: You have an error in your SQL syntax near ' 1,  0, 1173210301, 0, 1,  current_timestamp, 1, current_timestamp, 1)' at line 1, SQL: 'INSERT INTO ticket (tn, title, create_time_unix, queue_id, ticket_lock_id,  user_id, responsible_user_id, group_id, ticket_priority_id, ticket_state_id, ticket_answered,  escalation_start_time, timeout, valid_id, create_time, create_by, change_time, change_by)  VALUES ('3602451', 'demo questions', 1173210301, 10, 1, 1, 1,  1, , 1,  0, 1173210301, 0, 1,  current_timestamp, 1, current_timestamp, 1)'

 Traceback (667): 
   Module: Kernel::System::Ticket::TicketCreate (v1.233) Line: 387
   Module: Kernel::System::PostMaster::NewTicket::Run (v1.58) Line: 152
   Module: Kernel::System::PostMaster::Run (v1.60) Line: 246
   Module: main::FetchMail (v1.23) Line: 206
   Module: /opt/otrs/bin/PostMasterPOP3.pl (v1.23) Line: 125

ERROR: OTRS-PM3-36 Perl: 5.8.5 OS: linux Time: Tue Mar  6 12:45:01 2007

 Message: create db record failed!!!

 Traceback (667): 
   Module: Kernel::System::Ticket::TicketCreate (v1.233) Line: 428
   Module: Kernel::System::PostMaster::NewTicket::Run (v1.58) Line: 152
   Module: Kernel::System::PostMaster::Run (v1.60) Line: 246
   Module: main::FetchMail (v1.23) Line: 206
   Module: /opt/otrs/bin/PostMasterPOP3.pl (v1.23) Line: 125

<SNIP>

Thanks fo r the help.

-Jeff

-- 
Jeff Shepherd
Technical Specialist
jeffs at tolisgroup.com <mailto:jeffs at tolisgroup.com>
 
TEL: 480-505-0488 x223
FAX: 480-505-0492

"Success usually comes to those who are too busy to be looking for it"
- Henry David Thoreau (1817-1862)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.otrs.org/pipermail/otrs/attachments/20070306/a4c62c8f/attachment.html