Bug 46752

Summary:	quick search barfs on non-ASCII characters
Product:	freedesktop.org	Reporter:	Lionel Elie Mamane <lionel>
Component:	Bugzilla	Assignee:	fd.o Admin Massive <sitewranglers>
Status:	RESOLVED FIXED	QA Contact:
Severity:	normal
Priority:	medium	CC:	LpSolit
Version:	unspecified
Hardware:	All
OS:	All
Whiteboard:
i915 platform:		i915 features:
Bug Depends on:	50198
Bug Blocks:

Description Lionel Elie Mamane 2012-02-29 01:14:14 UTC

Enter "martedì" in quicksearch. Press "search" or "quick search" button. Error message:

DBD::Pg::db selectcol_arrayref failed: ERROR:  invalid byte sequence for encoding "UTF8": 0xec273a
HINT:  This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding". [for Statement "SELECT products.id FROM products WHERE POSITION(LOWER('martedÃƒÂ¬'::text) IN LOWER(products.name::text)::text) > 0"] at Bugzilla/Search.pm line 1269
	Bugzilla::Search::build_subselect('bugs.product_id', 'products.id', 'products', 'POSITION(LOWER(\'marted\x{ec}\'::text) IN LOWER(products.name::tex...') called at Bugzilla/Search.pm line 2063
	Bugzilla::Search::_product_nonchanged('Bugzilla::Search=HASH(0x3842878)', 'multi_fields', 'ARRAY(0x2e1e7a0)', 'sequence', 'SCALAR(0x2e53600)', 'ff', 'SCALAR(0x2e540c8)', 'wherepart', 'ARRAY(0x2e1e548)', ...) called at Bugzilla/Search.pm line 1160
	Bugzilla::Search::do_search_function('Bugzilla::Search=HASH(0x3842878)', 'HASH(0x3888090)') called at Bugzilla/Search.pm line 963
	Bugzilla::Search::init('Bugzilla::Search=HASH(0x3842878)') called at Bugzilla/Search.pm line 409
	Bugzilla::Search::new('Bugzilla::Search', 'fields', 'ARRAY(0x31ede68)', 'params', 'Bugzilla::CGI=HASH(0x2fb5b28)', 'order', 'ARRAY(0x3213098)') called at /srv/bugs.freedesktop.org/www/buglist.cgi line 840
For help, please send mail to the webmaster (sitewranglers@freedesktop.org), giving this error message and the time and date of the error.


The correct UTF-8 encoding is of 'ì' is c3 ac, and it is correct in the URL bar: https://bugs.freedesktop.org/buglist.cgi?quicksearch=marted%C3%AC
So bugzilla and/or its interface to PostgreSQL does something fishy to it.

By contrast, the advanced search deals OK with non-ASCII characters: try https://bugs.freedesktop.org/buglist.cgi?list_id=47710&short_desc=marted%C3%AC&query_format=advanced&short_desc_type=allwordssubstr

Comment 1 Frédéric Buclin 2012-04-23 16:46:53 UTC

This problem has been fixed in Bugzilla 4.2.1, see https://bugzilla.mozilla.org/show_bug.cgi?id=730207. You should upgrade bugs.freedesktop.org to this version.

Comment 2 Benjamin Close 2012-09-21 12:18:46 UTC

Tracing this down, bug is fixed in: 

https://bugzilla.mozilla.org/show_bug.cgi?id=554819

An upgrade to Bugzilla 4.2.x will fix the issue

Comment 3 Tollef Fog Heen 2012-09-23 09:24:55 UTC

We've upgraded to 4.2.3 where this bug has been fixed.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.