Page 1 of 1
[SOLVED] - multiple language search error
Posted: Wed Apr 22, 2020 5:43 am
by mangood442
i installed open cart 3 and journal 3 theme
when i used my website language English and search by Arabic language not found results
and when i used website language Arabic and search by English not found results
how i can solve this issue
Re: multiple language search error
Posted: Wed Apr 22, 2020 7:05 am
by straightlight
This topic has now been moved to the OpenCart 3.0 Support > General Support section of the forum.
Re: multiple language search error
Posted: Wed Apr 22, 2020 7:07 am
by straightlight
Contact the Arabic language extension pack developer to resolved this issue.
Re: multiple language search error
Posted: Wed Apr 22, 2020 8:53 am
by letxobnav
That is because the product search is preformed on product name, tag and description in the active language which is reasonable.
however, if you like you can remove the language restriction:
in catalog/model/catalog/product.php
functions getProducts() and getTotalProducts()
change:
Code: Select all
$sql .= " LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND p.status = '1' ";
to:
Code: Select all
$sql .= " LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) WHERE p.status = '1' ";
Re: multiple language search error
Posted: Wed Apr 22, 2020 6:25 pm
by mangood442
thank's for All
i solved by
addons
free ExtendedSearch
Re: multiple language search error
Posted: Wed Apr 22, 2020 6:29 pm
by paulfeakins
mangood442 wrote: ↑Wed Apr 22, 2020 5:43 am
i installed open cart 3 and journal 3 theme
You installed a nice, cleanly coded system ... and then you installed a big fat bloated theme
Re: multiple language search error
Posted: Fri Oct 13, 2023 6:44 pm
by emptycart
mangood442 wrote: ↑Wed Apr 22, 2020 6:25 pm
thank's for All
i solved by
addons
free ExtendedSearch
How could this extension solve your issue? As fas as I can tell this extension does not have multi-language support?