- Posts: 377
- Thank you received: 7
1064 error when filter is switched on
-- 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
Please Log in or Create an account to join the conversation.
Thanks.
Please Log in or Create an account to join the conversation.
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 & HikaSerial developer / HikaShop core dev team.
Please Log in or Create an account to join the conversation.
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
Any ideas would be amazing thanks as i really don't know what is causing the issue.
Thanks
Alex
Please Log in or Create an account to join the conversation.
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
Regards,
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Please Log in or Create an account to join the conversation.
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 or Create an account to join the conversation.
For this, I can't give you any code fix.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
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 & HikaSerial developer / HikaShop core dev team.
Please Log in or Create an account to join the conversation.
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
Please Log in or Create an account to join the conversation.
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 or Create an account to join the conversation.
Thanks
Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.
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
Please Log in or Create an account to join the conversation.
- Posts: 12953
- Thank you received: 1778
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 or Create an account to join the conversation.