You have an error in your SQL syntax..

[claudio]

Hi guys,

 

When visiting the front end (any page), the following error appears;

 

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 ') GROUP BY id_category ORDER BY `level_depth` ASC, c.`position` ASC' at line 7

                SELECT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
                FROM `ps_category` c
                LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1)
                LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
                WHERE (c.`active` = 1 OR c.`id_category` = 1)
                 AND `level_depth` <= 3
                AND cg.`id_group` IN ()
                GROUP BY id_category
                ORDER BY `level_depth` ASC, c.`position` ASC

 

 

Any suggestions on how to fix this please?

Thanks!

[rocky]

It seems to be related to customer groups. Make sure there are customer groups on the Customers > Groups tab in the Back Office. I can't be any more specific without actually inspecting your code.

[bellini13]

The problem is with this part of the SQL statement

AND cg.`id_group` IN ()

It is trying to select based on some group ID's, however the list of group ID's is empty

 

So as Rocky stated, you need to confirm that you have groups defined, or perhaps you have some module installed that is defective.  You may need to search through your modules to find this SQL coding and determine why that group ID list is empty