diff options
| author | Andreas Fischer <bantu@phpbb.com> | 2011-11-27 16:12:39 +0100 |
|---|---|---|
| committer | Andreas Fischer <bantu@phpbb.com> | 2011-11-27 16:12:39 +0100 |
| commit | b89320ad392628a093b351ac8bdd79b8e58f22aa (patch) | |
| tree | de8973fc155a311f9479c548b04d1180a95b3fe0 /phpBB/includes | |
| parent | 007457f18295cd4019684e1470110dd4b50de8cf (diff) | |
| parent | 77e00d14a196d14910bdf2275ab01380b7b7f18f (diff) | |
| download | forums-b89320ad392628a093b351ac8bdd79b8e58f22aa.tar forums-b89320ad392628a093b351ac8bdd79b8e58f22aa.tar.gz forums-b89320ad392628a093b351ac8bdd79b8e58f22aa.tar.bz2 forums-b89320ad392628a093b351ac8bdd79b8e58f22aa.tar.xz forums-b89320ad392628a093b351ac8bdd79b8e58f22aa.zip | |
Merge remote-tracking branch 'rxu/ticket/10497' into prep-release-3.0.10
* rxu/ticket/10497:
[ticket/10497] Fix SQL error when guest visits forum with unread topic
Diffstat (limited to 'phpBB/includes')
| -rw-r--r-- | phpBB/includes/functions.php | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/phpBB/includes/functions.php b/phpBB/includes/functions.php index 944e53052b..7ce83b871a 100644 --- a/phpBB/includes/functions.php +++ b/phpBB/includes/functions.php @@ -1943,11 +1943,11 @@ function update_forum_tracking_info($forum_id, $forum_last_post_time, $f_mark_ti } else { - $sql = 'SELECT topic_id - FROM ' . TOPICS_TABLE . ' - WHERE forum_id = ' . $forum_id . ' - AND topic_last_post_time > ' . $mark_time_forum . ' - AND topic_moved_id = 0 ' . + $sql = 'SELECT t.topic_id + FROM ' . TOPICS_TABLE . ' t + WHERE t.forum_id = ' . $forum_id . ' + AND t.topic_last_post_time > ' . $mark_time_forum . ' + AND t.topic_moved_id = 0 ' . $sql_update_unapproved; $result = $db->sql_query($sql); |