Forums / Setup & design / Problem: search, UTF-8, 3.5rc1

Problem: search, UTF-8, 3.5rc1

Author Message

Mikhail Chekanov

Friday 26 November 2004 3:48:19 am

I have a problem with 3.5rc1 (MySQL 4.1.7, Apache/1.3.31 (Win32) PHP/4.3.10RC2-dev):
eZ was configured to use UTF-8 everywere, russian locale was modified to use UTF-8 and MySQL use UTF-8/utf8_general_ci.
Everything is OK, except search:
1. ezsearch_word contains only latin characters - can't understand whats wrong
2. searching english word 'publish' i got errors in SQL queries:

SELECT id, word, object_count FROM ezsearch_word where  word='�������'
SELECT node_id, path_string FROM ezcontentobject_tree WHERE node_id IN (  1 )
SELECT * FROM ezsearch_search_phrase WHERE phrase='publish'

What happens with the first query?
3. searching russian word 'cyrillic_text', i got PHP warnings:

Uninitialized string offset:  10 in lib\ezi18n\classes\ezutf8codec.php on line 179
Undefined index:  wildCardCount in kernel\search\plugins\ezsearchengine\ezsearchengine.php on line 616
array_keys(): The first argument should be an array in kernel\search\plugins\ezsearchengine\ezsearchengine.php on line 1925
Invalid argument supplied for foreach() in kernel\search\plugins\ezsearchengine\ezsearchengine.php on line 1925

followed by correct sql query:

SELECT * FROM ezsearch_search_phrase WHERE phrase='cyrillic_text'

Any ideas?

--
mike
#6595551

Mikhail Chekanov

Monday 29 November 2004 3:09:26 am

Fixed in Rev. 10077 :)

--
mike
#6595551