02-12-2008, 07:37 PM
|
#3 (permalink)
|
| Active Forumer
Join Date: Feb 2005
Posts: 555
Rep Power: 4  fBuck$: 8,260.1 Bank: 0.0 Total fBuck$: 8,260.1 My Forumer
My Country:
|  Re: fportal bug error help now please!!!!!!
Quote: |
SELECT t.topic_id, t.topic_time, t.topic_title, pt.post_text, u.username, u.user_id, t.topic_replies, pt.bbcode_uid, t.forum_id, t.topic_poster, t.topic_first_post_id, t.topic_status, pt.post_id, p.post_id, p.enable_smilies FROM thetsviets_topics AS t, thetsviets_users AS u, thetsviets_posts_text AS pt, thetsviets_posts AS p WHERE t.forum_id IN (13,) AND t.topic_time <= 1202860928 AND t.topic_poster = u.user_id AND t.topic_first_post_id = pt.post_id AND t.topic_first_post_id = p.post_id AND t.topic_status <> 2 ORDER BY t.topic_time DESC LIMIT 0,5
| There is a comma after 13. Remove it and all should work again as expected.
Administration Panel => fPortal => News forum(s) Tuitam |
|
| |