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
