On /index.php?name=ForumsCentreBlock
While executing query "SELECT
p.post_time, t.topic_id, t.forum_id, t.topic_title, t.topic_poster, t.topic_views, t.topic_replies, t.topic_type, t.topic_status,
t.topic_last_post_id, t.topic_first_post_id, t.topic_moved_id, t.topic_attachment, t.icon_id,
f.forum_id, f.forum_name, f.auth_read, n.notify_status,
u.username, u.user_posts, v.username, v.user_posts, w.poster_ip, i.icon_url,
p.poster_id, p.poster_ip, p.post_id, s.post_text, m.custom_title
FROM cms_bbtopics t, cms_bbforums f
LEFT JOIN cms_bbposts p ON (p.post_id=t.topic_last_post_id)
LEFT JOIN cms_bbposts w ON (w.post_id=t.topic_first_post_id)
LEFT JOIN cms_users u ON (u.user_id=p.poster_id)
LEFT JOIN cms_users v ON (v.user_id=t.topic_poster)
LEFT JOIN cms_bbtopics_watch n ON (n.user_id=1 AND n.topic_id=t.topic_id)
LEFT JOIN cms_bbtopic_icons i ON (i.icon_id=t.icon_id)
LEFT JOIN cms_bbposts_text s ON (s.post_id=t.topic_last_post_id)
LEFT JOIN cms_modules m ON (m.title="Forums") WHERE t.forum_id=f.forum_id AND t.topic_moved_id=0
ORDER BY p.post_time DESC LIMIT 10"
the following error occured: Unknown column 't.topic_last_post_id' in 'on clause'
In: ForumsCentreBlock/index.php on line: 100
Guest information:
User id: 1
Username: Anonymous
Admin: No
IP: 74.6.18.249
Host: llf520125.crawl.yahoo.net
Alle Zeitangaben sind in GMT + 1 Stunden