Re: Funkcja nowe posty
autor: Tomek W. » 04 sty 2012, 9:08
Taki bład dostaję:
Could not obtain search results
DEBUG MODE
SQL Error : 1054 Unknown column 'p.post_subject' in 'field list'
SELECT t.*, f.forum_id, f.forum_name, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_subject, p.post_username, p2.post_username AS post_username2, p2.post_time FROM f_topics t, f_forums f, f_users u, f_posts p, f_posts p2, f_users u2 WHERE t.topic_id IN (141, 218, 1065, 6214, 7386, 9124, 9562, 10438, 11484, 19624, 20610, 24638, 25430, 27227, 27314, 27960, 28557, 29244, 29738, 29885, 30172, 30504, 30568, 30627, 30706, 30837, 30843, 30916, 30950, 30973, 31003, 31017, 31018, 31020, 31034, 31038, 31040, 31063, 31064, 31065, 31066, 31067, 31068) AND t.topic_poster = u.user_id AND f.forum_id = t.forum_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id ORDER BY p2.post_time DESC LIMIT 0, 50
Line : 893
File : search.php
PozdrawiamTomek W.e-konsultant Rockwool