Re: [rt-users] chart and number out of sync

2012-03-02 Thread Gerard FENELON
Hi Thomas I don't have a clue about your problem, but I am pretty sure that the first question will be : which version of RT are you using ? Gerard On 2012-03-02 04:06, Thomas Lau wrote: Dear All, we are

Re: [rt-users] chart and number out of sync

2012-03-02 Thread Thomas Lau
...@lists.bestpractical.com] On Behalf Of Gerard FENELON Sent: Friday, March 02, 2012 7:03 PM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] chart and number out of sync Hi Thomas I don't have a clue about your problem, but I am pretty sure that the first question will be : which version

Re: [rt-users] chart and number out of sync

2012-03-02 Thread Thomas Sibley
On 03/01/2012 10:06 PM, Thomas Lau wrote: Dear All, we are suffering some strange issue where the chart and number is out of sync, anyone have idea why? What's the query you're running when grouping by Owner Name in that chart? Do you have $UseSQLForACLChecks turned on in your

Re: [rt-users] chart and number out of sync

2012-03-02 Thread Thomas Lau
@lists.bestpractical.com Sent: Fri Mar 02 22:46:35 2012 Subject: Re: [rt-users] chart and number out of sync On 03/01/2012 10:06 PM, Thomas Lau wrote: Dear All, we are suffering some strange issue where the chart and number is out of sync, anyone have idea why? What's the query you're running when

Re: [rt-users] chart and number out of sync

2012-03-02 Thread Thomas Sibley
On 03/02/2012 10:31 AM, Thomas Lau wrote: No, I don't have that ACL line on config, should I use it? Potentially. It's just a guess; I didn't dug into the charting code to see if it would fix the root cause I'm betting on. What's the query you're running when grouping by Owner Name in that

Re: [rt-users] chart and number out of sync

2012-03-02 Thread Thomas Lau
@lists.bestpractical.com rt-users@lists.bestpractical.com Sent: Fri Mar 02 23:37:03 2012 Subject: Re: [rt-users] chart and number out of sync On 03/02/2012 10:31 AM, Thomas Lau wrote: No, I don't have that ACL line on config, should I use it? Potentially. It's just a guess; I didn't dug

Re: [rt-users] chart and number out of sync

2012-03-02 Thread Thomas Sibley
On 03/02/2012 10:49 AM, Thomas Lau wrote: I have seen the complex and simple queue happen same problem as well, simple as create equal today Try this in your RT_SiteConfig.pm then: Set($UseSQLForACLChecks, 1); RT Training Sessions (http://bestpractical.com/services/training.html)

Re: [rt-users] chart and number out of sync

2012-03-02 Thread Thomas Lau
Mar 03 00:00:02 2012 Subject: Re: [rt-users] chart and number out of sync On 03/02/2012 10:49 AM, Thomas Lau wrote: I have seen the complex and simple queue happen same problem as well, simple as create equal today Try this in your RT_SiteConfig.pm then: Set($UseSQLForACLChecks, 1

Re: [rt-users] chart and number out of sync

2012-03-02 Thread Thomas Sibley
On 03/02/2012 11:54 AM, Thomas Lau wrote: Mind to explain what does it do? All config options are documented in etc/RT_Config.pm. You copy lines you want from there and add them to your RT_SiteConfig.pm grep -A 10 UseSQLForACLChecks etc/RT_Config.pm The second paragraph (This option is

[rt-users] chart and number out of sync

2012-03-01 Thread Thomas Lau
Dear All, we are suffering some strange issue where the chart and number is out of sync, anyone have idea why? [cid:image001.png@01CCF864.75619810] Thomas Lau Technology Analyst Principle One Limited 27/F Kinwick Centre, 32 Hollywood Road, Central, Hong Kong T +852 3555 2217 F +852 3555