[ 
https://issues.apache.org/jira/browse/OFBIZ-4535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13657702#comment-13657702
 ] 

mz4wheeler commented on OFBIZ-4535:
-----------------------------------

OK: I managed to track this down.  The problem first showed up in r1127449, 
committed by Hans:

r1127449 | hansbak | 2011-05-25 02:25:16 -0700 (Wed, 25 May 2011) | 1
Changed paths:
   M /ofbiz/trunk/applications/order/webapp/ordermgr/entry/cart/minicart.ftl
   M 
/ofbiz/trunk/applications/order/webapp/ordermgr/entry/catalog/breadcrumbs.ftl
   M 
/ofbiz/trunk/applications/order/webapp/ordermgr/entry/catalog/categorydetail.ftl
   M 
/ofbiz/trunk/applications/order/webapp/ordermgr/entry/catalog/compareproducts.ftl
   M 
/ofbiz/trunk/applications/order/webapp/ordermgr/entry/catalog/productsummary.ftl
   M 
/ofbiz/trunk/applications/product/src/org/ofbiz/product/category/CatalogUrlFilter.java
   M /ofbiz/trunk/specialpurpose/ecommerce/data/DemoConfigurator.xml
   M /ofbiz/trunk/specialpurpose/ecommerce/data/DemoFinAccount.xml
   M /ofbiz/trunk/specialpurpose/ecommerce/data/DemoPopularCategoriesData.xml
   M /ofbiz/trunk/specialpurpose/ecommerce/data/DemoProduct.xml
   M /ofbiz/trunk/specialpurpose/ecommerce/data/DemoPurchasing.xml
   M /ofbiz/trunk/specialpurpose/ecommerce/webapp/ecomclone/WEB-INF/web.xml
   M /ofbiz/trunk/specialpurpose/ecommerce/webapp/ecommerce/WEB-INF/web.xml
   M /ofbiz/trunk/specialpurpose/ecommerce/webapp/ecommerce/cart/showcart.ftl
   M 
/ofbiz/trunk/specialpurpose/ecommerce/webapp/ecommerce/catalog/ShowBestSellingCategory.ftl
   M 
/ofbiz/trunk/specialpurpose/ecommerce/webapp/ecommerce/catalog/minilastviewedcategories.ftl
   M 
/ofbiz/trunk/specialpurpose/ecommerce/webapp/ecommerce/catalog/miniproductsummary.ftl
   M 
/ofbiz/trunk/specialpurpose/ecommerce/webapp/ecommerce/catalog/productdetail.ftl
   M 
/ofbiz/trunk/specialpurpose/ecommerce/webapp/ecommerce/catalog/sidedeepcategory.ftl

this change will introduce seo friendly urls for products and categories which 
are generated from the description. It also allows to convert url's from 
previous systems to point to the product in the current system. In the 
ecommerce demo records have been added to show this feature.
------------------------------------------------------------------------

I looked over the diff (attached file) and it isn't obvious to me how this is 
affects searching with a UTF8 word.  The same issue is present in both the 
standard/advanced ecommerce search, 12.04/trunk, but the back-end search is not 
affected.  Maybe Hans can look it over.

                
> Search using Russian word (maybe others) causes distortion and failed product 
> search
> ------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-4535
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4535
>             Project: OFBiz
>          Issue Type: Bug
>          Components: specialpurpose/ecommerce
>    Affects Versions: SVN trunk, Release Branch 12.04
>         Environment: Ubuntu and others.
>            Reporter: mz4wheeler
>         Attachments: r1127449-r1127394.diff
>
>
> NOTE: The following post contains UTF8 characters.
> After rebuilding keywords in a UTF8 database (postgres) and searching a UTF8 
> browser (chrome), the Russian phrase is correctly present in the database, as 
> follows:
> ofbiz=# select * from product_keyword where keyword = 'игроков';
>    product_id    | keyword | relevancy_weight (trimmed)
> -----------------+---------+-----------------
>  DVDMV-ADVANGYM  | игроков |                1 
> However, when pasting 'игроков' into ecommerce Search, the following is 
> returned "Not Found"
> Keywords: "Ð¸Ð³Ñ Ð¾ÐºÐ¾Ð²", where any word matches, which distorts the search.
> This may affect other languages, which I haven't tested.
> I also tried the same search in 9.04 (demo) and trunk and it produces the 
> same issue.  This means that multi-language product search is broken in OFBiz.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to