| |
Could not query list of active posts
DEBUG MODE
SQL Error : 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 '100 post_id from janephpbb_posts order by post_id DESC)
and t.forum_id = f.fo' at line 4
SELECT f.forum_name, t.topic_title, u.user_id, u.username, u.user_sig, u.user_sig_bbcode_uid, p.post_id, pt.post_text, pt.post_subject, pt.bbcode_uid, p.post_time, t.topic_replies, t.topic_first_post_id
FROM janephpbb_forums AS f, janephpbb_topics AS t, janephpbb_users AS u, janephpbb_posts AS p, janephpbb_posts_text as pt
WHERE
p.post_id in (select top 100 post_id from janephpbb_posts order by post_id DESC)
and t.forum_id = f.forum_id
and f.auth_view = 0 and f.auth_read=0
AND f.auth_view = 0
AND p.poster_id = u.user_id
AND pt.post_id = p.post_id
AND p.topic_id = t.topic_id
ORDER BY p.post_id DESC LIMIT 15
Line : 170
File : rss.php |
| |
|