Hi,
I am using RT 3.0.6 and DBIx-SearchBuilder 0.92, i have a select one Custom Field with many values, some of them contain accents (é, Ú…).
when i try to search tickets with a special value of the custom field,
and if this value containt some accents, the search return no tickts.
are there any solution ? or i have to remove all accent from the custom
field values ?
Reagrds.
Malek Shabou E-mail: nic@nic.fr
AFNIC Tel: +33 1 39 30 83 00
Immeuble international, 2 rue Stephenson Fax: +33 1 39 30 83 01
Saint-Quentin-En-Yvelines 78180 Montigny-Le-Bretonneux
Hi,
I am using RT 3.0.6 and DBIx-SearchBuilder 0.92, i have a select one Custom Field with many values, some of them contain accents (é, Ú…).
when i try to search tickets with a special value of the custom field,
and if this value containt some accents, the search return no tickts.
are there any solution ? or i have to remove all accent from the custom
field values ?
Can you turn on database query logging and show us what it’s trying to
search for? There may be a problem with our querybuilder.
Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.
Hi,
as you have suspected it a probleme in the querybuilder, here is some
debug info:
the query is:
Statut = nouveau [effacer]
Queue = adhesion-prereg [effacer]
CF.adhesion-prereg.{rdv-formation} LIKE %annulé% [effacer]
Statut = ouvert [effacer]
and here is the genereted query:
SELECT count(DISTINCT main.id) FROM (Tickets main LEFT JOIN
TicketCustomFieldValues as TicketCustomFieldValues_1 ON ( main.id =
TicketCustomFieldValues_1.Ticket) AND(
(TicketCustomFieldValues_1.CustomField = ‘3’))) WHERE
((main.EffectiveId = main.id)) AND ((main.Type = ‘ticket’)) AND ( (
(main.Status = ‘new’)OR(main.Status = ‘open’) ) AND ( (
(TicketCustomFieldValues_1.Content LIKE 0x2525616e6e756cc3a92525) ) )
AND ( (main.Queue = ‘4’) ) )
normaly the query must be:
… (TicketCustomFieldValues_1.Content LIKE ‘%%annulé%%’) …
which causes some error:
[Mon Nov 10 16:45:59 2003] [debug]: limiting to 50 rows
(/usr/local/rt3/lib/RT/Interface/Web.pm:632)
[Mon Nov 10 16:45:59 2003] [warning]: DBD::Pg::st execute failed: ERROR:
parser: parse error at or near “x2525616e6e756cc3a92525” at character
392 at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder.pm line 234.
(/usr/local/rt3/lib/RT.pm:247)
[Mon Nov 10 16:45:59 2003] [warning]: DBIx::SearchBuilder error:ERROR:
parser: parse error at or near “x2525616e6e756cc3a92525” at character
392
Query String is SELECT count(DISTINCT main.id) FROM (Tickets
main LEFT JOIN TicketCustomFieldValues as
TicketCustomFieldValues_1 ON ( main.id =
TicketCustomFieldValues_1.Ticket) AND(
(TicketCustomFieldValues_1.CustomField = ‘3’))) WHERE
((main.EffectiveId = main.id)) AND ((main.Type = ‘ticket’)) AND
( ( (main.Status = ‘new’)OR(main.Status = ‘open’) ) AND ( (
(TicketCustomFieldValues_1.Content LIKE
0x2525616e6e756cc3a92525) ) ) AND ( (main.Queue = ‘4’) ) )
(/usr/local/rt3/lib/RT.pm:247)
[Mon Nov 10 16:45:59 2003] [warning]: DBD::Pg::st
fetchrow_array failed: no statement executing at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder.pm line 248.
(/usr/local/rt3/lib/RT.pm:247)
PS: when i try to search a value with no accent on it, all works fin.
Regards,
malek.
le 10 Nov, Jesse Vincent a écrit :
Hi,
I am using RT 3.0.6 and DBIx-SearchBuilder 0.92, i have a select one Custom Field with many values, some of them contain accents (é, Ú…).
when i try to search tickets with a special value of the custom field,
and if this value containt some accents, the search return no tickts.
are there any solution ? or i have to remove all accent from the custom
field values ?
Can you turn on database query logging and show us what it’s trying to
search for? There may be a problem with our querybuilder.
–
Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.
Malek Shabou E-mail: nic@nic.fr
AFNIC Tel: +33 1 39 30 83 00
Immeuble international, 2 rue Stephenson Fax: +33 1 39 30 83 01
Saint-Quentin-En-Yvelines 78180 Montigny-Le-Bretonneux