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@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)