Forum

Fatale : invalid query. (ERRNO 1064) 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 ''10'' at line 9query: SELECT @id_cat:= ac.id, ac.id, ac.name, ac.description, ac.image, ac.rewrited_name,
(SELECT COUNT(*) FROM phpboost_articles articles 
WHERE articles.id_category = @id_cat
AND (published = 1 OR (published = 2 AND publishing_start_date < 1430683488 AND (publishing_end_date > 1430683488 OR publishing_end_date = 0)))
) AS nbr_articles
FROM phpboost_articles_cats ac 
WHERE ac.id_parent = '3' AND ac.id IN ('3')
ORDER BY ac.id_parent, ac.c_order
LIMIT '10' 
 
 
[0] /kernel/framework/io/db/driver/mysql/MySQLQuerier.class.php:48 - MySQLQuerier->EXECUTE(string, array)
[1] /kernel/framework/io/db/DBQuerier.class.php:50 - MySQLQuerier->SELECT(string, array, INT)
[2] /articles/controllers/ArticlesDisplayCategoryController.class.php:154 - DBQuerier->SELECT(string, array)
[3] /articles/controllers/ArticlesDisplayCategoryController.class.php:61 - ArticlesDisplayCategoryController->build_categories_listing_view(DATE)
[4] /articles/controllers/ArticlesDisplayCategoryController.class.php:42 - ArticlesDisplayCategoryController->build_view()
[5] /kernel/framework/mvc/dispatcher/UrlControllerMapper.class.php:87 - ArticlesDisplayCategoryController->EXECUTE(HTTPRequestCustom)
[6] /kernel/framework/mvc/dispatcher/UrlControllerMapper.class.php:59 - UrlControllerMapper->do_call()
[7] /kernel/framework/mvc/dispatcher/Dispatcher.class.php:67 - UrlControllerMapper->CALL()
[8] /kernel/framework/mvc/dispatcher/DispatchManager.class.php:43 - Dispatcher->dispatch()
[9] /articles/INDEX.php:63 - DispatchManager::dispatch(array)
[URL] /articles/3-2eme-annee/