Filter Error 1064 on joomla 3.3.6
- the heatkiller
-
Topic Author
- Offline
Less
More
11 years 9 months ago - 11 years 9 months ago #190230
by the heatkiller
Filter Error 1064 on joomla 3.3.6 was created by the heatkiller
-- HikaShop version -- : 2.3.5
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.5.9
-- Error-message(debug-mod must be tuned on) -- : 1064 - 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 '-filter_, round(max( case when pprice.price_currency_id IS NULL then 0 when ppri' at line 1 SQL=SELECT DISTINCT b.product_id,round(min( case when pprice.price_currency_id IS NULL then 0 when pprice.price_currency_id = '47' and b.product_tax_id = '30' then pprice.price_value+pprice.price_value*0.25 when pprice.price_currency_id = '47' and b.product_tax_id = '11' then pprice.price_value+pprice.price_value*0 when pprice.price_currency_id = '47' and b.product_tax_id NOT IN ('30','11') then pprice.price_value end ),2) as min_Harddisk-filter_, round(max( case when pprice.price_currency_id IS NULL then 0 when pprice.price_currency_id = '47' and b.product_tax_id = '30' then pprice.price_value+pprice.price_value*0.25 when pprice.price_currency_id = '47' and b.product_tax_id = '11' then pprice.price_value+pprice.price_value*0 when pprice.price_currency_id = '47' and b.product_tax_id NOT IN ('30','11') then pprice.price_value end ),2) as max_Harddisk-filter_ FROM mrr79_hikashop_product_category AS a LEFT JOIN mrr79_hikashop_product AS b ON a.product_id=b.product_id LEFT JOIN mrr79_hikashop_price AS pprice ON b.product_id=pprice.price_product_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (172,173,174,175,221,222,224,225,226,445,449,448,444,452,460,459,458,457,454,453,846) AND b.product_quantity!=0 AND (b.product_access = 'all' OR b.product_access LIKE '%,9,%') ORDER BY a.ordering ASC
Hello
I just update hikashop to bussnis 2.3.5
from 2.2.2 hikashop ES.
I am in the process of putting a new page.
But when I put a price filter up with Cursor I get an error 1064
Now I've read forum in store this but I have not fudet a solution to my problem.
I've tried CheckBox instead of the run very slow and coming timeouts when I use this.
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.5.9
-- Error-message(debug-mod must be tuned on) -- : 1064 - 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 '-filter_, round(max( case when pprice.price_currency_id IS NULL then 0 when ppri' at line 1 SQL=SELECT DISTINCT b.product_id,round(min( case when pprice.price_currency_id IS NULL then 0 when pprice.price_currency_id = '47' and b.product_tax_id = '30' then pprice.price_value+pprice.price_value*0.25 when pprice.price_currency_id = '47' and b.product_tax_id = '11' then pprice.price_value+pprice.price_value*0 when pprice.price_currency_id = '47' and b.product_tax_id NOT IN ('30','11') then pprice.price_value end ),2) as min_Harddisk-filter_, round(max( case when pprice.price_currency_id IS NULL then 0 when pprice.price_currency_id = '47' and b.product_tax_id = '30' then pprice.price_value+pprice.price_value*0.25 when pprice.price_currency_id = '47' and b.product_tax_id = '11' then pprice.price_value+pprice.price_value*0 when pprice.price_currency_id = '47' and b.product_tax_id NOT IN ('30','11') then pprice.price_value end ),2) as max_Harddisk-filter_ FROM mrr79_hikashop_product_category AS a LEFT JOIN mrr79_hikashop_product AS b ON a.product_id=b.product_id LEFT JOIN mrr79_hikashop_price AS pprice ON b.product_id=pprice.price_product_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (172,173,174,175,221,222,224,225,226,445,449,448,444,452,460,459,458,457,454,453,846) AND b.product_quantity!=0 AND (b.product_access = 'all' OR b.product_access LIKE '%,9,%') ORDER BY a.ordering ASC
Hello
I just update hikashop to bussnis 2.3.5
I am in the process of putting a new page.
But when I put a price filter up with Cursor I get an error 1064
Now I've read forum in store this but I have not fudet a solution to my problem.
I've tried CheckBox instead of the run very slow and coming timeouts when I use this.
Last edit: 11 years 9 months ago by the heatkiller.
Please Log in or Create an account to join the conversation.
11 years 9 months ago #190276
by Xavier
Replied by Xavier on topic Filter Error 1064 on joomla 3.3.6
Hi,
Please give us more informations about your filter, like a screenshot.
I think that the issue potentially come from the filter name, or something like that.
So you can too potentially try to rename it for testing purposes
Please give us more informations about your filter, like a screenshot.
I think that the issue potentially come from the filter name, or something like that.
So you can too potentially try to rename it for testing purposes
Please Log in or Create an account to join the conversation.
- the heatkiller
-
Topic Author
- Offline
11 years 9 months ago #191174
by the heatkiller
Replied by the heatkiller on topic Filter Error 1064 on joomla 3.3.6
HI Xavier
you're right, there were two filter with similar names, and therefore I got the error :pinch:
you're right, there were two filter with similar names, and therefore I got the error :pinch:
Please Log in or Create an account to join the conversation.
Time to create page: 0.049 seconds