Hi Daniel, it seems, that you also deleted all entries from "ticket_state" table. Make sure that you have all states in there. -Martin http://edenhofer.de/ On 26.01.2011, at 11:52, IT-Mailinglists wrote:

Hi,

I set up a virtual machine to test some things with OTRS version 3.0.5. Therefore I made a dump of our database and imported it on the testing machine. Now I want to delete all tickets, but want to keep every other setting like queues, agents... I tried both options described in the FAQ [1], but if I want to fetch a new email (using POP3) to create a new ticket I get the following error message in otrs.log:

[Tue Jan 25 13:13:52 2011][Error][Kernel::System::Ticket::TicketCreate][405] No StateID for 'new'! [Tue Jan 25 13:13:52 2011][Error][Kernel::System::MailAccount::POP3::Fetch][205] POP3: Can't process mail, see log sub system (/opt/otrs/var/spool/problem-email-59de7d5a2012c2f1dd796420f80dfbcf, report it on http://bugs.otrs.org/)! [Tue Jan 25 13:13:52 2011][Notice][Kernel::System::MailAccount::POP3::Fetch] POP3: Fetched 1 email(s) from .

Executing otrs.PostMasterMailbox.pl manually reveals the following messages:

ERROR: OTRS-PostMasterMailbox.pl-12 Perl: 5.10.0 OS: linux Time: Tue Jan 25 13:13:52 2011

Message: No StateID for 'new'!

Traceback (3538): Module: Kernel::System::Ticket::TicketCreate (v1.486) Line: 405 Module: Kernel::System::PostMaster::NewTicket::Run (v1.76) Line: 147 Module: Kernel::System::PostMaster::Run (v1.85) Line: 351 Module: Kernel::System::MailAccount::POP3::Fetch (v1.8) Line: 201 Module: Kernel::System::MailAccount::MailAccountFetch (v1.16) Line: 386 Module: main::Fetch (v1.3) Line: 180 Module: ./otrs.PostMasterMailbox.pl (v1.3) Line: 93

ERROR: OTRS-PostMasterMailbox.pl-12 Perl: 5.10.0 OS: linux Time: Tue Jan 25 13:13:52 2011

Message: POP3: Can't process mail, see log sub system (/opt/otrs/var/spool/problem-email-59de7d5a2012c2f1dd796420f80dfbcf, report it on http://bugs.otrs.org/)!

Traceback (3538): Module: Kernel::System::MailAccount::POP3::Fetch (v1.8) Line: 205 Module: Kernel::System::MailAccount::MailAccountFetch (v1.16) Line: 386 Module: main::Fetch (v1.3) Line: 180 Module: ./otrs.PostMasterMailbox.pl (v1.3) Line: 93

So, how can I safely delete all tickets in the database?

Regards, Daniel

[1] http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&CategoryID=4&ItemID=54