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

#   filter cursor made

##

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

Less More

- Posts: 48
- Thank you received: 0
-
-

12 years 1 month ago [\#174827](#174827) by [Nabo](/forum/user/33180-nabo "View Nabo's Profile")  *[filter cursor made](/forum/45-filters-search/872183-filter-cursor-made#174827 "-- HikaShop version -- : 2.3.3 -- HikaMarket version -- : 1.4.4 -- Joomla version -- : 3.3.6  Hi,  we have emailcontact with you guys from Hika weeks ago about the problem with the filter in cursor mode. The filter works before an update 2 month ago. We get the information from you that there is a problem within the update and you want to fix it with the next. We make the last update and the problem is still there.  Do you can say us when it will be fixed?  thanks")* was created by *[Nabo](/forum/user/33180-nabo "View Nabo's Profile")*

-- HikaShop version -- : 2.3.3
-- HikaMarket version -- : 1.4.4
-- Joomla version -- : 3.3.6

Hi,

we have emailcontact with you guys from Hika weeks ago about the problem with the filter in cursor mode. The filter works before an update 2 month ago. We get the information from you that there is a problem within the update and you want to fix it with the next. We make the last update and the problem is still there.

Do you can say us when it will be fixed?

thanks

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

12 years 1 month ago [\#174830](#174830) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[filter cursor made](/forum/45-filters-search/872183-filter-cursor-made#174830 "-- HikaShop version -- : 2.3.3 -- HikaMarket version -- : 1.4.4 -- Joomla version -- : 3.3.6  Hi,  we have emailcontact with you guys from Hika weeks ago about the problem with the filter in cursor mode. The filter works before an update 2 month ago. We get the information from you that there is a problem within the update and you want to fix it with the next. We make the last update and the problem is still there.  Do you can say us when it will be fixed?  thanks")*

Hi,

I moved your topic.
Please understand that your message is not related to HikaMarket and is not a feature request.

I let the rest of the HikaShop support team answer to your message with the rest of the HikaShop support messages.

Regards,

---

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

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

Less More

- Posts: 86576
- Thank you received: 14320
-
-

12 years 1 month ago [\#174844](#174844) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[filter cursor made](/forum/45-filters-search/872183-filter-cursor-made#174844 "-- HikaShop version -- : 2.3.3 -- HikaMarket version -- : 1.4.4 -- Joomla version -- : 3.3.6  Hi,  we have emailcontact with you guys from Hika weeks ago about the problem with the filter in cursor mode. The filter works before an update 2 month ago. We get the information from you that there is a problem within the update and you want to fix it with the next. We make the last update and the problem is still there.  Do you can say us when it will be fixed?  thanks")*

Hi,

The release of HikaShop 2.3.3 was just a security release and didn't contain any other fix or feature. The fix will be included in next real version of HikaShop to be released in one or two weeks.

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

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

Less More

- Posts: 48
- Thank you received: 0
-
-

12 years 1 month ago [\#174998](#174998) by [Nabo](/forum/user/33180-nabo "View Nabo's Profile")  Replied by *[Nabo](/forum/user/33180-nabo "View Nabo's Profile")* on topic *[filter cursor made](/forum/45-filters-search/872183-filter-cursor-made#174998 "-- HikaShop version -- : 2.3.3 -- HikaMarket version -- : 1.4.4 -- Joomla version -- : 3.3.6  Hi,  we have emailcontact with you guys from Hika weeks ago about the problem with the filter in cursor mode. The filter works before an update 2 month ago. We get the information from you that there is a problem within the update and you want to fix it with the next. We make the last update and the problem is still there.  Do you can say us when it will be fixed?  thanks")*

Hi,

we have a redirection if there is everything wrong on our site. We disable the redirection to see the problem.

now we see the following info:

1054 Error
Unknown column 'b.product_id' in 'on clause' SQL=SELECT DISTINCT b.product_id,a.category_id, a.category_id, a.category_id, pprice.price_value FROM vcdsq_hikashop_product_category AS a LEFT JOIN (SELECT * FROM vcdsq_hikashop_product AS product1 LEFT JOIN vcdsq_hikashop_price AS price1 ON product1.product_id=price1.price_product_id LEFT JOIN vcdsq_hikashop_price AS pprice ON b.product_id=pprice.price_product_id WHERE (price1.price_access = 'all' OR price1.price_access LIKE '%,10,%' OR ISNULL(price1.price_access)) AND product1.product_type='main' GROUP BY product1.product_id ORDER BY price1.price_min_quantity ASC) AS b ON a.product_id=b.product_id LEFT JOIN vcdsq_hikamarket_vendor AS hikam_vendor ON b.product_vendor_id = hikam_vendor.vendor_id LEFT JOIN vcdsq_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 (27,28,29,30,31,32,33) AND (b.product_access = 'all' OR b.product_access LIKE '%,10,%') AND ( ( case when b.price_currency_id IS NULL then 0 when b.price_currency_id = '1' and b.product_tax_id = '11' then b.price_value+b.price_value*0.19 when b.price_currency_id = '1' and b.product_tax_id = '55' then b.price_value+b.price_value*0.07 when b.price_currency_id = '1' and b.product_tax_id NOT IN ('11','55') then b.price_value when b.price_currency_id IS NULL then 0 when b.price_currency_id = '2' and b.product_tax_id = '11' then (b.price_value/1.3346)+(b.price_value/1.3346)*0.19 when b.price_currency_id = '2' and b.product_tax_id = '55' then (b.price_value/1.3346)+(b.price_value/1.3346)*0.07 when b.price_currency_id = '2' and b.product_tax_id NOT IN ('11','55') then (b.price_value/1.3346) when b.price_currency_id IS NULL then 0 when b.price_currency_id = '3' and b.product_tax_id = '11' then (b.price_value/136.49)+(b.price_value/136.49)*0.19 when b.price_currency_id = '3' and b.product_tax_id = '55' then (b.price_value/136.49)+(b.price_value/136.49)*0.07 when b.price_currency_id = '3' and b.product_tax_id NOT IN ('11','55') then (b.price_value/136.49) end ) &gt;= 1 ) AND ( case when b.price_currency_id IS NULL then 0 when b.price_currency_id = '1' and b.product_tax_id = '11' then b.price_value+b.price_value*0.19 when b.price_currency_id = '1' and b.product_tax_id = '55' then b.price_value+b.price_value*0.07 when b.price_currency_id = '1' and b.product_tax_id NOT IN ('11','55') then b.price_value when b.price_currency_id IS NULL then 0 when b.price_currency_id = '2' and b.product_tax_id = '11' then (b.price_value/1.3346)+(b.price_value/1.3346)*0.19 when b.price_currency_id = '2' and b.product_tax_id = '55' then (b.price_value/1.3346)+(b.price_value/1.3346)*0.07 when b.price_currency_id = '2' and b.product_tax_id NOT IN ('11','55') then (b.price_value/1.3346) when b.price_currency_id IS NULL then 0 when b.price_currency_id = '3' and b.product_tax_id = '11' then (b.price_value/136.49)+(b.price_value/136.49)*0.19 when b.price_currency_id = '3' and b.product_tax_id = '55' then (b.price_value/136.49)+(b.price_value/136.49)*0.07 when b.price_currency_id = '3' and b.product_tax_id NOT IN ('11','55') then (b.price_value/136.49) end ) BETWEEN 8501 AND 46728 AND (hikam_vendor.vendor_published IS NULL OR hikam_vendor.vendor_published = 1) ORDER BY a.ordering ASC

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

Less More

- Posts: 86576
- Thank you received: 14320
-
-

12 years 1 month ago [\#175041](#175041) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[filter cursor made](/forum/45-filters-search/872183-filter-cursor-made#175041 "-- HikaShop version -- : 2.3.3 -- HikaMarket version -- : 1.4.4 -- Joomla version -- : 3.3.6  Hi,  we have emailcontact with you guys from Hika weeks ago about the problem with the filter in cursor mode. The filter works before an update 2 month ago. We get the information from you that there is a problem within the update and you want to fix it with the next. We make the last update and the problem is still there.  Do you can say us when it will be fixed?  thanks")*

Hi,

Please see this post: [ www.hikashop.com/forum/filters-search/87...iltering.html#174179](http://www.hikashop.com/forum/filters-search/871750-no-results-on-filtering.html#174179)
That shoudl fix the problem.

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

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