Totally empty tickets in my queue
Check this out, I have three completely empty tickets in my queue. My server times out when trying to delete them... http://www.automaticduck.com/screenshots/emtpyotrstickets.jpg What to do? -- Wes Plate Automatic Duck, Inc. http://www.wesplate.com http://www.automaticduck.com
On Tuesday, September 07, 2004 11:55 PM
Wes Plate
Check this out, I have three completely empty tickets in my queue. My server times out when trying to delete them...
http://www.automaticduck.com/screenshots/emtpyotrstickets.jpg
What to do?
Check your OTRS log and your webserver's log. The ticketID is missing. Bad thing. Regards, Robert Kehl
On 9/7/04 3:15 PM, "Robert Kehl" wrote:
What to do?
Check your OTRS log and your webserver's log. The ticketID is missing. Bad thing.
And they're growing!! When I wrote this to the list, there were Three, now there are Forty-Three! My OTRS is going crazy! Here is part of my Apache log (OTRS log follows)... ERROR: OTRS-CGI-1 Perl: 5.8.0 OS: linux Time: Tue Sep 7 12:01:17 2004 Message: No article found for TicketID 815! Traceback (953): Module: Kernel::System::Ticket::Article::GetLastCustomerArticle (v1.52) Line: 490 Module: Kernel::Modules::AgentQueueView::ShowTicket (v1.50) Line: 215 Module: Kernel::Modules::AgentQueueView::Run (v1.50) Line: 194 Module: Apache::ROOT::otrs::index_2epl::handler (v1.66) Line: 687 Module: (eval) (v2.01) Line: 149 Module: Apache::Registry::handler (v2.01) Line: 149 ERROR: OTRS-CGI-1 Perl: 5.8.0 OS: linux Time: Tue Sep 7 12:01:17 2004 Message: Need QueueID! Traceback (953): Module: Kernel::System::Queue::GetStdResponses (v1.42) Line: 255 Module: Kernel::Modules::AgentQueueView::ShowTicket (v1.50) Line: 217 Module: Kernel::Modules::AgentQueueView::Run (v1.50) Line: 194 Module: Apache::ROOT::otrs::index_2epl::handler (v1.66) Line: 687 Module: (eval) (v2.01) Line: 149 Module: Apache::Registry::handler (v2.01) Line: 149 [Tue Sep 7 12:01:17 2004] null: Use of uninitialized value in pattern match (m//) at /opt/otrs/bin/cgi-bin/../../Kernel/Output/HTML/Generic.pm line 912. [Tue Sep 7 12:01:17 2004] null: Use of uninitialized value in substitution iterator at /opt/otrs/bin/cgi-bin/../../Kernel/Output/HTML/Generic.pm line 341. (...and on and on and on like that...) Here is the OTRS log (is there way to go further back in the log?)... Tue Sep 7 19:04:06 2004 error OTRS-CGI-1 Need QueueID! Tue Sep 7 19:04:06 2004 error OTRS-CGI-1 No article found for TicketID 831! Tue Sep 7 19:04:03 2004 error OTRS-CGI-1 Need QueueID! Tue Sep 7 19:04:03 2004 error OTRS-CGI-1 No article found for TicketID 830! Tue Sep 7 19:04:03 2004 error OTRS-CGI-1 Need QueueID! Tue Sep 7 19:04:03 2004 error OTRS-CGI-1 No article found for TicketID 829! ... And so on and so on... -- Wes Plate Automatic Duck, Inc. http://www.wesplate.com http://www.automaticduck.com
Hi Wes, On Tue, Sep 07, 2004 at 07:33:13PM -0700, Wes Plate wrote:
And they're growing!! When I wrote this to the list, there were Three, now there are Forty-Three!
My OTRS is going crazy!
Here is part of my Apache log (OTRS log follows)...
ERROR: OTRS-CGI-1 Perl: 5.8.0 OS: linux Time: Tue Sep 7 12:01:17 2004
Message: No article found for TicketID 815!
Traceback (953): Module: Kernel::System::Ticket::Article::GetLastCustomerArticle (v1.52) Line: 490 Module: Kernel::Modules::AgentQueueView::ShowTicket (v1.50) Line: 215 Module: Kernel::Modules::AgentQueueView::Run (v1.50) Line: 194 Module: Apache::ROOT::otrs::index_2epl::handler (v1.66) Line: 687 Module: (eval) (v2.01) Line: 149 Module: Apache::Registry::handler (v2.01) Line: 149
OTRS wan't to create a new ticket with articles. The new ticket gets created but OTRS isn't able to create the article. -=> So there are Ticket with now articles on it (maybe you changed something on your system). However, a ticket needs min. one article. If there is no article, then you have a problem. You need to delete this "empty" tickets from the database: mysql> DELETE FROM ticket WHERE id = 815; After that the "empty" ticket with id 815 is removed.
-- Wes Plate Automatic Duck, Inc. http://www.wesplate.com http://www.automaticduck.com
Martin Edenhofer -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication!
On 9/7/04 11:20 PM, "Martin Edenhofer" wrote:
OTRS wan't to create a new ticket with articles. The new ticket gets created but OTRS isn't able to create the article. -=> So there are Ticket with now articles on it (maybe you changed something on your system).
I've not changed anything, which is why I'm so baffled.
However, a ticket needs min. one article. If there is no article, then you have a problem. You need to delete this "empty" tickets from the database:
I don't know what caused this to happen, but I'll dive into the database now and see if I can remove all the empty tickets. -- Wes Plate Automatic Duck, Inc. http://www.wesplate.com http://www.automaticduck.com
On Wed, 8 Sep 2004 08:20:00 +0200, Martin Edenhofer
Message: No article found for TicketID 815!
However, a ticket needs min. one article. If there is no article, then you have a problem. You need to delete this "empty" tickets from the database:
mysql> DELETE FROM ticket WHERE id = 815;
Maybe helps (at least in postgresql 4.xx): -- tickets with no articles: select id from ticket except \ select ticket.id from ticket, article where article.ticket_id=ticket.id; Peter -- Now using M2, Opera's e-mail client: http://www.opera.com/m2/
On 9/8/04 12:39 AM, "Robert Kehl" wrote:
Did you rename the $Self->{PostmasterDefaultQueue}, which is 'Raw' by default?
No, nothing has changed. -- Wes Plate Automatic Duck, Inc. http://www.wesplate.com http://www.automaticduck.com
participants (4)
-
Martin Edenhofer -
Peter Gervai -
Robert Kehl -
Wes Plate