MessageYou'll use 2 tables first one is Queue. Get the queue_id of your RAW queue. One you have this , do a query on the ticket table to find every ticket in the RAW queue. if you want to delete all tickets in the raw queue, do something like this : delete from ticket where queue_id = ( you put the id here) To do SQL query, just click on the SQL tab at the top. Sam ----- Original Message ----- From: Neil Lehouillier To: User questions and discussions about OTRS. Sent: Tuesday, January 06, 2004 3:43 PM Subject: RE: [otrs] Overloaded otrs queue Yes I can. -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Sam Nadeau Sent: Tuesday, January 06, 2004 1:46 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] Overloaded otrs queue This will allow you to easily make query against your database. Can you see your OTRS database from phpmyadmin ? Sam ----- Original Message ----- From: Neil Lehouillier To: User questions and discussions about OTRS. Sent: Tuesday, January 06, 2004 3:40 PM Subject: RE: [otrs] Overloaded otrs queue Ok I've got in installed. Now what? I'm not very good with php so please be specific. Thanks in advance...... Neil -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Sam Nadeau Sent: Tuesday, January 06, 2004 11:08 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Overloaded otrs queue http://www.phpmyadmin.net/home_page/ google is your friend :-) Sam ----- Original Message ----- From: Neil Lehouillier To: User questions and discussions about OTRS. Sent: Tuesday, January 06, 2004 12:24 PM Subject: RE: [otrs] Overloaded otrs queue It seems that I don't. Where can I locate this program? Neil -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Sam Nadeau Sent: Tuesday, January 06, 2004 9:59 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Overloaded otrs queue Do you have phpmyadmin installed ?? I could help you solve this issue easily. Sam ----- Original Message ----- From: Neil Lehouillier To: otrs@otrs.org Sent: Tuesday, January 06, 2004 11:50 AM Subject: [otrs] Overloaded otrs queue I have a small question... How do you manual go into mysql and delete messages in the raw queue? It seems that over the holidays the otrs system created 88000 messages and put them in the raw queue. Now I can't even get otrs working properly anymore. I want to manual go into the mysql database and delete all the messages in the raw queue. Does anyone know how to do this? Thanks.. Neil ------------------------------------------------------------------ _______________________________________________ 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 Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/ ---------------------------------------------------------------------- _______________________________________________ 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 Support oder Consulting f|r Ihr OTRS System? => http://www.otrs.de/ -------------------------------------------------------------------------- _______________________________________________ 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 Support oder Consulting f|r Ihr OTRS System? => http://www.otrs.de/ ------------------------------------------------------------------------------ _______________________________________________ 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 Support oder Consulting f|r Ihr OTRS System? => http://www.otrs.de/