Erreur Mysql :
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND status = 1 ORDER BY team_name' at line 1

Dernière requête :
  • 1 : SELECT * FROM teams_2021 WHERE class_id =  AND STATUS = 1 ORDER BY team_name
  • 2 : SELECT a.id, a.classid, a.links, a.media_id, a.label_fr AS label, a.slug_fr AS slug, b.* FROM boat_classes a INNER JOIN boat_classes_i18n b  ON a.id = b.id WHERE b.lang = 'fr' AND a.STATUS = 1 ORDER BY a.sort
  • 3 : SELECT SQL_CALC_FOUND_ROWS menu_items.*  FROM menu_items WHERE 1 = 1  AND menu_id = '3' AND lang = 'fr' AND STATUS = '1' ORDER BY sort
  • 4 : SELECT * FROM menus  WHERE `machine_name` = 'footer_bottom'
  • 5 : SELECT SQL_CALC_FOUND_ROWS menu_items.*  FROM menu_items WHERE 1 = 1  AND menu_id = '2' AND lang = 'fr' AND STATUS = '1' ORDER BY sort
  • 6 : SELECT * FROM menus  WHERE `machine_name` = 'secondary_menu'
  • 7 : SELECT SQL_CALC_FOUND_ROWS menu_items.*  FROM menu_items WHERE 1 = 1  AND menu_id = '1' AND lang = 'fr' AND STATUS = '1' ORDER BY sort
  • 8 : SELECT * FROM menus  WHERE `machine_name` = 'main_menu'
  • 9 : SELECT * FROM pages a INNER JOIN pages_i18n b ON a.id = b.id WHERE b.site_mask = 1 AND b.lang = 'fr' AND b.id = 13 LIMIT 0,1
  • 10 : SELECT * FROM pages  WHERE `id` = '13'
#0 Core_DatabaseMysqli->notify(You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND status = 1 ORDER BY team_name' at line 1) called at [/var/www/archives_tjv/htdocs/www/commun/classes/core/databasemysqli.class.php:27] #1 Core_DatabaseMysqli->query(SELECT * FROM teams_2021 WHERE class_id = AND status = 1 ORDER BY team_name) called at [/var/www/archives_tjv/htdocs/www/commun/classes/core/databasemysqli.class.php:49] #2 Core_DatabaseMysqli->getAssoc(SELECT * FROM teams_2021 WHERE class_id = AND status = 1 ORDER BY team_name) called at [/var/www/archives_tjv/htdocs/www/commun/classes/core/dbobjectmysqli.class.php:351] #3 Core_DBObjectMysqli->findAll(SELECT * FROM teams_2021 WHERE class_id = AND status = 1 ORDER BY team_name, 1) called at [/var/www/archives_tjv/htdocs/www/apps/models/teams_2021.class.php:66] #4 Teams_2021->getTeamsByClasse() called at [/var/www/archives_tjv/htdocs/www/apps/views/web1/skippers/index.phtml:9] #5 include(/var/www/archives_tjv/htdocs/www/apps/views/web1/skippers/index.phtml) called at [/var/www/archives_tjv/htdocs/www/apps/views/web1/layout/index.phtml:94] #6 include(/var/www/archives_tjv/htdocs/www/apps/views/web1/layout/index.phtml) called at [/var/www/archives_tjv/htdocs/www/index.php:4]