Erreur MySQL : 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 ') and b.lg='fr' and (a.type='formation' or a.type='theme' or a.type='subtheme') ' at line 1
Requête originale : SELECT b.titre, a.parent, b.duree, b.objectifs, b.participants, LEFT(texte, 255) AS intro, b.nav_url, a.id, (select c.nav_url from wagaia_pages_data c where page_id=a.parent) as parent_url, a.type FROM wagaia_pages a join wagaia_pages_data b on a.id=b.page_id where 1=1 and () and b.lg='fr' and (a.type='formation' or a.type='theme' or a.type='subtheme') ORDER BY b.titre
#0 Database->error(SELECT b.titre, a.parent, b.duree, b.objectifs, b.participants, LEFT(texte, 255) AS intro, b.nav_url, a.id, (select c.nav_url from wagaia_pages_data c where page_id=a.parent) as parent_url, a.type FROM wagaia_pages a join wagaia_pages_data b on a.id=b.page_id where 1=1 and () and b.lg='fr' and (a.type='formation' or a.type='theme' or a.type='subtheme') ORDER BY b.titre, ) called at [/home/formatioczw/www/wagaia/php/mysqli.class.php:268] #1 Database->query(SELECT b.titre, a.parent, b.duree, b.objectifs, b.participants, LEFT(texte, 255) AS intro, b.nav_url, a.id, (select c.nav_url from wagaia_pages_data c where page_id=a.parent) as parent_url, a.type FROM wagaia_pages a join wagaia_pages_data b on a.id=b.page_id where 1=1 and () and b.lg='fr' and (a.type='formation' or a.type='theme' or a.type='subtheme') ORDER BY b.titre) called at [/home/formatioczw/www/wagaia/php/mysqli.class.php:240] #2 Database->toArray() called at [/home/formatioczw/www/wagaia/php/mysqli.class.php:222] #3 Database->select(SELECT b.titre, a.parent, b.duree, b.objectifs, b.participants, LEFT(texte, 255) AS intro, b.nav_url, a.id, (select c.nav_url from wagaia_pages_data c where page_id=a.parent) as parent_url, a.type FROM wagaia_pages a join wagaia_pages_data b on a.id=b.page_id where 1=1 and () and b.lg='fr' and (a.type='formation' or a.type='theme' or a.type='subtheme') ORDER BY b.titre) called at [/home/formatioczw/www/content/page_404.php:21] #4 include(/home/formatioczw/www/content/page_404.php) called at [/home/formatioczw/www/index.php:242]