| |
Could not obtain main information
DEBUG MODE
SQL Error : 1054 Unknown column 't.topic_poster' in 'on clause'
SELECT from_unixtime(p.post_time, '%d.%m.%y %H:%i:%s') as topic_time, f.forum_name as forum_name, f.forum_id as forum_id,
u.username as username, u2.username as username2, u2.user_id as user_id2, p.poster_id as poster_id, p.post_username as post_username, p.post_id as post_id, t.*, p.post_time as post_time
FROM topics t, posts p
LEFT OUTER JOIN forums f on p.forum_id = f.forum_id
LEFT OUTER JOIN users u on p.poster_id = u.user_id
LEFT OUTER JOIN users u2 on u2.user_id = t.topic_poster
WHERE t.topic_id IN (4, 5, 6, 7, 10, 11, 14, 17, 18, 20, 22, 24, 25, 26, 27, 28, 29, 34, 36, 37, 38) AND p.post_id = t.topic_last_post_id AND UNIX_TIMESTAMP(NOW()) - p.post_time < 86400 ORDER BY p.post_time desc LIMIT 0, 50
Line : 116
File : recent.php |
| |
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Calendar 