On Fri, Mar 13, 2009 at 12:42:11AM +0000, Kristian Davies wrote:
> On Thu, Mar 12, 2009 at 1:51 PM, Kenneth Marshall <k...@rice.edu> wrote:
> > On Thu, Mar 12, 2009 at 08:44:23AM -0500, Kenneth Marshall wrote:
> >> Kristian,
> >>
> >> I think the problem is in SearchBuilder/Handle.pm in the function
> >> _MakeClauseCaseInsensitive. It looks like it only skips the lower()
> >> for integer values. I think that you can replace the if test with
> >> something like:
> >>
> >> if ($value !~ /^[\d:- ]+$/) { # don't downcase integer values or timestamps
> >
> > Oops, that should read:
> >
> > if ($value !~ /^[-\d: ]+$/) { # don't downcase integer values or timestamps
>
> Excellent. I changed this line in Handle.pm and Pg.pm and it now works again.
>
> I wonder if upgrading postgres ( 8.1.9-1.el4s1.1 -> 8.3.6-1PGDG.rhel4)
> or perl (5.8.8-4.el4s1 -> 5.8.8-6.el4s1_3) could have caused this, as
> I managed to get it working before without code tweaks.
>
> Many thanks Ken!
>
> My next project is to convert this back to mysql eventually (82k
> tickets). A task I'm not looking forward to.
>
> Cheers,
> Kristian
>
Kristian,
It does sound like something is missing because I am running
PostgreSQL 8.3.5 and did not have to make these changes. I do have
a question, why are you converting your RT instance to MySQL? Is
there a particular problem you are trying to address?
Just wondering?
Ken
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
