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

[Ham MI-ID, Torsten Brumm]

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


Kuehne + Nagel (AG & Co.) KG, Geschaeftsleitung: Hans-Georg Brinkmann (Vors.), Uwe Bielang (Stellv.), Bruno Mang, Dirk Blesius (Stellv.), Alfred Manke, Christian Marnetté (Stellv.),  Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persoenlich haftende Gesellschaft: Kuehne & Nagel A.G., Sitz: Contern/Luxemburg Geschaeftsfuehrender Verwaltungsrat: Klaus-Michael Kuehne



________________________________

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/20090124/1c985ca9/attachment.htm>