Details
-
Bug
-
Resolution: Unresolved
-
Medium
-
None
-
4.5.0
-
None
-
eZ Publish 4.5, eZ Find 2.5
FF7
IE9
Chrome 15
Description
With the browser's encoding set to "Unicode (UTF-8)", searching for words containing umlauts such as "Kröpcke" yields results, as expected. However, if the browser's encoding is set to "Western (ISO-8859-1)", a transaction error occurs:
Fatal error: A database transaction in eZ Publish failed. The current execution was stopped to prevent further problems. You should contact the System Administrator of this site with the information on this page. The current transaction ID is TRANSID-9e5069250e55b4c12fac56e6378d8b3c and has been logged. Please include the transaction ID and the current URL when contacting the system administrator.
eZ debug lists 2 errors:
Error: eZMySQLiDB Query error (1062): Duplicate entry 'kr' for key 'ezsearch_search_phrase_phrase'. Query: INSERT INTO ezsearch_search_phrase ( phrase, phrase_count, result_count ) VALUES ( 'kr?pcke', 1, 0 )
Error: eZDBInterface::commit TRANSID-9e5069250e55b4c12fac56e6378d8b3c Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-9e5069250e55b4c12fac56e6378d8b3c.
Steps to reproduce
1. Create an article containing word(s) with umlauts such as "Kröpcke";
2. Run SOLR indexing;
3. With the browser's encoding set to "Unicode (UTF-8)", searching for "Kröpcke" yields results, as expected. However,
if the browser's encoding is set to "Western (ISO-8859-1)", a transaction error occurs:
Fatal error: A database transaction in eZ Publish failed. The current execution was stopped to prevent further problems. You should contact the System Administrator of this site with the information on this page. The current transaction ID is TRANSID-9e5069250e55b4c12fac56e6378d8b3c and has been logged. Please include the transaction ID and the current URL when contacting the system administrator.
Debug lists 2 errors:
Error: eZMySQLiDB Query error (1062): Duplicate entry 'kr' for key 'ezsearch_search_phrase_phrase'. Query: INSERT INTO ezsearch_search_phrase ( phrase, phrase_count, result_count ) VALUES ( 'kr?pcke', 1, 0 )
Error: eZDBInterface::commit TRANSID-9e5069250e55b4c12fac56e6378d8b3c Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-9e5069250e55b4c12fac56e6378d8b3c.