Re: [rt-users] Ludicrously slow queries on custom fields

2006-10-17 Thread Tony Bowden
On Mon, Oct 16, 2006 at 03:55:11PM -0400, Jesse Vincent wrote: In further investigation we found a line in the DBIx::SearchBuilder Changes file from earlier this year that says: * Allow ORs on left joins It's conceivable that that was upgraded with mysql - is it possible that this

Re: [rt-users] Ludicrously slow queries on custom fields

2006-10-17 Thread Jay R. Ashworth
On Mon, Oct 16, 2006 at 08:24:27PM +0100, Tony Bowden wrote: In further investigation we found a line in the DBIx::SearchBuilder Changes file from earlier this year that says: * Allow ORs on left joins It's conceivable that that was upgraded with mysql - is it possible that this change

[rt-users] multi-instance patch for 3.6.1

2006-10-17 Thread Armaghan Saqib
Hi, Does the multi-instance patch works correctly for 3.6.1 or do I need to make some adjustments. I installed 3.6.1 on freebsd with make MULTIPLE_INSTANCES=yes but it did not patch the files as was done for 3.4.5. Regards ___

Re: [rt-users] multi-instance patch for 3.6.1

2006-10-17 Thread Vivek Khera
On Oct 17, 2006, at 1:09 PM, Armaghan Saqib wrote: I installed 3.6.1 on freebsd with make MULTIPLE_INSTANCES=yes but it did not patch the files as was done for 3.4.5. This flag exists no more in the RT 3.6 port for FreeBSD. I'll be happy to add such a flag if someone is willing to

[rt-users] migrating to a different host, maintaining MySQL data, but changing $rtname

2006-10-17 Thread Lee Whalen
Hello all, so I'm in a bit of a pickle. I rolled out RT 3.4.5 on a testing-only basis to a low-end desktop server running Debian Etch called, cleverly enough, 'betart', fully intending to purchase better server-grade hardware and migrate over to it once we worked all our initial mistakes

[rt-users] searching Custom Field history

2006-10-17 Thread Brian Kerr
Hi, We have several queues where the historical data in Custom Fields is of some importance to us for reporting purposes. For example, one such field is Result, where the value would be one of Rescheduled,Canceled,Audited, and so on. Is there any way to search on the history of these fields?

[rt-users] Access to Ticket Content in scrip's User Defined Action

2006-10-17 Thread Samuel P Howard
Hi. I have a scrip that runs on a User Defined condition, but I get blank emails when other transactions happen (like New-Open) ... how can I test for something like Transaction-Content (not real code, I know) having some value? I've tried various combinations of Transaction, TicketObj, etc

[rt-users] RT Install Options

2006-10-17 Thread Sean Cherchio
Hi All, Ive been trying to install RT with a few install options like ./configure \ prefix=/usr/share/request-tracker3.4 \ --exec-prefix=/usr/share/request-tracker3.4 \ --sysconfdir=/usr/local/share/rtinst/rttw/etc \ --datadir=/usr/local/share/rtinst/rttw But after running