Gizmo
01-03-2008, 05:43 AM
Hi the techy guy for my forum is on his jollies and I need a fix for this problem.
Its all foreign to me so will need and a step through in simple terms please as I don't even know where to look .:confused:
I have done a support ticket but not had a reply yet.
SQL requests not achieved
DEBUG MODE
SQL Error: 1054 Unknown column 't.topic_last_post_id' in 'on clause'
SQL Request: SELECT t.*, p.post_text as hover_post FROM phpbb_topics t, phpbb_forums f LEFT JOIN phpbb_posts_text p ON p.post_id = t.topic_last_post_id WHERE f.forum_id = t.forum_id AND (f.forum_order BETWEEN 0 AND 1740) AND f.forum_id <> 0 ORDER BY t.topic_last_time DESC LIMIT 5
Line : 105
File : class_topics_recent.php
Thanks in advance
Its all foreign to me so will need and a step through in simple terms please as I don't even know where to look .:confused:
I have done a support ticket but not had a reply yet.
SQL requests not achieved
DEBUG MODE
SQL Error: 1054 Unknown column 't.topic_last_post_id' in 'on clause'
SQL Request: SELECT t.*, p.post_text as hover_post FROM phpbb_topics t, phpbb_forums f LEFT JOIN phpbb_posts_text p ON p.post_id = t.topic_last_post_id WHERE f.forum_id = t.forum_id AND (f.forum_order BETWEEN 0 AND 1740) AND f.forum_id <> 0 ORDER BY t.topic_last_time DESC LIMIT 5
Line : 105
File : class_topics_recent.php
Thanks in advance