chatlumo Posted June 26, 2014 Share Posted June 26, 2014 Bonjour, Je n'en connais pas la cause mais aujourd'hui mon site est planté (PS 1.6), à cause d'une erreur SQL : SELECT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `ESPBDD_category` c INNER JOIN `ESPBDD_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) INNER JOIN `ESPBDD_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1) WHERE (c.`active` = 1 OR c.`id_category` = 0) AND c.`id_category` != 1 AND `level_depth` <= 4 AND nleft >= AND nright <= AND c.id_category IN ( SELECT id_category FROM `ESPBDD_category_group` WHERE `id_group` IN (2) ) ORDER BY `level_depth` ASC, cl.`name` ASC A priori l'erreur vient de "AND nleft >= AND nright <=" mais je ne sais pas ce qui fait que ces comparaisons n'ont aucune valeur... Savez-vous d'où cela vient ? Merci Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now