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

#   URL's crashed after Business upgrade and Filter

##

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

Less More

- Posts: 90
- Thank you received: 2
-
-

13 years 7 months ago [\#98082](#98082) by [lex131](/forum/user/12191-lex131 "View lex131's Profile")  *[URL's crashed after Business upgrade and Filter](/forum/2-general-talk-about-hikashop/80124-urls-crashed-after-business-upgrade-and-filter#98082 "Hello,  After upgrade to business edition, I enabled the Filter Module.  My sidebar menu links all point to subcategories inside the main category Product Category. I had no link to all the products.  But the filter module required one, so i created another menu that points to Product Category and entered it's ID inside the Filter Module.  Everything looks ok when you search, but now you cannot go to the page of any product. When you click on product, the URL it tries to open is: tablouri-postere-oneart/1200155-tablou-canvas-poster-flori-flo00155  But the actual URL of the product is: 1200155-tablou-canvas-poster-flori-flo00155  The first part &quot;tablouri-postere-oneart&quot; is the alias of the meniu ID i entered in the filter module.  Also, if I don't use the Search Filter if I just go to a category and click on a product it gives an error: Error: 1054 - Unknown column 'a.category&#95;id' in 'field list' SQL=SELECT DISTINCT b.product&#95;id,a.category&#95;id FROM j8m5d&#95;hikashop&#95;product&#95;related AS a LEFT JOIN j8m5d&#95;hikashop&#95;product AS b ON a.product&#95;related&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND a.product&#95;related&#95;type='related' AND a.product&#95;id=100001 AND b.product&#95;type = 'main' AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,1,%') ORDER BY a.product&#95;related&#95;ordering ASC  So now I can't access any page of any product.  Problem 2: I've got two filters, one is the category and one is a keyword search text. If i'm on the homepage and search for something it show me results from all categories. If i'm inside a category and search for something it will only show the results from that current category , even if the category filter says &quot;all&quot;.  Problem 3: I can't see any type of search options. I've checked and saw that it searches keywords using &quot;any word&quot; and not &quot;all words&quot;. I need &quot;all words&quot; - where and how do I change this?  Please help soon!  I'm sending by private message to Nicolas all the login details.  Thank you in advance.  p.s. i'll mention the title of this topic in the private message")* was created by *[lex131](/forum/user/12191-lex131 "View lex131's Profile")*

Hello,

After upgrade to business edition, I enabled the Filter Module.

My sidebar menu links all point to subcategories inside the main category Product Category.
I had no link to all the products.

But the filter module required one, so i created another menu that points to Product Category and entered it's ID inside the Filter Module.

Everything looks ok when you search, but now you cannot go to the page of any product. When you click on product, the URL it tries to open is:
tablouri-postere-oneart/1200155-tablou-canvas-poster-flori-flo00155

But the actual URL of the product is: 1200155-tablou-canvas-poster-flori-flo00155

The first part "tablouri-postere-oneart" is the alias of the meniu ID i entered in the filter module.

Also, if I don't use the Search Filter if I just go to a category and click on a product it gives an error:
Error: 1054 - Unknown column 'a.category_id' in 'field list' SQL=SELECT DISTINCT b.product_id,a.category_id FROM j8m5d_hikashop_product_related AS a LEFT JOIN j8m5d_hikashop_product AS b ON a.product_related_id=b.product_id WHERE b.product_published=1 AND a.product_related_type='related' AND a.product_id=100001 AND b.product_type = 'main' AND b.product_quantity!=0 AND (b.product_access = 'all' OR b.product_access LIKE '%,1,%') ORDER BY a.product_related_ordering ASC

So now I can't access any page of any product.

Problem 2:
I've got two filters, one is the category and one is a keyword search text.
If i'm on the homepage and search for something it show me results from all categories.
If i'm inside a category and search for something it will only show the results from that current category , even if the category filter says "all".

Problem 3:
I can't see any type of search options. I've checked and saw that it searches keywords using "any word" and not "all words". I need "all words" - where and how do I change this?

Please help soon!

I'm sending by private message to Nicolas all the login details.

Thank you in advance.

p.s. i'll mention the title of this topic in the private message

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

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

Less More

- Posts: 90
- Thank you received: 2
-
-

13 years 7 months ago [\#98177](#98177) by [lex131](/forum/user/12191-lex131 "View lex131's Profile")  Replied by *[lex131](/forum/user/12191-lex131 "View lex131's Profile")* on topic *[URL's crashed after Business upgrade and Filter](/forum/2-general-talk-about-hikashop/80124-urls-crashed-after-business-upgrade-and-filter#98177 "Hello,  After upgrade to business edition, I enabled the Filter Module.  My sidebar menu links all point to subcategories inside the main category Product Category. I had no link to all the products.  But the filter module required one, so i created another menu that points to Product Category and entered it's ID inside the Filter Module.  Everything looks ok when you search, but now you cannot go to the page of any product. When you click on product, the URL it tries to open is: tablouri-postere-oneart/1200155-tablou-canvas-poster-flori-flo00155  But the actual URL of the product is: 1200155-tablou-canvas-poster-flori-flo00155  The first part &quot;tablouri-postere-oneart&quot; is the alias of the meniu ID i entered in the filter module.  Also, if I don't use the Search Filter if I just go to a category and click on a product it gives an error: Error: 1054 - Unknown column 'a.category&#95;id' in 'field list' SQL=SELECT DISTINCT b.product&#95;id,a.category&#95;id FROM j8m5d&#95;hikashop&#95;product&#95;related AS a LEFT JOIN j8m5d&#95;hikashop&#95;product AS b ON a.product&#95;related&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND a.product&#95;related&#95;type='related' AND a.product&#95;id=100001 AND b.product&#95;type = 'main' AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,1,%') ORDER BY a.product&#95;related&#95;ordering ASC  So now I can't access any page of any product.  Problem 2: I've got two filters, one is the category and one is a keyword search text. If i'm on the homepage and search for something it show me results from all categories. If i'm inside a category and search for something it will only show the results from that current category , even if the category filter says &quot;all&quot;.  Problem 3: I can't see any type of search options. I've checked and saw that it searches keywords using &quot;any word&quot; and not &quot;all words&quot;. I need &quot;all words&quot; - where and how do I change this?  Please help soon!  I'm sending by private message to Nicolas all the login details.  Thank you in advance.  p.s. i'll mention the title of this topic in the private message")*

Guys, I need your help!!!! Please assist me in solving these issues.
I just upgraded to the business edition and my site is broken - please help!

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwMTI0LXVybHMtY3Jhc2hlZC1hZnRlci1idXNpbmVzcy11cGdyYWRlLWFuZC1maWx0ZXI/dG1wbD1tYXJrZG93bg==) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86560
- Thank you received: 14307
-
-

13 years 7 months ago [\#98185](#98185) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[URL's crashed after Business upgrade and Filter](/forum/2-general-talk-about-hikashop/80124-urls-crashed-after-business-upgrade-and-filter#98185 "Hello,  After upgrade to business edition, I enabled the Filter Module.  My sidebar menu links all point to subcategories inside the main category Product Category. I had no link to all the products.  But the filter module required one, so i created another menu that points to Product Category and entered it's ID inside the Filter Module.  Everything looks ok when you search, but now you cannot go to the page of any product. When you click on product, the URL it tries to open is: tablouri-postere-oneart/1200155-tablou-canvas-poster-flori-flo00155  But the actual URL of the product is: 1200155-tablou-canvas-poster-flori-flo00155  The first part &quot;tablouri-postere-oneart&quot; is the alias of the meniu ID i entered in the filter module.  Also, if I don't use the Search Filter if I just go to a category and click on a product it gives an error: Error: 1054 - Unknown column 'a.category&#95;id' in 'field list' SQL=SELECT DISTINCT b.product&#95;id,a.category&#95;id FROM j8m5d&#95;hikashop&#95;product&#95;related AS a LEFT JOIN j8m5d&#95;hikashop&#95;product AS b ON a.product&#95;related&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND a.product&#95;related&#95;type='related' AND a.product&#95;id=100001 AND b.product&#95;type = 'main' AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,1,%') ORDER BY a.product&#95;related&#95;ordering ASC  So now I can't access any page of any product.  Problem 2: I've got two filters, one is the category and one is a keyword search text. If i'm on the homepage and search for something it show me results from all categories. If i'm inside a category and search for something it will only show the results from that current category , even if the category filter says &quot;all&quot;.  Problem 3: I can't see any type of search options. I've checked and saw that it searches keywords using &quot;any word&quot; and not &quot;all words&quot;. I need &quot;all words&quot; - where and how do I change this?  Please help soon!  I'm sending by private message to Nicolas all the login details.  Thank you in advance.  p.s. i'll mention the title of this topic in the private message")*

Hi,

1. That comes from a mix between the related products module and the filters.
Change the line:
if(hikashop_level(2) &amp;&amp; JRequest::getVar('hikashop_front_end_main',0)){

to:
if(hikashop_level(2) &amp;&amp; JRequest::getVar('hikashop_front_end_main',0) &amp;&amp; JRequest::getVar('task','listing')!='show'){

in the file components/com_hikashop/views/product/view.html.php and that should avoid the problem.

2. In the options of your filter module, you need to force the redirect.

3. There is no option to change that.

You will have to change the code: Code:

foreach($terms as $term){ foreach($searchField as $column){ $list[]=' b.'.$column.' LIKE \'%'.hikashop_getEscaped($term, true).'%\' '; } } $filters[]='('.implode(' OR ', $list).')';

to: Code:

foreach($terms as $term){ $array =array(); foreach($searchField as $column){ $array[]=' b.'.$column.' LIKE \'%'.hikashop_getEscaped($term, true).'%\' '; } $list[]='('.implode(' OR ', $array).')'; } $filters[]='('.implode(' AND ', $list).')';

in the file administrator/components/com_hikashop/classes/filter.php

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

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

Less More

- Posts: 90
- Thank you received: 2
-
-

13 years 7 months ago [\#98188](#98188) by [lex131](/forum/user/12191-lex131 "View lex131's Profile")  Replied by *[lex131](/forum/user/12191-lex131 "View lex131's Profile")* on topic *[URL's crashed after Business upgrade and Filter](/forum/2-general-talk-about-hikashop/80124-urls-crashed-after-business-upgrade-and-filter#98188 "Hello,  After upgrade to business edition, I enabled the Filter Module.  My sidebar menu links all point to subcategories inside the main category Product Category. I had no link to all the products.  But the filter module required one, so i created another menu that points to Product Category and entered it's ID inside the Filter Module.  Everything looks ok when you search, but now you cannot go to the page of any product. When you click on product, the URL it tries to open is: tablouri-postere-oneart/1200155-tablou-canvas-poster-flori-flo00155  But the actual URL of the product is: 1200155-tablou-canvas-poster-flori-flo00155  The first part &quot;tablouri-postere-oneart&quot; is the alias of the meniu ID i entered in the filter module.  Also, if I don't use the Search Filter if I just go to a category and click on a product it gives an error: Error: 1054 - Unknown column 'a.category&#95;id' in 'field list' SQL=SELECT DISTINCT b.product&#95;id,a.category&#95;id FROM j8m5d&#95;hikashop&#95;product&#95;related AS a LEFT JOIN j8m5d&#95;hikashop&#95;product AS b ON a.product&#95;related&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND a.product&#95;related&#95;type='related' AND a.product&#95;id=100001 AND b.product&#95;type = 'main' AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,1,%') ORDER BY a.product&#95;related&#95;ordering ASC  So now I can't access any page of any product.  Problem 2: I've got two filters, one is the category and one is a keyword search text. If i'm on the homepage and search for something it show me results from all categories. If i'm inside a category and search for something it will only show the results from that current category , even if the category filter says &quot;all&quot;.  Problem 3: I can't see any type of search options. I've checked and saw that it searches keywords using &quot;any word&quot; and not &quot;all words&quot;. I need &quot;all words&quot; - where and how do I change this?  Please help soon!  I'm sending by private message to Nicolas all the login details.  Thank you in advance.  p.s. i'll mention the title of this topic in the private message")*

I made all the changes you specified.

The errors are still there.

Of all the things you said only the change for the search type worked (instead of OR uses AND and it works).

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwMTI0LXVybHMtY3Jhc2hlZC1hZnRlci1idXNpbmVzcy11cGdyYWRlLWFuZC1maWx0ZXI/dG1wbD1tYXJrZG93bg==) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86560
- Thank you received: 14307
-
-

13 years 7 months ago [\#98343](#98343) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[URL's crashed after Business upgrade and Filter](/forum/2-general-talk-about-hikashop/80124-urls-crashed-after-business-upgrade-and-filter#98343 "Hello,  After upgrade to business edition, I enabled the Filter Module.  My sidebar menu links all point to subcategories inside the main category Product Category. I had no link to all the products.  But the filter module required one, so i created another menu that points to Product Category and entered it's ID inside the Filter Module.  Everything looks ok when you search, but now you cannot go to the page of any product. When you click on product, the URL it tries to open is: tablouri-postere-oneart/1200155-tablou-canvas-poster-flori-flo00155  But the actual URL of the product is: 1200155-tablou-canvas-poster-flori-flo00155  The first part &quot;tablouri-postere-oneart&quot; is the alias of the meniu ID i entered in the filter module.  Also, if I don't use the Search Filter if I just go to a category and click on a product it gives an error: Error: 1054 - Unknown column 'a.category&#95;id' in 'field list' SQL=SELECT DISTINCT b.product&#95;id,a.category&#95;id FROM j8m5d&#95;hikashop&#95;product&#95;related AS a LEFT JOIN j8m5d&#95;hikashop&#95;product AS b ON a.product&#95;related&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND a.product&#95;related&#95;type='related' AND a.product&#95;id=100001 AND b.product&#95;type = 'main' AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,1,%') ORDER BY a.product&#95;related&#95;ordering ASC  So now I can't access any page of any product.  Problem 2: I've got two filters, one is the category and one is a keyword search text. If i'm on the homepage and search for something it show me results from all categories. If i'm inside a category and search for something it will only show the results from that current category , even if the category filter says &quot;all&quot;.  Problem 3: I can't see any type of search options. I've checked and saw that it searches keywords using &quot;any word&quot; and not &quot;all words&quot;. I need &quot;all words&quot; - where and how do I change this?  Please help soon!  I'm sending by private message to Nicolas all the login details.  Thank you in advance.  p.s. i'll mention the title of this topic in the private message")*

Hi,

1. Ok, the error was on something else. I was able to debug it with the access your provided.

2. It's working fine as far as I can see.
For example, I'm on the "animale" category: [ www.nfx.ro/lumiere/animale](http://www.nfx.ro/lumiere/animale)
I enter "hatsune" in the filtering field and I see all the products with hatsune miku from the "anime" category.

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

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

Less More

- Posts: 90
- Thank you received: 2
-
-

13 years 7 months ago [\#98344](#98344) by [lex131](/forum/user/12191-lex131 "View lex131's Profile")  Replied by *[lex131](/forum/user/12191-lex131 "View lex131's Profile")* on topic *[URL's crashed after Business upgrade and Filter](/forum/2-general-talk-about-hikashop/80124-urls-crashed-after-business-upgrade-and-filter#98344 "Hello,  After upgrade to business edition, I enabled the Filter Module.  My sidebar menu links all point to subcategories inside the main category Product Category. I had no link to all the products.  But the filter module required one, so i created another menu that points to Product Category and entered it's ID inside the Filter Module.  Everything looks ok when you search, but now you cannot go to the page of any product. When you click on product, the URL it tries to open is: tablouri-postere-oneart/1200155-tablou-canvas-poster-flori-flo00155  But the actual URL of the product is: 1200155-tablou-canvas-poster-flori-flo00155  The first part &quot;tablouri-postere-oneart&quot; is the alias of the meniu ID i entered in the filter module.  Also, if I don't use the Search Filter if I just go to a category and click on a product it gives an error: Error: 1054 - Unknown column 'a.category&#95;id' in 'field list' SQL=SELECT DISTINCT b.product&#95;id,a.category&#95;id FROM j8m5d&#95;hikashop&#95;product&#95;related AS a LEFT JOIN j8m5d&#95;hikashop&#95;product AS b ON a.product&#95;related&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND a.product&#95;related&#95;type='related' AND a.product&#95;id=100001 AND b.product&#95;type = 'main' AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,1,%') ORDER BY a.product&#95;related&#95;ordering ASC  So now I can't access any page of any product.  Problem 2: I've got two filters, one is the category and one is a keyword search text. If i'm on the homepage and search for something it show me results from all categories. If i'm inside a category and search for something it will only show the results from that current category , even if the category filter says &quot;all&quot;.  Problem 3: I can't see any type of search options. I've checked and saw that it searches keywords using &quot;any word&quot; and not &quot;all words&quot;. I need &quot;all words&quot; - where and how do I change this?  Please help soon!  I'm sending by private message to Nicolas all the login details.  Thank you in advance.  p.s. i'll mention the title of this topic in the private message")*

Thank you for the fix.

Please tell me, what can I do about the urls.

If you go directly to the category Anime and the first image the url will be:
[ www.nfx.ro/lumiere/anime/300001-tablou-c...oster-anime-ani00001](http://www.nfx.ro/lumiere/anime/300001-tablou-canvas-poster-anime-ani00001)

But if you search for "butterfly anime" (the same product will be the 1'st result) and click on the product the url will be:
[ www.nfx.ro/lumiere/tablouri-postere-onea...oster-anime-ani00001](http://www.nfx.ro/lumiere/tablouri-postere-oneart/300001-tablou-canvas-poster-anime-ani00001)

It adds the alias of the Menu ID i entered in the Filter Module.

This is bad - I will have 2 different URLS for all my products - this is bad.

And the second problem, as you can see, in my side menu i have "Tablouri Postere OneArt" which is the menu i had to create for the Filter Module ID.

I don't want this menu.

I want to be able to filter, the URL's to reimain unchainged, the page layout to be the same as it is for each category and no extra menus that people shouldn't click (because it will load 150.000 products).

Please help!!

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwMTI0LXVybHMtY3Jhc2hlZC1hZnRlci1idXNpbmVzcy11cGdyYWRlLWFuZC1maWx0ZXI/dG1wbD1tYXJrZG93bg==) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86560
- Thank you received: 14307
-
-

13 years 7 months ago [\#98377](#98377) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[URL's crashed after Business upgrade and Filter](/forum/2-general-talk-about-hikashop/80124-urls-crashed-after-business-upgrade-and-filter#98377 "Hello,  After upgrade to business edition, I enabled the Filter Module.  My sidebar menu links all point to subcategories inside the main category Product Category. I had no link to all the products.  But the filter module required one, so i created another menu that points to Product Category and entered it's ID inside the Filter Module.  Everything looks ok when you search, but now you cannot go to the page of any product. When you click on product, the URL it tries to open is: tablouri-postere-oneart/1200155-tablou-canvas-poster-flori-flo00155  But the actual URL of the product is: 1200155-tablou-canvas-poster-flori-flo00155  The first part &quot;tablouri-postere-oneart&quot; is the alias of the meniu ID i entered in the filter module.  Also, if I don't use the Search Filter if I just go to a category and click on a product it gives an error: Error: 1054 - Unknown column 'a.category&#95;id' in 'field list' SQL=SELECT DISTINCT b.product&#95;id,a.category&#95;id FROM j8m5d&#95;hikashop&#95;product&#95;related AS a LEFT JOIN j8m5d&#95;hikashop&#95;product AS b ON a.product&#95;related&#95;id=b.product&#95;id WHERE b.product&#95;published=1 AND a.product&#95;related&#95;type='related' AND a.product&#95;id=100001 AND b.product&#95;type = 'main' AND b.product&#95;quantity!=0 AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,1,%') ORDER BY a.product&#95;related&#95;ordering ASC  So now I can't access any page of any product.  Problem 2: I've got two filters, one is the category and one is a keyword search text. If i'm on the homepage and search for something it show me results from all categories. If i'm inside a category and search for something it will only show the results from that current category , even if the category filter says &quot;all&quot;.  Problem 3: I can't see any type of search options. I've checked and saw that it searches keywords using &quot;any word&quot; and not &quot;all words&quot;. I need &quot;all words&quot; - where and how do I change this?  Please help soon!  I'm sending by private message to Nicolas all the login details.  Thank you in advance.  p.s. i'll mention the title of this topic in the private message")*

Why would it be bad to have another URL since that other URL will only be accessible via the search results and that the search engines won't be able to do any search and thus won't see it ? It won't impact page rank since the search engines won't know about the other URL.

If you really want to have the same URL, you would have to have the extra menu of the filter module as the parent menu of the other menus and the system will automatically use the URL of the sub menus based on the category of the product and the category of each menu so that you don't get doublons between the search results and the sub menus but again, I don't see the point in your case.

Regarding the extra menu that you created, you can simply edit it and set its parent to be the HikaShop hidden menu or any other main menu which isn't displayed on your frontend instead of your main menu.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwMTI0LXVybHMtY3Jhc2hlZC1hZnRlci1idXNpbmVzcy11cGdyYWRlLWFuZC1maWx0ZXI/dG1wbD1tYXJrZG93bg==) 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.079 seconds

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