Bug 46752 - quick search barfs on non-ASCII characters
Summary: quick search barfs on non-ASCII characters
Status: RESOLVED FIXED
Alias: None
Product: freedesktop.org
Classification: Unclassified
Component: Bugzilla (show other bugs)
Version: unspecified
Hardware: All All
: medium normal
Assignee: fd.o Admin Massive
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on: 50198
Blocks:
  Show dependency treegraph
 
Reported: 2012-02-29 01:14 UTC by Lionel Elie Mamane
Modified: 2012-09-23 09:24 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:


Attachments

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.