Details
-
Bug
-
Resolution: Duplicate
-
Medium
-
None
-
3.9.2
-
None
-
Operating System: Windows 2003 Server
PHP Version: (please be specific, like '4.4.3' or '5.1.5'): 4.4.4
Database and version: Mysql
Browser (and version): Firefox 2.0.0.6
Description
eZ Publish has a problem while searching for a word containing a special character, e.g. with a german umlaut. The user gets a fatal error: database transaction error.
The problem occures in the PHP-function "strtolower". Please see:
http://www.sitepoint.com/blogs/2006/08/10/hot-php-utf-8-tips/
In order to fix the problem without replacing all strtolower functions (mb_strtolower) the setlocale function with parameter LC_CTYPE, 'C' will help.
We added the setlocale function in index.php.
Steps to reproduce
We searched a second time with a word with german umlaut. With this search we get the transaction error and the message:
Query error: Duplicate entry 'seifenk' for key 2. Query: INSERT INTO
ezsearch_search_phrase ( phrase, phrase_count, result_count )
VALUES ( 'seifenk��rbchen', 1, 0 )
Attachments
Issue Links
- is duplicated by
-
EZP-12428 strtolower() in eZSearchLog::addPhrase gives error for special char for e.g. ÅØÆ
- Closed