Jump to content

Site planté suite erreur SQL


Recommended Posts

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

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...