Newbie
Inscrit: 16/06/2005 14:46
|
Bonjour J'ai la version 2.0.10 de xoops et je viens d'installer le Newbb2 pour le forum. J'ai un pb: je n'arrive pas à faire paraitre les blocs de forum sur mon site (il y en a 3). Je l'ai mis en mode debug et voilà ce qu'il m'affiche comme msg d'erreur: - SELECT t.*, f.forum_name, f.allow_subject_prefix, p.post_id, p.icon, p.uid, p.poster_name, u.uname, u.name FROM xoops_bb_topics t, xoops_bb_forums f, xoops_bb_posts p LEFT JOIN xoops_users u ON u.uid = p.uid WHERE f.forum_id=t.forum_id AND t.forum_id IN () AND t.approved = 1 AND p.approved = 1 AND t.topic_last_post_id=p.post_id ORDER BY t.topic_views DESC LIMIT 0, 10 Error number: 1064 Error message: 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 t.approved = 1 AND p.approved = 1 AND t.topic_last_post_id=p.post_id ORDER' at line 1 - SELECT t.*, f.forum_name, f.allow_subject_prefix, p.post_id, p.icon, p.uid, p.poster_name, u.uname, u.name FROM xoops_bb_topics t, xoops_bb_forums f, xoops_bb_posts p LEFT JOIN xoops_users u ON u.uid = p.uid WHERE f.forum_id=t.forum_id AND t.forum_id IN () AND t.approved = 1 AND p.approved = 1 AND t.topic_last_post_id=p.post_id ORDER BY t.topic_replies DESC LIMIT 0, 10 Error number: 1064 Error message: 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 t.approved = 1 AND p.approved = 1 AND t.topic_last_post_id=p.post_id ORDER' at line 1 - SELECT t.*, f.forum_name, f.allow_subject_prefix, p.post_id, p.icon, p.uid, p.poster_name, u.uname, u.name FROM xoops_bb_topics t, xoops_bb_forums f, xoops_bb_posts p LEFT JOIN xoops_users u ON u.uid = p.uid WHERE f.forum_id=t.forum_id AND t.forum_id IN () AND t.approved = 1 AND p.approved = 1 AND t.topic_last_post_id=p.post_id ORDER BY t.topic_time DESC LIMIT 0, 10 Error number: 1064 Error message: 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 t.approved = 1 AND p.approved = 1 AND t.topic_last_post_id=p.post_id ORDER' at line 1 Alors je ne sais pas comment les résoudre; Merci pour votre aide.
Posté le : 13/09/2005 15:41
|