filters broken pages

  • Posts: 222
  • Thank you received: 1
10 years 10 months 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: 10 years 10 months ago by Jerome.

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

  • Posts: 26159
  • Thank you received: 4028
  • MODERATOR
10 years 10 months 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.059 seconds
Powered by Kunena Forum