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 <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
