| |
could not obtain main information.
DEBUG MODE
SQL Error : 1054 Unknown column 't.topic_first_post_id' in 'on clause'
SELECT t.*, p.poster_id, p.post_username AS last_poster_name, p.post_id, p.post_time, f.forum_name, f.forum_id, u.username AS last_poster, u.user_id AS last_poster_id, u2.username AS first_poster, u2.user_id AS first_poster_id, p2.post_username AS first_poster_name
FROM phpbb_topics t, phpbb_posts p
LEFT OUTER JOIN phpbb_posts p2 ON p2.post_id = t.topic_first_post_id
LEFT OUTER JOIN phpbb_forums f ON p.forum_id = f.forum_id
LEFT OUTER JOIN phpbb_users u ON p.poster_id = u.user_id
LEFT OUTER JOIN phpbb_users u2 ON u2.user_id = t.topic_poster
WHERE t.forum_id NOT IN (1,2,3,4,5,6,7,8,9,11,12,21,22,23,152,24,25,26,27,28,29,30,32,33,35,36,37,38,40,47,42,43,44,45,48,50,51,52,53,103,56,57,58,59,60,61,63,122,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,81,82,85,86,87,88,89,90,91,92,93,94,95,96,97,98,100,101,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,123,124,125,126,127,128,129,130,131,132,133,134,135,139,142,143,144,145,146,147,148,151,155,154,149,150,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,191,176,177,178,179,180,181,182,183,184,186,185,187,188,189,190,192,193,198,202,221,230,233,234,250) AND p.post_id = t.topic_last_post_id AND FROM_UNIXTIME(p.post_time,'%Y%m%d') - FROM_UNIXTIME(unix_timestamp(NOW()),'%Y%m%d') = 0 ORDER BY t.topic_last_post_id DESC LIMIT 0, 10
Line : 127
File : recent.php |
| |
|