[jira] [Commented] (OFBIZ-4535) Search using Russian word (maybe others) causes distortion and failed product search

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Commented] (OFBIZ-4535) Search using Russian word (maybe others) causes distortion and failed product search

Nicolas Malin (Jira)

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

Sebastian Wachinger commented on OFBIZ-4535:
--------------------------------------------

The presence of _CatalogUrlFilter_ somehow manages to scramble the input of *all* the forms in the ecommerce app, i.e. customer name and addresses, EFT account details, search etc.; since I partially bypassed _CatalogUrlFilter_ with the quick and dirty hack in my last comment, all those forms do work again for the whole UTF-8 encoded Unicode character set. So if _keywordsearch.groovy_ is the culprit, it might not be the only one.

@paul: Thanks a lot for the input on the patch in [OFBIZ-5312|https://issues.apache.org/jira/browse/OFBIZ-5312], it's highly appreciated! I noticed that [over there|https://issues.apache.org/jira/browse/OFBIZ-5312] things start to happen now, so this definitely is _an idea whose time has come_!
Once we have this in OFBiz, the issue of this here thread and [others|https://issues.apache.org/jira/browse/OFBIZ-2837] related to it will be gone.

> 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 12.04 (demo) and trunk and it produces the same issue.  This means that multi-language product search is broken in OFBiz.  11.04 is unaffected.



--
This message was sent by Atlassian JIRA
(v6.1#6144)