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_en AS label, a.slug_en AS slug, b.* FROM boat_classes a INNER JOIN boat_classes_i18n b ON a.id = b.id WHERE b.lang = 'en' 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 = 'en' 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 = 'en' 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 = 'en' 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 = 'en' 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]