[rt-users] probleme in search tickets

[Malek Shabou]

 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 :
> 
> 
> 
> On Mon, Nov 10, 2003 at 02:21:53AM +0100, Malek Shabou wrote:
> > 
> >  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.
> 
> -- 
> http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.

-- 
Malek Shabou				    E-mail: nic at 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

### Utiliser http://www.nic.fr/zonecheck/ pour verifier vos domaines ###