Jump to content

error GROUP BY id_category ORDER BY `level_depth` ASC, c.`position` ASC' at line 7


alexsci7

Recommended Posts

Salve a tutti,

per caso a qualcuno di voi è mai capitato questo errore???

 

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` = 5)

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` <= 5

AND cg.`id_group` IN ()

GROUP BY id_category

ORDER BY `level_depth` ASC, c.`position` ASC

 

Spero in qualche anima buona in grado di risolvere..;)

saluti e grazie in anticipo

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...