Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI

2009-01-25 Thread kem cho
torsten.br...@kuehne-nagel.com Subject: AW: [rt-users] Strange,long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI To: kemcho12...@yahoo.com, Emmanuel Lacour elac...@easter-eggs.com Cc: rt-users@lists.bestpractical.com Date: Saturday, January 24, 2009, 2:43 AM Hi Kem,   same

Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI

2009-01-25 Thread Ruslan Zakirov
running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI On Fri, Jan 23, 2009 at 02:55:21PM +0100, Ham MI-ID, Torsten Brumm wrote: Hi Emmanuel, just for my understanding: If they have somewhere the right to own ticket and i do a bulk update only in one queue where only 5 people

Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI

2009-01-25 Thread Torsten Brumm
-users-boun...@lists.bestpractical.com [mailto: rt-users-boun...@lists.bestpractical.com] Im Auftrag von Emmanuel Lacour Gesendet: Freitag, 23. Januar 2009 15:25 An: rt-users@lists.bestpractical.com Betreff: Re: [rt-users] Strange,long running MySQL Query under RT 3.6.5 / MySQL 5.0.67

Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI

2009-01-24 Thread Ham MI-ID, Torsten Brumm
: Freitag, 23. Januar 2009 16:14 An: rt-users@lists.bestpractical.com Betreff: Re: [rt-users] Strange,long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI On Fri, Jan 23, 2009 at 04:01:13PM +0100, Torsten Brumm wrote: Hi Emmanuel, now back home and try on monday. so

Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI

2009-01-24 Thread Ham MI-ID, Torsten Brumm
...@lists.bestpractical.com] Im Auftrag von kem cho Gesendet: Freitag, 23. Januar 2009 18:41 An: torsten.br...@googlemail.com Cc: rt-users@lists.bestpractical.com Betreff: Re: [rt-users] Strange,long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI Do you know which file controls this drop down

Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI

2009-01-24 Thread Ham MI-ID, Torsten Brumm
. --- On Fri, 1/23/09, Emmanuel Lacour elac...@easter-eggs.com wrote: From: Emmanuel Lacour elac...@easter-eggs.com Subject: Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI To: rt-users@lists.bestpractical.com Date

Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3/FastCGI

2009-01-24 Thread Ham MI-ID, Torsten Brumm
- Von: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von Emmanuel Lacour Gesendet: Freitag, 23. Januar 2009 15:25 An: rt-users@lists.bestpractical.com Betreff: Re: [rt-users] Strange,long running MySQL Query under RT 3.6.5 / MySQL 5.0.67

Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 / Apache2.2.3 /FastCGI

2009-01-23 Thread Ham MI-ID, Torsten Brumm
-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von Ham MI-ID, Torsten Brumm Gesendet: Freitag, 23. Januar 2009 10:03 An: rt-users Betreff: [rt-users] Strange,long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 / Apache2.2.3 /FastCGI Hi RT

Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 / Apache2.2.3 /FastCGI

2009-01-23 Thread Ham MI-ID, Torsten Brumm
,long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 / Apache2.2.3 /FastCGI Hi RT Users and MySQL Gurus, since some days i have several times the day many queries like this: Id: 1174494 User: rt_user Host: 10.61.2.98:59549 Db: rt3 Time: 190 Command: Query State: Copying to tmp table SELECT

Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 / Apache2.2.3 /FastCGI

2009-01-23 Thread Emmanuel Lacour
On Fri, Jan 23, 2009 at 02:35:45PM +0100, Ham MI-ID, Torsten Brumm wrote: Hi Together, it's me again. Has anyone a idea why this query starts on each BulkUpdate Page? I have just fired up this query in query browser and the result is a big list of 1255 Users, mixed priviledged and

Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI

2009-01-23 Thread Ham MI-ID, Torsten Brumm
] Im Auftrag von Emmanuel Lacour Gesendet: Freitag, 23. Januar 2009 14:51 An: rt-users@lists.bestpractical.com Betreff: Re: [rt-users] Strange,long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI On Fri, Jan 23, 2009 at 02:35:45PM +0100, Ham MI-ID, Torsten Brumm wrote: Hi

Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI

2009-01-23 Thread Emmanuel Lacour
On Fri, Jan 23, 2009 at 02:55:21PM +0100, Ham MI-ID, Torsten Brumm wrote: Hi Emmanuel, just for my understanding: If they have somewhere the right to own ticket and i do a bulk update only in one queue where only 5 people have own ticket rights, all the users will be queried? How can i

Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI

2009-01-23 Thread Emmanuel Lacour
On Fri, Jan 23, 2009 at 03:24:40PM +0100, Emmanuel Lacour wrote: On Fri, Jan 23, 2009 at 02:55:21PM +0100, Ham MI-ID, Torsten Brumm wrote: Hi Emmanuel, just for my understanding: If they have somewhere the right to own ticket and i do a bulk update only in one queue where only 5 people

Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI

2009-01-23 Thread Emmanuel Lacour
On Fri, Jan 23, 2009 at 03:37:17PM +0100, Emmanuel Lacour wrote: But ... we can probably reduce the list of owners to those corresponding to the list of queues displayed in Elements/SelectQueues instead of all Owners of the RT system. humm I'm a bit busy now, I open a bug for you to try to

Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI

2009-01-23 Thread Torsten Brumm
Hi Emmanuel, now back home and try on monday. so it is coming form the SelectOwner Dropdown? I remember some years ago something similar at the querybuilder page and i think jesse fixed this by replacing the dropdown with a normal textbox...will try it out and keep you up2date. Have a nice

Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI

2009-01-23 Thread Emmanuel Lacour
On Fri, Jan 23, 2009 at 04:01:13PM +0100, Torsten Brumm wrote: Hi Emmanuel, now back home and try on monday. so it is coming form the SelectOwner Dropdown? I remember some years ago something similar at the querybuilder page and i think jesse fixed this by replacing the dropdown with a normal

Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI

2009-01-23 Thread kem cho
: From: Torsten Brumm torsten.br...@googlemail.com Subject: Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI To: Emmanuel Lacour elac...@easter-eggs.com Cc: rt-users@lists.bestpractical.com Date: Friday, January 23, 2009, 9:01 AM Hi Emmanuel

Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI

2009-01-23 Thread Emmanuel Lacour
On Fri, Jan 23, 2009 at 09:40:34AM -0800, kem cho wrote: Do you know which file controls this drop down box? ...replacing the dropdown with a normal textbox...   I am having exactly the same problem, but cannot find which file / code is controlling this.   share/html/Search/Bulk.html,

Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI

2009-01-23 Thread kem cho
Lacour elac...@easter-eggs.com wrote: From: Emmanuel Lacour elac...@easter-eggs.com Subject: Re: [rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI To: rt-users@lists.bestpractical.com Date: Friday, January 23, 2009, 11:51 AM On Fri, Jan 23, 2009