phpBB.de

Code: Alles auswählen

Could not obtain newer/older topic information

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') WHERE t.topic_id = 4144 AND t.topic_moved_id = 0

SELECT p.post_id, t.topic_last_post_id FROM (mforum_topics t LEFT JOIN mforum_posts p ON p.topic_id = t.topic_id AND p.post_time > ) WHERE t.topic_id = 4144 AND t.topic_moved_id = 0 ORDER BY p.post_time

Line : 193
File : /home/w0402mf01/www.muenzforum.com/viewtopic.php

Code: Alles auswählen

//-- add
		// read the first unread post in this topic
		$sql = "SELECT p.post_id, t.topic_last_post_id
					FROM (" . TOPICS_TABLE . " t
						LEFT JOIN " . POSTS_TABLE . " p ON p.topic_id = t.topic_id AND p.post_time > $topic_last_read)
					WHERE t.topic_id = $topic_id
						AND t.topic_moved_id = 0
					ORDER BY p.post_time";
		if ( !$result = $db->sql_query($sql) )
		{
			message_die(GENERAL_ERROR, 'Could not obtain newer/older topic information', '', __LINE__, __FILE__, $sql);
		}
		if ( !$row = $db->sql_fetchrow($result) )
		{
			message_die(GENERAL_MESSAGE, 'No_new_posts_last_visit');
		}
		$post_id = empty($row['post_id']) ? $row['topic_last_post_id'] : $row['post_id'];
		redirect(append_sid("./viewtopic.$phpEx?" . POST_POST_URL . "=$post_id#$post_id", true));
//-- fin mod : keep unread -------------------------------------------------------------------------