Hello all,
we are testing OTRS to process incoming mail for one of our teams. So far it
went fine, but over the weekend something broke somehow :-(
Incoming e-mails get lost, no new ticket is generated; creating tickets from
the web interface works, though. I have pasted the (hopefully) important
part of ~otr/var/log/procmail-2004-07.log below, maybe someone can help me
out here?
Please understand that I am not very experienced with OTRS (yet?); I also
searched the mailing list archives, but all I found that looked similar did
have to do with updating OTRS and/or the database ... and I'm pretty sure I
didn't update OTRS :-/ I noticed that in the SQL statement stated in the
error message the value for ticket_priority_id is missing, but I don't know
how to interpret that.

Thanks in advance,
   Joerg



ERROR: OTRS-PM-17 Perl: 5.8.1 OS: linux Time: Mon Jul 12 13:47:18 2004

 Message: No TypeID for 3 normal found!

 Traceback (1449):
   Module: Kernel::System::Ticket::Priority::PriorityLookup (v1.12) Line: 60
   Module: Kernel::System::Ticket::CreateTicketDB (v1.70) Line: 247
   Module: Kernel::System::PostMaster::NewTicket::Run (v1.43) Line: 162
   Module: Kernel::System::PostMaster::Run (v1.40) Line: 246
   Module: /opt/otrs/bin/PostMaster.pl (v1.16) Line: 101

Use of uninitialized value in concatenation (.) or string at
/opt/otrs/Kernel/System/Ticket.pm line 266.
DBD::mysql::db do failed: You have an error in your SQL syntax.  Check the
manual that corresponds to your MySQL server version for the right syntax to
use near ' 1,  0, 1,  current_timestamp, 1, current_timestamp, 1)' at lin at
/opt/otrs/Kernel/System/DB.pm line 340.
ERROR: OTRS-PM-17 Perl: 5.8.1 OS: linux Time: Mon Jul 12 13:47:18 2004

 Message: You have an error in your SQL syntax.  Check the manual that
corresponds to your MySQL server version for the right syntax to use near '
1,  0, 1,  current_timestamp, 1, current_timestamp, 1)' at lin, SQL: 'INSERT
INTO ticket (tn, create_time_unix, queue_id, ticket_lock_id,  user_id,
group_id, ticket_priority_id, ticket_state_id, ticket_answered,  valid_id,
create_time, create_by, change_time, change_by)  VALUES ('2004071217000177',
1089632838, 5, 1, 1,  1, , 1,  0, 1,  current_timestamp, 1,
current_timestamp, 1)'

 Traceback (1449):
   Module: Kernel::System::Ticket::CreateTicketDB (v1.70) Line: 274
   Module: Kernel::System::PostMaster::NewTicket::Run (v1.43) Line: 162
   Module: Kernel::System::PostMaster::Run (v1.40) Line: 246
   Module: /opt/otrs/bin/PostMaster.pl (v1.16) Line: 101

ERROR: OTRS-PM-17 Perl: 5.8.1 OS: linux Time: Mon Jul 12 13:47:18 2004

 Message: create db record failed!!!

 Traceback (1449):
   Module: Kernel::System::Ticket::CreateTicketDB (v1.70) Line: 300
   Module: Kernel::System::PostMaster::NewTicket::Run (v1.43) Line: 162
   Module: Kernel::System::PostMaster::Run (v1.40) Line: 246
   Module: /opt/otrs/bin/PostMaster.pl (v1.16) Line: 101

ERROR: OTRS-PM-17 Perl: 5.8.1 OS: linux Time: Mon Jul 12 13:47:18 2004

 Message: Need TicketID!

 Traceback (1449):
   Module: Kernel::System::Ticket::Article::CreateArticle (v1.52) Line: 41
   Module: Kernel::System::PostMaster::NewTicket::Run (v1.43) Line: 206
   Module: Kernel::System::PostMaster::Run (v1.40) Line: 246
   Module: /opt/otrs/bin/PostMaster.pl (v1.16) Line: 101

ERROR: OTRS-PM-17 Perl: 5.8.1 OS: linux Time: Mon Jul 12 13:47:18 2004

 Message: Need TicketID!

 Traceback (1449):
   Module: Kernel::System::Ticket::State::SetState (v1.17) Line: 47
   Module: Kernel::System::PostMaster::NewTicket::Run (v1.43) Line: 229
   Module: Kernel::System::PostMaster::Run (v1.40) Line: 246
   Module: /opt/otrs/bin/PostMaster.pl (v1.16) Line: 101

ERROR: OTRS-PM-17 Perl: 5.8.1 OS: linux Time: Mon Jul 12 13:47:18 2004

 Message: Can't process email with MessageID
<<[EMAIL PROTECTED]>>! Please
create a bug report with this email (var/spool/) on http://bugs.otrs.org/!

 Traceback (1449):
   Module: Kernel::System::PostMaster::NewTicket::Run (v1.43) Line: 234
   Module: Kernel::System::PostMaster::Run (v1.40) Line: 246
   Module: /opt/otrs/bin/PostMaster.pl (v1.16) Line: 101

procmail: [1442] Mon Jul 12 13:47:18 2004
procmail: Assigning "LASTFOLDER=/opt/otrs/bin/PostMaster.pl"
procmail: Unlocking ".lock"
>From [EMAIL PROTECTED]  Mon Jul 12 13:47:16 2004
 Subject: jaja
  Folder: /opt/otrs/bin/PostMaster.pl
1220
procmail: Notified comsat: "otrs@:/opt/otrs/bin/PostMaster.pl"

_______________________________________________
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 oder Consulting f�r Ihr OTRS System?
=> http://www.otrs.de/

Reply via email to