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

#   1064 error when filter is switched on

##

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

Less More

- Posts: 377
- Thank you received: 7
-
-

13 years 1 month ago [\#127344](#127344) by [Dibben](/forum/user/6788-dibben "View Dibben's Profile")  *[1064 error when filter is switched on](/forum/45-filters-search/862716-1064-error-when-filter-is-switched-on#127344 "-- url of the page with the problem -- :   tradeheatingspares.com/new2/Alpha-Boiler...ts/boiler-parts.html  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.15  Hi, for some reason when i have my filter module published, on those pages i get a 404 error (attached). What i have done is create a new field type for product with checkbox as the select type and have added two values. I then created a module and selected my filter i wanted to display and published this on the front end however if i now navigate to any page it is supposed to be published on i get a 1064 error when trying to load it. I have tried adjusting a few bits to see if i can get it to show at all and it doesn't seem to want to show it.  I also have sh404 sef setup however if i turn this off that doesn't fix the error.  Any ideas would be great thanks as this is the first time i have tried working with custom field filters.  Thanks")* was created by *[Dibben](/forum/user/6788-dibben "View Dibben's Profile")*

-- url of the page with the problem -- : [ tradeheatingspares.com/new2/Alpha-Boiler...ts/boiler-parts.html](http://tradeheatingspares.com/new2/Alpha-Boiler-Parts/boiler-parts.html)
-- HikaShop version -- : 2.2.2
-- Joomla version -- : 3.15

Hi, for some reason when i have my filter module published, on those pages i get a 404 error (attached). What i have done is create a new field type for product with checkbox as the select type and have added two values. I then created a module and selected my filter i wanted to display and published this on the front end however if i now navigate to any page it is supposed to be published on i get a 1064 error when trying to load it. I have tried adjusting a few bits to see if i can get it to show at all and it doesn't seem to want to show it.

I also have sh404 sef setup however if i turn this off that doesn't fix the error.

Any ideas would be great thanks as this is the first time i have tried working with custom field filters.

Thanks

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

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

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

Less More

- Posts: 377
- Thank you received: 7
-
-

13 years 1 month ago [\#127345](#127345) by [Dibben](/forum/user/6788-dibben "View Dibben's Profile")  Replied by *[Dibben](/forum/user/6788-dibben "View Dibben's Profile")* on topic *[1064 error when filter is switched on](/forum/45-filters-search/862716-1064-error-when-filter-is-switched-on#127345 "-- url of the page with the problem -- :   tradeheatingspares.com/new2/Alpha-Boiler...ts/boiler-parts.html  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.15  Hi, for some reason when i have my filter module published, on those pages i get a 404 error (attached). What i have done is create a new field type for product with checkbox as the select type and have added two values. I then created a module and selected my filter i wanted to display and published this on the front end however if i now navigate to any page it is supposed to be published on i get a 1064 error when trying to load it. I have tried adjusting a few bits to see if i can get it to show at all and it doesn't seem to want to show it.  I also have sh404 sef setup however if i turn this off that doesn't fix the error.  Any ideas would be great thanks as this is the first time i have tried working with custom field filters.  Thanks")*

For your information i haven't left it published as this doesn't allow me to work on any other area of the site however if it needs to be turned on to figure out what is causing this then let me know and i will turn it on and leave it for you guys to evaluate.

Thanks.

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

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26401
- Thank you received: 4081
-
- [](http://obsi.dev)
-

13 years 1 month ago [\#127394](#127394) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[1064 error when filter is switched on](/forum/45-filters-search/862716-1064-error-when-filter-is-switched-on#127394 "-- url of the page with the problem -- :   tradeheatingspares.com/new2/Alpha-Boiler...ts/boiler-parts.html  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.15  Hi, for some reason when i have my filter module published, on those pages i get a 404 error (attached). What i have done is create a new field type for product with checkbox as the select type and have added two values. I then created a module and selected my filter i wanted to display and published this on the front end however if i now navigate to any page it is supposed to be published on i get a 1064 error when trying to load it. I have tried adjusting a few bits to see if i can get it to show at all and it doesn't seem to want to show it.  I also have sh404 sef setup however if i turn this off that doesn't fix the error.  Any ideas would be great thanks as this is the first time i have tried working with custom field filters.  Thanks")*

Hi,

1064 error is a mysql error.
You should take a look in your PHP error log in order to have more details about the error.
You can also activate the joomla debug mode to see directly the error in the page and not redirect to an error page.

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

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

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

Less More

- Posts: 377
- Thank you received: 7
-
-

13 years 1 month ago -  13 years 1 month ago [\#127403](#127403) by [Dibben](/forum/user/6788-dibben "View Dibben's Profile")  Replied by *[Dibben](/forum/user/6788-dibben "View Dibben's Profile")* on topic *[1064 error when filter is switched on](/forum/45-filters-search/862716-1064-error-when-filter-is-switched-on#127403 "-- url of the page with the problem -- :   tradeheatingspares.com/new2/Alpha-Boiler...ts/boiler-parts.html  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.15  Hi, for some reason when i have my filter module published, on those pages i get a 404 error (attached). What i have done is create a new field type for product with checkbox as the select type and have added two values. I then created a module and selected my filter i wanted to display and published this on the front end however if i now navigate to any page it is supposed to be published on i get a 1064 error when trying to load it. I have tried adjusting a few bits to see if i can get it to show at all and it doesn't seem to want to show it.  I also have sh404 sef setup however if i turn this off that doesn't fix the error.  Any ideas would be great thanks as this is the first time i have tried working with custom field filters.  Thanks")*

Hi,

I have switched this on and there is a lot of information on there, I have also attached the error log. I am still none the wiser to be honest.

[ tradeheatingspares.com/new2/Worcester-Bo...cbi-natural-gas.html](http://tradeheatingspares.com/new2/Worcester-Boiler-Parts/boiler-parts/15-14-19-cbi-natural-gas.html)

Any ideas would be amazing thanks as i really don't know what is causing the issue.

Thanks

Alex

Last edit: 13 years 1 month ago by [Dibben](/forum/user/6788-dibben "View Dibben's Profile").

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

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26401
- Thank you received: 4081
-
- [](http://obsi.dev)
-

13 years 1 month ago [\#127411](#127411) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[1064 error when filter is switched on](/forum/45-filters-search/862716-1064-error-when-filter-is-switched-on#127411 "-- url of the page with the problem -- :   tradeheatingspares.com/new2/Alpha-Boiler...ts/boiler-parts.html  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.15  Hi, for some reason when i have my filter module published, on those pages i get a 404 error (attached). What i have done is create a new field type for product with checkbox as the select type and have added two values. I then created a module and selected my filter i wanted to display and published this on the front end however if i now navigate to any page it is supposed to be published on i get a 1064 error when trying to load it. I have tried adjusting a few bits to see if i can get it to show at all and it doesn't seem to want to show it.  I also have sh404 sef setup however if i turn this off that doesn't fix the error.  Any ideas would be great thanks as this is the first time i have tried working with custom field filters.  Thanks")*

Hi,

The mysql error is not in your PHP error log.
But I saw some strange lines about the helper image that I will investigate.

Thanks to the Joomla debug mode, I found the SQL request with the error.
Please edit the file: "administrator/com_hikashop/classes/filter.php" and replace the code Code:

if(!empty($datas['products'])){ $left=' LEFT JOIN '.hikashop_table('variant').' AS b ON a.characteristic_id=b.variant_characteristic_id '; foreach($datas['products'] as $data){ $option_pid[$data-&gt;product_id]=$data-&gt;product_id; } $query='SELECT product_id FROM '.hikashop_table('product').' WHERE product_parent_id IN ('.implode(',',$option_pid).')'; $database-&gt;setQuery($query); $results=$database-&gt;loadObjectList(); foreach($results as $result){ $result_pid[]=$result-&gt;product_id; } $optionElement='AND b.variant_product_id IN ('.implode(',', $result_pid).')'; }

By: Code:

if(!empty($datas['products'])){ $left=' LEFT JOIN '.hikashop_table('variant').' AS b ON a.characteristic_id=b.variant_characteristic_id '; $option_pid = array(); foreach($datas['products'] as $data){ $option_pid[$data-&gt;product_id]=$data-&gt;product_id; } $query='SELECT product_id FROM '.hikashop_table('product').' WHERE product_parent_id IN ('.implode(',',$option_pid).')'; $database-&gt;setQuery($query); $results = $database-&gt;loadObjectList(); $result_pid = array(); foreach($results as $result){ $result_pid[] = $result-&gt;product_id; } if(!empty($result_pid)) $optionElement='AND b.variant_product_id IN ('.implode(',', $result_pid).')'; }

It should fix your problem.

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

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

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

Less More

- Posts: 377
- Thank you received: 7
-
-

13 years 1 month ago [\#127415](#127415) by [Dibben](/forum/user/6788-dibben "View Dibben's Profile")  Replied by *[Dibben](/forum/user/6788-dibben "View Dibben's Profile")* on topic *[1064 error when filter is switched on](/forum/45-filters-search/862716-1064-error-when-filter-is-switched-on#127415 "-- url of the page with the problem -- :   tradeheatingspares.com/new2/Alpha-Boiler...ts/boiler-parts.html  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.15  Hi, for some reason when i have my filter module published, on those pages i get a 404 error (attached). What i have done is create a new field type for product with checkbox as the select type and have added two values. I then created a module and selected my filter i wanted to display and published this on the front end however if i now navigate to any page it is supposed to be published on i get a 1064 error when trying to load it. I have tried adjusting a few bits to see if i can get it to show at all and it doesn't seem to want to show it.  I also have sh404 sef setup however if i turn this off that doesn't fix the error.  Any ideas would be great thanks as this is the first time i have tried working with custom field filters.  Thanks")*

Hi Jerome,

This doesn't seem to have worked.

I have attached the file i have edited just so you can see i edited correctly?

Thanks

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

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26401
- Thank you received: 4081
-
- [](http://obsi.dev)
-

13 years 1 month ago [\#127419](#127419) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[1064 error when filter is switched on](/forum/45-filters-search/862716-1064-error-when-filter-is-switched-on#127419 "-- url of the page with the problem -- :   tradeheatingspares.com/new2/Alpha-Boiler...ts/boiler-parts.html  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.15  Hi, for some reason when i have my filter module published, on those pages i get a 404 error (attached). What i have done is create a new field type for product with checkbox as the select type and have added two values. I then created a module and selected my filter i wanted to display and published this on the front end however if i now navigate to any page it is supposed to be published on i get a 1064 error when trying to load it. I have tried adjusting a few bits to see if i can get it to show at all and it doesn't seem to want to show it.  I also have sh404 sef setup however if i turn this off that doesn't fix the error.  Any ideas would be great thanks as this is the first time i have tried working with custom field filters.  Thanks")*

Hi,

> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY a.characteristic\_ordering ASC' at line 1 SQL=EXPLAIN SELECT DISTINCT a.\* FROM dkibz\_hikashop\_characteristic AS a LEFT JOIN dkibz\_hikashop\_variant AS b ON a.characteristic\_id=b.variant\_characteristic\_id WHERE characteristic\_parent\_id= ORDER BY a.characteristic\_ordering ASC

For this, I can't give you any code fix.

It looks like you doesn't set an option "filter_charac" in your filter.
So, because there is characteristic configured, the SQL request can't work.

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

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

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

Less More

- Posts: 377
- Thank you received: 7
-
-

13 years 1 month ago [\#127464](#127464) by [Dibben](/forum/user/6788-dibben "View Dibben's Profile")  Replied by *[Dibben](/forum/user/6788-dibben "View Dibben's Profile")* on topic *[1064 error when filter is switched on](/forum/45-filters-search/862716-1064-error-when-filter-is-switched-on#127464 "-- url of the page with the problem -- :   tradeheatingspares.com/new2/Alpha-Boiler...ts/boiler-parts.html  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.15  Hi, for some reason when i have my filter module published, on those pages i get a 404 error (attached). What i have done is create a new field type for product with checkbox as the select type and have added two values. I then created a module and selected my filter i wanted to display and published this on the front end however if i now navigate to any page it is supposed to be published on i get a 1064 error when trying to load it. I have tried adjusting a few bits to see if i can get it to show at all and it doesn't seem to want to show it.  I also have sh404 sef setup however if i turn this off that doesn't fix the error.  Any ideas would be great thanks as this is the first time i have tried working with custom field filters.  Thanks")*

I see,

What i am trying to do is set a custom field so that when someone clicks to a product listing they can show only the 'burners' or show only the 'heat exchangers' to save the person time from looking through all the pages.

So what i have done so far is create a custom field - and added it to the product table (i guess this is the best place?) I have then also added a couple of test values to this custom field so that i can go add then to my product pages.

In the filter however i see no link between the drop down 'apply on' that relate to my custom field that i setup above.

But then in my module (attached) i have also added the 'product_types' filter to this...

My problem seems to be in linking the custom field to the filter...

Thanks

Alex

- [ ![h52e9d87.jpg](/forum/attachment/12801) ](/forum/attachment/12801 "h52e9d87.jpg") [ ](/forum/attachment/12801?download=1 "h52e9d87.jpg")
- [ ![h00d0484.jpg](/forum/attachment/12802) ](/forum/attachment/12802 "h00d0484.jpg") [ ](/forum/attachment/12802?download=1 "h00d0484.jpg")
- [ ![hc9ecd6b.jpg](/forum/attachment/12803) ](/forum/attachment/12803 "hc9ecd6b.jpg") [ ](/forum/attachment/12803?download=1 "hc9ecd6b.jpg")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg2MjcxNi0xMDY0LWVycm9yLXdoZW4tZmlsdGVyLWlzLXN3aXRjaGVkLW9uP3RtcGw9bWFya2Rvd24=) 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: 86576
- Thank you received: 14320
-
-

13 years 1 month ago [\#127521](#127521) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1064 error when filter is switched on](/forum/45-filters-search/862716-1064-error-when-filter-is-switched-on#127521 "-- url of the page with the problem -- :   tradeheatingspares.com/new2/Alpha-Boiler...ts/boiler-parts.html  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.15  Hi, for some reason when i have my filter module published, on those pages i get a 404 error (attached). What i have done is create a new field type for product with checkbox as the select type and have added two values. I then created a module and selected my filter i wanted to display and published this on the front end however if i now navigate to any page it is supposed to be published on i get a 1064 error when trying to load it. I have tried adjusting a few bits to see if i can get it to show at all and it doesn't seem to want to show it.  I also have sh404 sef setup however if i turn this off that doesn't fix the error.  Any ideas would be great thanks as this is the first time i have tried working with custom field filters.  Thanks")*

Hi,

If you want to do a filter on a custom field, then you should select "custom field" in the "apply on" option of the filter.
I tried on my end with the 2.2.2 and I can select it. If you select characteristic instead, then you won't be able to have your filter on your custom field.

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

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

Less More

- Posts: 377
- Thank you received: 7
-
-

13 years 1 month ago [\#127672](#127672) by [Dibben](/forum/user/6788-dibben "View Dibben's Profile")  Replied by *[Dibben](/forum/user/6788-dibben "View Dibben's Profile")* on topic *[1064 error when filter is switched on](/forum/45-filters-search/862716-1064-error-when-filter-is-switched-on#127672 "-- url of the page with the problem -- :   tradeheatingspares.com/new2/Alpha-Boiler...ts/boiler-parts.html  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.15  Hi, for some reason when i have my filter module published, on those pages i get a 404 error (attached). What i have done is create a new field type for product with checkbox as the select type and have added two values. I then created a module and selected my filter i wanted to display and published this on the front end however if i now navigate to any page it is supposed to be published on i get a 1064 error when trying to load it. I have tried adjusting a few bits to see if i can get it to show at all and it doesn't seem to want to show it.  I also have sh404 sef setup however if i turn this off that doesn't fix the error.  Any ideas would be great thanks as this is the first time i have tried working with custom field filters.  Thanks")*

Hi I see the custom field drop down, but this doesn't allow me to select my custom field, instead it is asking me to add new options. So if i put a few values in then great it shows on the front end but these values don't have any relationship to the products so i don't really understand again how i link the filer to the custom field and therefore filter the products based on this custom field? Do i need to re-enter the same values that match the values in the custom field? Sorry i did look at the documentation but it doesn't seem to go into that much detail on filtering.

Thanks

- [ ![h36a9713.jpg](/forum/attachment/12844) ](/forum/attachment/12844 "h36a9713.jpg") [ ](/forum/attachment/12844?download=1 "h36a9713.jpg")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg2MjcxNi0xMDY0LWVycm9yLXdoZW4tZmlsdGVyLWlzLXN3aXRjaGVkLW9uP3RtcGw9bWFya2Rvd24=) 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: 86576
- Thank you received: 14320
-
-

13 years 1 month ago [\#127704](#127704) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1064 error when filter is switched on](/forum/45-filters-search/862716-1064-error-when-filter-is-switched-on#127704 "-- url of the page with the problem -- :   tradeheatingspares.com/new2/Alpha-Boiler...ts/boiler-parts.html  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.15  Hi, for some reason when i have my filter module published, on those pages i get a 404 error (attached). What i have done is create a new field type for product with checkbox as the select type and have added two values. I then created a module and selected my filter i wanted to display and published this on the front end however if i now navigate to any page it is supposed to be published on i get a 1064 error when trying to load it. I have tried adjusting a few bits to see if i can get it to show at all and it doesn't seem to want to show it.  I also have sh404 sef setup however if i turn this off that doesn't fix the error.  Any ideas would be great thanks as this is the first time i have tried working with custom field filters.  Thanks")*

You should keep the values empty and select the custom field in the "custom field" option that you can see in your screenshot.

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

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

Less More

- Posts: 377
- Thank you received: 7
-
-

13 years 1 month ago [\#127744](#127744) by [Dibben](/forum/user/6788-dibben "View Dibben's Profile")  Replied by *[Dibben](/forum/user/6788-dibben "View Dibben's Profile")* on topic *[1064 error when filter is switched on](/forum/45-filters-search/862716-1064-error-when-filter-is-switched-on#127744 "-- url of the page with the problem -- :   tradeheatingspares.com/new2/Alpha-Boiler...ts/boiler-parts.html  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.15  Hi, for some reason when i have my filter module published, on those pages i get a 404 error (attached). What i have done is create a new field type for product with checkbox as the select type and have added two values. I then created a module and selected my filter i wanted to display and published this on the front end however if i now navigate to any page it is supposed to be published on i get a 1064 error when trying to load it. I have tried adjusting a few bits to see if i can get it to show at all and it doesn't seem to want to show it.  I also have sh404 sef setup however if i turn this off that doesn't fix the error.  Any ideas would be great thanks as this is the first time i have tried working with custom field filters.  Thanks")*

Hi Nicolas.

Thats what i was expecting to be able to do but the drop down is empty. I cannot see my custom field in there. Please see attached. Did i add my custom field to the wrong table or something?

Thanks

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

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

- **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")**
- [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")
- [ Offline](/forum/user/6861-mohamed-thelji)

Less More

- Posts: 12953
- Thank you received: 1778
-
-
-

13 years 1 month ago [\#127807](#127807) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")  Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[1064 error when filter is switched on](/forum/45-filters-search/862716-1064-error-when-filter-is-switched-on#127807 "-- url of the page with the problem -- :   tradeheatingspares.com/new2/Alpha-Boiler...ts/boiler-parts.html  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.15  Hi, for some reason when i have my filter module published, on those pages i get a 404 error (attached). What i have done is create a new field type for product with checkbox as the select type and have added two values. I then created a module and selected my filter i wanted to display and published this on the front end however if i now navigate to any page it is supposed to be published on i get a 1064 error when trying to load it. I have tried adjusting a few bits to see if i can get it to show at all and it doesn't seem to want to show it.  I also have sh404 sef setup however if i turn this off that doesn't fix the error.  Any ideas would be great thanks as this is the first time i have tried working with custom field filters.  Thanks")*

Hi,

You should **save** your filter at least one time, then your filter will be able to load all the custom fields through the "custom fields" option.

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

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