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 <mail_acc@our_mail_server>. 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 --------------------------------------------------------------------- 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
