J'ai installé la contrib latest news, mais lorsque je clique sur le lien de ma news en page d'accueil, j'ai le message suivant :
Code
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 'select news_id, headline, content, date_added from latest_news news where status' at line 1
select count(select news_id, headline, content, date_added from latest_news news where status = \'1\' and language = \'4\' order by date_added DESC) as total
[TEP STOP]
select count(select news_id, headline, content, date_added from latest_news news where status = \'1\' and language = \'4\' order by date_added DESC) as total
[TEP STOP]
le requête est
Code
$listing_sql = 'select news_id, headline, content, date_added from ' . TABLE_LATEST_NEWS . " news where status = '1' and language = '". $languages_id. "' order by date_added DESC";
je ne vois rien d'anormal dans cette requête!
Avez-vous des indices pour résooudre ce problème ??
merci