
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 mailto: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)
participants (1)
-
Jeff Shepherd