phpBB.de

Code: Alles auswählen

Could not obtain last topic data

DEBUG MODE

SQL Error : 1054 Unknown column 't.forum_id' in 'on clause'

SELECT t.topic_title, p.post_time FROM phpbb_topics t, phpbb_posts p LEFT JOIN phpbb_forums f ON t.forum_id = f.forum_id WHERE p.post_id = t.topic_last_post_id AND f.auth_view < 2 ORDER BY t.topic_last_post_id DESC LIMIT 0,1

Code: Alles auswählen

$sql = "SELECT t.topic_title	FROM " . TOPICS_TABLE . " t
	LEFT JOIN " . FORUMS_TABLE . " f ON t.forum_id = f.forum_id
		WHERE f.auth_view < 2
ORDER BY t.topic_last_post_id DESC LIMIT 0,1";
if ( !($result = $db->sql_query($sql)) )
{
	message_die(GENERAL_ERROR, 'Could not obtain last topic data', '', __LINE__, __FILE__, $sql);
}