[Skip to main content](#vessel-content)

#   Configure the Hikashop search plugin

##

- **[poprockmama](/forum/user/7752-poprockmama "View poprockmama's Profile")**
- [![poprockmama's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7752-poprockmama "View poprockmama's Profile") Topic Author
- [ Offline](/forum/user/7752-poprockmama)

Less More

- Posts: 3
- Thank you received: 0
-
-

14 years 5 months ago [\#53049](#53049) by [poprockmama](/forum/user/7752-poprockmama "View poprockmama's Profile")  *[Configure the Hikashop search plugin](/forum/4-how-to/53049-configure-the-hikashop-search-plugin#53049 "Hello!  I love Hikashop but have run into a little issue. I was testing the search feature and noticed that the returns that I get have amended urls. Meaning:   poprockvintage.com/index.php/component/h...rchid-blossoms-dress ? becomes   poprockvintage.com/index.php/component/h...oms-dress?Itemid=478  This would not be a big deal except that when you click the url, a whole listing of products shows before the actual item. I probably am missing something simple, but any help would be appreciated.")* was created by *[poprockmama](/forum/user/7752-poprockmama "View poprockmama's Profile")*

Hello!

I love Hikashop but have run into a little issue. I was testing the search feature and noticed that the returns that I get have amended urls. Meaning:
[ poprockvintage.com/index.php/component/h...rchid-blossoms-dress](http://poprockvintage.com/index.php/component/hikashop/product/19-vintage-orchid-blossoms-dress)?
becomes
[ poprockvintage.com/index.php/component/h...oms-dress?Itemid=478](http://poprockvintage.com/index.php/component/hikashop/product/19-vintage-orchid-blossoms-dress?Itemid=478)

This would not be a big deal except that when you click the url, a whole listing of products shows before the actual item. I probably am missing something simple, but any help would be appreciated.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ5LWNvbmZpZ3VyZS10aGUtaGlrYXNob3Atc2VhcmNoLXBsdWdpbj9zdGFydD0wJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86556
- Thank you received: 14305
-
-

14 years 5 months ago [\#53141](#53141) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Configure the Hikashop search plugin](/forum/4-how-to/53049-configure-the-hikashop-search-plugin#53141 "Hello!  I love Hikashop but have run into a little issue. I was testing the search feature and noticed that the returns that I get have amended urls. Meaning:   poprockvintage.com/index.php/component/h...rchid-blossoms-dress ? becomes   poprockvintage.com/index.php/component/h...oms-dress?Itemid=478  This would not be a big deal except that when you click the url, a whole listing of products shows before the actual item. I probably am missing something simple, but any help would be appreciated.")*

Please make sure that the Item id option of the plugin is filled with the id of a hikashop category/products listing menu. Otherwise, it won't work properly.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ5LWNvbmZpZ3VyZS10aGUtaGlrYXNob3Atc2VhcmNoLXBsdWdpbj9zdGFydD0wJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[poprockmama](/forum/user/7752-poprockmama "View poprockmama's Profile")**
- [![poprockmama's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7752-poprockmama "View poprockmama's Profile") Topic Author
- [ Offline](/forum/user/7752-poprockmama)

Less More

- Posts: 3
- Thank you received: 0
-
-

14 years 5 months ago [\#53147](#53147) by [poprockmama](/forum/user/7752-poprockmama "View poprockmama's Profile")  Replied by *[poprockmama](/forum/user/7752-poprockmama "View poprockmama's Profile")* on topic *[Re: Configure the Hikashop search plugin](/forum/4-how-to/53049-configure-the-hikashop-search-plugin#53147 "Hello!  I love Hikashop but have run into a little issue. I was testing the search feature and noticed that the returns that I get have amended urls. Meaning:   poprockvintage.com/index.php/component/h...rchid-blossoms-dress ? becomes   poprockvintage.com/index.php/component/h...oms-dress?Itemid=478  This would not be a big deal except that when you click the url, a whole listing of products shows before the actual item. I probably am missing something simple, but any help would be appreciated.")*

Thank for the reply. I put the id of one of my categories in the item id section of the Hikashop search plugin. What happens is that the first item returned in search link to that item when clicked. Any items returned after the first has the same issue as before (a full product listing and the item itself afterward). Not sure what I am doing wrong.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ5LWNvbmZpZ3VyZS10aGUtaGlrYXNob3Atc2VhcmNoLXBsdWdpbj9zdGFydD0wJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86556
- Thank you received: 14305
-
-

14 years 5 months ago [\#53160](#53160) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Configure the Hikashop search plugin](/forum/4-how-to/53049-configure-the-hikashop-search-plugin#53160 "Hello!  I love Hikashop but have run into a little issue. I was testing the search feature and noticed that the returns that I get have amended urls. Meaning:   poprockvintage.com/index.php/component/h...rchid-blossoms-dress ? becomes   poprockvintage.com/index.php/component/h...oms-dress?Itemid=478  This would not be a big deal except that when you click the url, a whole listing of products shows before the actual item. I probably am missing something simple, but any help would be appreciated.")*

You should NOT put the id of a category in that option but the id of a HikaShop categories listing menu.
You can see them via the menu Display-&gt;Content menus.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ5LWNvbmZpZ3VyZS10aGUtaGlrYXNob3Atc2VhcmNoLXBsdWdpbj9zdGFydD0wJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile")**
- [![tanyatanya's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/513-tanyatanya "View tanyatanya's Profile")
- [ Offline](/forum/user/513-tanyatanya)

Less More

- Posts: 90
- Thank you received: 0
-
-

14 years 3 months ago [\#58197](#58197) by [tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile")  Replied by *[tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile")* on topic *[Re: Configure the Hikashop search plugin](/forum/4-how-to/53049-configure-the-hikashop-search-plugin#58197 "Hello!  I love Hikashop but have run into a little issue. I was testing the search feature and noticed that the returns that I get have amended urls. Meaning:   poprockvintage.com/index.php/component/h...rchid-blossoms-dress ? becomes   poprockvintage.com/index.php/component/h...oms-dress?Itemid=478  This would not be a big deal except that when you click the url, a whole listing of products shows before the actual item. I probably am missing something simple, but any help would be appreciated.")*

dear Nicolas,

I am now having a similar problem to the one above. my search bar will not search any products. I have tried changing the item id in the search plugin to the ones in the display&gt;content menus. I have tried every menu id there to see if any would work but they make no difference. is there something else I could try?

kind regards,
Tanya

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ5LWNvbmZpZ3VyZS10aGUtaGlrYXNob3Atc2VhcmNoLXBsdWdpbj9zdGFydD0wJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86556
- Thank you received: 14305
-
-

14 years 3 months ago [\#58262](#58262) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Configure the Hikashop search plugin](/forum/4-how-to/53049-configure-the-hikashop-search-plugin#58262 "Hello!  I love Hikashop but have run into a little issue. I was testing the search feature and noticed that the returns that I get have amended urls. Meaning:   poprockvintage.com/index.php/component/h...rchid-blossoms-dress ? becomes   poprockvintage.com/index.php/component/h...oms-dress?Itemid=478  This would not be a big deal except that when you click the url, a whole listing of products shows before the actual item. I probably am missing something simple, but any help would be appreciated.")*

Please make sure that you're using the joomla search module and not the smartsearch one.
Also check that the hikashop product search plugin is enabled.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ5LWNvbmZpZ3VyZS10aGUtaGlrYXNob3Atc2VhcmNoLXBsdWdpbj9zdGFydD0wJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile")**
- [![tanyatanya's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/513-tanyatanya "View tanyatanya's Profile")
- [ Offline](/forum/user/513-tanyatanya)

Less More

- Posts: 90
- Thank you received: 0
-
-

14 years 3 months ago [\#58291](#58291) by [tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile")  Replied by *[tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile")* on topic *[Re: Configure the Hikashop search plugin](/forum/4-how-to/53049-configure-the-hikashop-search-plugin#58291 "Hello!  I love Hikashop but have run into a little issue. I was testing the search feature and noticed that the returns that I get have amended urls. Meaning:   poprockvintage.com/index.php/component/h...rchid-blossoms-dress ? becomes   poprockvintage.com/index.php/component/h...oms-dress?Itemid=478  This would not be a big deal except that when you click the url, a whole listing of products shows before the actual item. I probably am missing something simple, but any help would be appreciated.")*

hi,

yes I think so. I have attached screen shots of both the module manager and plugin manager. I have also attached screen shot of the content menus screen - I have tried putting the ID of each of the content menus (25, 17, 7, and 2) into the item id box on the search plugin, but none of them work.
could it be anything else I'm doing wrong?

kind regards,
Tanya

- [ ![modulemanager.jpg](/forum/attachment/4891) ](/forum/attachment/4891 "modulemanager.jpg") [ ](/forum/attachment/4891?download=1 "modulemanager.jpg")
- [ ![pluginmanager.jpg](/forum/attachment/4892) ](/forum/attachment/4892 "pluginmanager.jpg") [ ](/forum/attachment/4892?download=1 "pluginmanager.jpg")
- [ ![displaycontentmenus.jpg](/forum/attachment/4893) ](/forum/attachment/4893 "...ntentmenus.jpg") [ ](/forum/attachment/4893?download=1 "...ntentmenus.jpg")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ5LWNvbmZpZ3VyZS10aGUtaGlrYXNob3Atc2VhcmNoLXBsdWdpbj9zdGFydD0wJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86556
- Thank you received: 14305
-
-

14 years 3 months ago [\#58340](#58340) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Configure the Hikashop search plugin](/forum/4-how-to/53049-configure-the-hikashop-search-plugin#58340 "Hello!  I love Hikashop but have run into a little issue. I was testing the search feature and noticed that the returns that I get have amended urls. Meaning:   poprockvintage.com/index.php/component/h...rchid-blossoms-dress ? becomes   poprockvintage.com/index.php/component/h...oms-dress?Itemid=478  This would not be a big deal except that when you click the url, a whole listing of products shows before the actual item. I probably am missing something simple, but any help would be appreciated.")*

Can you try to turn on the "debug mode" of the configuration of joomla and search again ?
If there is a problem with the plugin, it should then display a big error message.

Otherwise, it should work. In that case, please give a link to your products listing and search module on your website so that we can see that.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ5LWNvbmZpZ3VyZS10aGUtaGlrYXNob3Atc2VhcmNoLXBsdWdpbj9zdGFydD0wJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile")**
- [![tanyatanya's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/513-tanyatanya "View tanyatanya's Profile")
- [ Offline](/forum/user/513-tanyatanya)

Less More

- Posts: 90
- Thank you received: 0
-
-

14 years 3 months ago [\#58362](#58362) by [tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile")  Replied by *[tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile")* on topic *[Re: Configure the Hikashop search plugin](/forum/4-how-to/53049-configure-the-hikashop-search-plugin#58362 "Hello!  I love Hikashop but have run into a little issue. I was testing the search feature and noticed that the returns that I get have amended urls. Meaning:   poprockvintage.com/index.php/component/h...rchid-blossoms-dress ? becomes   poprockvintage.com/index.php/component/h...oms-dress?Itemid=478  This would not be a big deal except that when you click the url, a whole listing of products shows before the actual item. I probably am missing something simple, but any help would be appreciated.")*

hi - yep big error message:

500 - JDatabaseMySQL::query: 1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay SQL=SELECT DISTINCT a.product_id AS id, a.product_name, a.product_created AS created , a.product_description, "2" AS browsernav, a.product_type, a.product_parent_id, b.category_id as category_id FROM jos_hikashop_product AS a INNER JOIN jos_hikashop_product_category AS b ON a.product_parent_id=b.product_id OR a.product_id=b.product_id WHERE a.product_published=1 AND a.product_quantity!=0 AND ((((a.product_name LIKE '%pop%') AND (a.product_name LIKE '%rivets%'))) OR (((a.product_description LIKE '%pop%') AND (a.product_description LIKE '%rivets%'))) OR (((a.product_id LIKE '%pop%') AND (a.product_id LIKE '%rivets%'))) OR (((a.product_parent_id LIKE '%pop%') AND (a.product_parent_id LIKE '%rivets%')))) GROUP BY (a.product_id) ORDER BY a.product_name DESC LIMIT 0, 50

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ5LWNvbmZpZ3VyZS10aGUtaGlrYXNob3Atc2VhcmNoLXBsdWdpbj9zdGFydD0wJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86556
- Thank you received: 14305
-
-

14 years 3 months ago [\#58420](#58420) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Configure the Hikashop search plugin](/forum/4-how-to/53049-configure-the-hikashop-search-plugin#58420 "Hello!  I love Hikashop but have run into a little issue. I was testing the search feature and noticed that the returns that I get have amended urls. Meaning:   poprockvintage.com/index.php/component/h...rchid-blossoms-dress ? becomes   poprockvintage.com/index.php/component/h...oms-dress?Itemid=478  This would not be a big deal except that when you click the url, a whole listing of products shows before the actual item. I probably am missing something simple, but any help would be appreciated.")*

That error is thrown by MySQL because there is a too big number of results for the join in that query.
It means that you have too many products/categories for the restriction set in place on your server.

How many products/categories do you have ?

You can try to add the code :
$db-&gt;setQuery('SET SQL_BIG_SELECTS=1');
$db-&gt;query();

before the line:
$query = ' SELECT DISTINCT '.$select.' FROM '.hikashop_table('product') . ' AS a '.$leftjoin.' WHERE '.implode(' AND ',$filters).' GROUP BY (a.product_id) ORDER BY '.$order;

in the file plugins/search/hikashop_products/hikashop_products.php and that might help fix the problem.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ5LWNvbmZpZ3VyZS10aGUtaGlrYXNob3Atc2VhcmNoLXBsdWdpbj9zdGFydD0wJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile")**
- [![tanyatanya's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/513-tanyatanya "View tanyatanya's Profile")
- [ Offline](/forum/user/513-tanyatanya)

Less More

- Posts: 90
- Thank you received: 0
-
-

14 years 3 months ago [\#59126](#59126) by [tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile")  Replied by *[tanyatanya](/forum/user/513-tanyatanya "View tanyatanya's Profile")* on topic *[Re: Configure the Hikashop search plugin](/forum/4-how-to/53049-configure-the-hikashop-search-plugin#59126 "Hello!  I love Hikashop but have run into a little issue. I was testing the search feature and noticed that the returns that I get have amended urls. Meaning:   poprockvintage.com/index.php/component/h...rchid-blossoms-dress ? becomes   poprockvintage.com/index.php/component/h...oms-dress?Itemid=478  This would not be a big deal except that when you click the url, a whole listing of products shows before the actual item. I probably am missing something simple, but any help would be appreciated.")*

hi,

149 categories (including subcategories) and 600 products.
changing the code has fixed it though.

thanks,
Tanya

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ5LWNvbmZpZ3VyZS10aGUtaGlrYXNob3Atc2VhcmNoLXBsdWdpbj9zdGFydD0wJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[janvankuijk](/forum/user/6080-janvankuijk "View janvankuijk's Profile")**
- [![janvankuijk's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6080-janvankuijk "View janvankuijk's Profile")
- [ Offline](/forum/user/6080-janvankuijk)

Less More

- Posts: 235
- Thank you received: 4
-
-

14 years 4 weeks ago [\#70214](#70214) by [janvankuijk](/forum/user/6080-janvankuijk "View janvankuijk's Profile")  Replied by *[janvankuijk](/forum/user/6080-janvankuijk "View janvankuijk's Profile")* on topic *[Re: Configure the Hikashop search plugin](/forum/4-how-to/53049-configure-the-hikashop-search-plugin#70214 "Hello!  I love Hikashop but have run into a little issue. I was testing the search feature and noticed that the returns that I get have amended urls. Meaning:   poprockvintage.com/index.php/component/h...rchid-blossoms-dress ? becomes   poprockvintage.com/index.php/component/h...oms-dress?Itemid=478  This would not be a big deal except that when you click the url, a whole listing of products shows before the actual item. I probably am missing something simple, but any help would be appreciated.")*

Same problem over here.

There are only a few products in the database, so that can't be the problem.

The debug mode gave this error:

500 - JDatabaseMySQLi::query: 1146 - Table 'jan_toys.s3gof_plugins' doesn't exist SQL=SELECT &#96;published&#96; FROM &#96;s3gof_plugins&#96; WHERE &#96;element&#96; = 'jfrouter' AND &#96;folder&#96; = 'system'

Plugins are published. The configuration of the search is exactly the same as on the demo-site.

Jan

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ5LWNvbmZpZ3VyZS10aGUtaGlrYXNob3Atc2VhcmNoLXBsdWdpbj9zdGFydD0wJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86556
- Thank you received: 14305
-
-

14 years 4 weeks ago [\#70325](#70325) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Configure the Hikashop search plugin](/forum/4-how-to/53049-configure-the-hikashop-search-plugin#70325 "Hello!  I love Hikashop but have run into a little issue. I was testing the search feature and noticed that the returns that I get have amended urls. Meaning:   poprockvintage.com/index.php/component/h...rchid-blossoms-dress ? becomes   poprockvintage.com/index.php/component/h...oms-dress?Itemid=478  This would not be a big deal except that when you click the url, a whole listing of products shows before the actual item. I probably am missing something simple, but any help would be appreciated.")*

It's not the same problem at all.
Your error says that the table plugins of joomla does not exists in the database.
That's not even an error of HikaShop.
That query is trying to look for the joomfish router plugin information in the database.
It sounds like you have the joomfish router plugin published even though you're on joomla 2.5 where the table plugins has been removed and on which joomfish doesn't work.
You should unpublish that joomfish plugin and that will remove that error.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ5LWNvbmZpZ3VyZS10aGUtaGlrYXNob3Atc2VhcmNoLXBsdWdpbj9zdGFydD0wJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[janvankuijk](/forum/user/6080-janvankuijk "View janvankuijk's Profile")**
- [![janvankuijk's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6080-janvankuijk "View janvankuijk's Profile")
- [ Offline](/forum/user/6080-janvankuijk)

Less More

- Posts: 235
- Thank you received: 4
-
-

14 years 4 weeks ago [\#70368](#70368) by [janvankuijk](/forum/user/6080-janvankuijk "View janvankuijk's Profile")  Replied by *[janvankuijk](/forum/user/6080-janvankuijk "View janvankuijk's Profile")* on topic *[Re: Configure the Hikashop search plugin](/forum/4-how-to/53049-configure-the-hikashop-search-plugin#70368 "Hello!  I love Hikashop but have run into a little issue. I was testing the search feature and noticed that the returns that I get have amended urls. Meaning:   poprockvintage.com/index.php/component/h...rchid-blossoms-dress ? becomes   poprockvintage.com/index.php/component/h...oms-dress?Itemid=478  This would not be a big deal except that when you click the url, a whole listing of products shows before the actual item. I probably am missing something simple, but any help would be appreciated.")*

Hi Nicolas,

I figured it out and googled on this problem. The issue was RS-SEO from RS joomla which causes the error.

But now still no results on the search.
Can you help us?

[ www.toyscompany.testjouwsite.nl/](http://www.toyscompany.testjouwsite.nl/)

Jan

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ5LWNvbmZpZ3VyZS10aGUtaGlrYXNob3Atc2VhcmNoLXBsdWdpbj9zdGFydD0wJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86556
- Thank you received: 14305
-
-

14 years 4 weeks ago [\#70375](#70375) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Configure the Hikashop search plugin](/forum/4-how-to/53049-configure-the-hikashop-search-plugin#70375 "Hello!  I love Hikashop but have run into a little issue. I was testing the search feature and noticed that the returns that I get have amended urls. Meaning:   poprockvintage.com/index.php/component/h...rchid-blossoms-dress ? becomes   poprockvintage.com/index.php/component/h...oms-dress?Itemid=478  This would not be a big deal except that when you click the url, a whole listing of products shows before the actual item. I probably am missing something simple, but any help would be appreciated.")*

Can you try to turn on the "debug mode" of the configuration of joomla and search again ?
If there is a problem with the plugin, it should then display a big error message.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ5LWNvbmZpZ3VyZS10aGUtaGlrYXNob3Atc2VhcmNoLXBsdWdpbj9zdGFydD0wJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[janvankuijk](/forum/user/6080-janvankuijk "View janvankuijk's Profile")**
- [![janvankuijk's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6080-janvankuijk "View janvankuijk's Profile")
- [ Offline](/forum/user/6080-janvankuijk)

Less More

- Posts: 235
- Thank you received: 4
-
-

14 years 4 weeks ago [\#70389](#70389) by [janvankuijk](/forum/user/6080-janvankuijk "View janvankuijk's Profile")  Replied by *[janvankuijk](/forum/user/6080-janvankuijk "View janvankuijk's Profile")* on topic *[Re: Configure the Hikashop search plugin](/forum/4-how-to/53049-configure-the-hikashop-search-plugin#70389 "Hello!  I love Hikashop but have run into a little issue. I was testing the search feature and noticed that the returns that I get have amended urls. Meaning:   poprockvintage.com/index.php/component/h...rchid-blossoms-dress ? becomes   poprockvintage.com/index.php/component/h...oms-dress?Itemid=478  This would not be a big deal except that when you click the url, a whole listing of products shows before the actual item. I probably am missing something simple, but any help would be appreciated.")*

There is not a 'big error', but 'only' this:

Notice: Undefined variable: font_libs in /home/jan/domains/testjouwsite.nl/public_html/toyscompany/templates/ict_xemiba/libs/ict_header_include.php on line 42

Notice: Undefined variable: font_libs in /home/jan/domains/testjouwsite.nl/public_html/toyscompany/templates/ict_xemiba/libs/ict_header_include.php on line 50

Notice: Undefined variable: config in /home/jan/domains/testjouwsite.nl/public_html/toyscompany/templates/ict_xemiba/index.php on line 92

Notice: Trying to get property of non-object in /home/jan/domains/testjouwsite.nl/public_html/toyscompany/templates/ict_xemiba/index.php on line 92

Jan

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ5LWNvbmZpZ3VyZS10aGUtaGlrYXNob3Atc2VhcmNoLXBsdWdpbj9zdGFydD0wJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86556
- Thank you received: 14305
-
-

14 years 4 weeks ago [\#70609](#70609) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Configure the Hikashop search plugin](/forum/4-how-to/53049-configure-the-hikashop-search-plugin#70609 "Hello!  I love Hikashop but have run into a little issue. I was testing the search feature and noticed that the returns that I get have amended urls. Meaning:   poprockvintage.com/index.php/component/h...rchid-blossoms-dress ? becomes   poprockvintage.com/index.php/component/h...oms-dress?Itemid=478  This would not be a big deal except that when you click the url, a whole listing of products shows before the actual item. I probably am missing something simple, but any help would be appreciated.")*

Could you copy/paste the queries that you have at the bottom of the result page when the debug mode is activated and also do a screenshot of the options page of the hikashop products plugin ?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ5LWNvbmZpZ3VyZS10aGUtaGlrYXNob3Atc2VhcmNoLXBsdWdpbj9zdGFydD0wJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[janvankuijk](/forum/user/6080-janvankuijk "View janvankuijk's Profile")**
- [![janvankuijk's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6080-janvankuijk "View janvankuijk's Profile")
- [ Offline](/forum/user/6080-janvankuijk)

Less More

- Posts: 235
- Thank you received: 4
-
-

14 years 4 weeks ago [\#70642](#70642) by [janvankuijk](/forum/user/6080-janvankuijk "View janvankuijk's Profile")  Replied by *[janvankuijk](/forum/user/6080-janvankuijk "View janvankuijk's Profile")* on topic *[Re: Configure the Hikashop search plugin](/forum/4-how-to/53049-configure-the-hikashop-search-plugin#70642 "Hello!  I love Hikashop but have run into a little issue. I was testing the search feature and noticed that the returns that I get have amended urls. Meaning:   poprockvintage.com/index.php/component/h...rchid-blossoms-dress ? becomes   poprockvintage.com/index.php/component/h...oms-dress?Itemid=478  This would not be a big deal except that when you click the url, a whole listing of products shows before the actual item. I probably am missing something simple, but any help would be appreciated.")*

Hi Nicolas,

Attached 3 files with the screenshot and the queries.&#96;

Kind regards
Jan

- [ ![Plugin.png](/forum/attachment/6346) ](/forum/attachment/6346 "Plugin.png") [ ](/forum/attachment/6346?download=1 "Plugin.png")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ5LWNvbmZpZ3VyZS10aGUtaGlrYXNob3Atc2VhcmNoLXBsdWdpbj9zdGFydD0wJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86556
- Thank you received: 14305
-
-

14 years 4 weeks ago [\#70692](#70692) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Configure the Hikashop search plugin](/forum/4-how-to/53049-configure-the-hikashop-search-plugin#70692 "Hello!  I love Hikashop but have run into a little issue. I was testing the search feature and noticed that the returns that I get have amended urls. Meaning:   poprockvintage.com/index.php/component/h...rchid-blossoms-dress ? becomes   poprockvintage.com/index.php/component/h...oms-dress?Itemid=478  This would not be a big deal except that when you click the url, a whole listing of products shows before the actual item. I probably am missing something simple, but any help would be appreciated.")*

Hi,

So the query which is run by the plugin is this one:
SELECT DISTINCT b.*
FROM s3gof_hikashop_product_category AS a
LEFT JOIN s3gof_hikashop_product AS b
ON a.product_id=b.product_id
WHERE b.product_published=1
AND b.product_type = 'main'
AND a.category_id IN (2)
AND (b.product_access = 'all' OR b.product_access LIKE '%,1,%')
AND ( b.product_description LIKE '%duplo%' )
ORDER BY a.ordering ASC
LIMIT 0, 20

As you can see, it only searches in the product_description field, not the product_name field.
You might have a second hikashop product search plugin which is configured to search only the description in your plugins manager. Otherwise, try to change the selection of the search fields in the options of the search plugin. There must be something related to it.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ5LWNvbmZpZ3VyZS10aGUtaGlrYXNob3Atc2VhcmNoLXBsdWdpbj9zdGFydD0wJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[janvankuijk](/forum/user/6080-janvankuijk "View janvankuijk's Profile")**
- [![janvankuijk's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6080-janvankuijk "View janvankuijk's Profile")
- [ Offline](/forum/user/6080-janvankuijk)

Less More

- Posts: 235
- Thank you received: 4
-
-

14 years 4 weeks ago [\#70697](#70697) by [janvankuijk](/forum/user/6080-janvankuijk "View janvankuijk's Profile")  Replied by *[janvankuijk](/forum/user/6080-janvankuijk "View janvankuijk's Profile")* on topic *[Re: Configure the Hikashop search plugin](/forum/4-how-to/53049-configure-the-hikashop-search-plugin#70697 "Hello!  I love Hikashop but have run into a little issue. I was testing the search feature and noticed that the returns that I get have amended urls. Meaning:   poprockvintage.com/index.php/component/h...rchid-blossoms-dress ? becomes   poprockvintage.com/index.php/component/h...oms-dress?Itemid=478  This would not be a big deal except that when you click the url, a whole listing of products shows before the actual item. I probably am missing something simple, but any help would be appreciated.")*

I tried a lot of things, but it's not possible te make it happen.
For sure I'm doing something wrong, but can't figure out what. ![:-(](/media/kunena/emoticons/22.png ":-(").

Is it possible for you to login on the backend and have a look. If this is one is working, I know for the future how to do.

Jan

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ5LWNvbmZpZ3VyZS10aGUtaGlrYXNob3Atc2VhcmNoLXBsdWdpbj9zdGFydD0wJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.121 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
