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

[kem cho]

Hi Torsten,
I followed what you mention about Bulk update page and querybuilder page. It works great on old release of RT. I also have a test machine (running Fedora 9, perl 5.10, mysql 5.0), where I installed RT3.8.1
 
In RT 3.8.1, it looks like PickBasics program was modified, and it does not have the line you mention to modify. So, as a work around, I copied PickBasics file from older release of RT, and it seems to be working. Now, I do not have a drop down with the list of all RT users, it displays a text input box, which is fine (atleast the page loads in fraction of a second).
 
This week, I will work on installing RT 3.8.2 back on my test machine and see if my work around works with it.
 
I (and the users) really do appreciate your help with this...
 

--- On Sat, 1/24/09, Ham MI-ID, Torsten Brumm <torsten.brumm at Kuehne-Nagel.com> wrote:

From: Ham MI-ID, Torsten Brumm <torsten.brumm at 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: kemcho12345 at yahoo.com, "Emmanuel Lacour" <elacour at easter-eggs.com>
Cc: rt-users at lists.bestpractical.com
Date: Saturday, January 24, 2009, 2:43 AM



Hi Kem,
 
same problem here, the querybuilder page was also slow until i got a hint from jesse:
 
Make first a local copy of /rthome/share/html/Search/Elements/PickBasics to /rthome/local/html/Search/Elements/PickBasics 
 
Replace here:
 
<& /Elements/SelectOwner, Name => "ValueOfActor", ValueAttribute => 'Name' &>
 
With:
 
<input name="ValueOfActor">
 
>From now QueryBuilder Page is much, much faster!

Torsten



Kühne + Nagel (AG & Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), Uwe Bielang (Stellv.), Dirk Blesius (Stellv.), Bruno Mang, Alfred Manke, Christian Marnetté (Stellv.), Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persönlich haftende Gesellschaft: Kühne & Nagel A.G., Sitz: Contern/Luxemburg, Geschäftsführender Verwaltungsrat: Klaus-Michael Kühne 



Von: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] Im Auftrag von kem cho
Gesendet: Freitag, 23. Januar 2009 22:19
An: Emmanuel Lacour
Cc: rt-users at 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







Emmanuel,
I also wanted to know if there is a way to edit the query that runs when QueryBuilder page loads? (Search/Build.html) I am unable to find this, as I am not quite a perl expert.
 
This is because we have an issue in RT where it displays many many users as "Owner" in QueryBuilder page, but when I run a query from mysql prompt, it only shows me handful of users with "OwnTicket" right. Based on this, to me it feels like my data is correct, but I could be wrong, as I have been working with RT software for only a month now.
 
Thanks for your help.
 
 
 


--- On Fri, 1/23/09, Emmanuel Lacour <elacour at easter-eggs.com> wrote:

From: Emmanuel Lacour <elacour at 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 at lists.bestpractical.com
Date: Friday, January 23, 2009, 11:51 AM

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, replace the line with /Elements/SelectOwner
with a text input field using the same name.

_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales at bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com




      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090125/72a0794b/attachment.htm>