filters broken pages

  • Posts: 222
  • Thank you received: 1
12 years 1 day ago #140119

latest versions

I have aded two filters, all was okey. But after adding 3th filter I can't acces my product pages ( home page no problem).

I have a screen with:

SQL=SELECT DISTINCT b.product_id,max(a.category_id) as max_Kleur_keuze, min(a.category_id) as min_Kleur_keuze, max(a.category_id) as max_maat, min(a.category_id) as min_maat, max(a.category_id) as max_m-maat, min(a.category_id) as min_m-maat FROM uxgib_hikashop_product_category AS a LEFT JOIN uxgib_hikashop_product AS b ON a.product_id=b.product_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (32) AND (b.product_access = 'all' OR b.product_access LIKE '%,1,%') ORDER BY a.ordering ASC

What happend?

vero

Last edit: 12 years 1 day ago by Jerome.

Please Log in or Create an account to join the conversation.

  • Posts: 26310
  • Thank you received: 4051
  • MODERATOR
12 years 1 day ago #140125

Hi,

Please use the mysqli driver instead of the mysql one.
The mysql driver in Joomla 3 does not display the SQL error message so it is more difficult to see the error if we just have the SQL request.

Regards,


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

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

Time to create page: 0.051 seconds
Powered by Kunena Forum