Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-10497

SQL error when guest visits forum with unread topic

    Details

      Description

      Started after 3.0.10RC update on one of my boards

      SQL ERROR [ mysqli ]

      Unknown column 't.topic_approved' in 'where clause' [1054]

      SQL

      SELECT topic_id FROM phpbb_topics WHERE forum_id = 9 AND topic_last_post_time > 1322208430 AND topic_moved_id = 0 AND t.topic_approved = 1

      BACKTRACE

      FILE: [ROOT]/includes/db/mysqli.php
      LINE: 182
      CALL: dbal->sql_error()

      FILE: [ROOT]/includes/functions.php
      LINE: 1952
      CALL: dbal_mysqli->sql_query()

      FILE: [ROOT]/viewforum.php
      LINE: 717
      CALL: update_forum_tracking_info()

      Appears when guest visiting a forum with new topic mark as unread (Enable topic marking for guests: Yes). When guest choose to mark all forums as read, the error disappear. Logged in users never see this error.

        Issue Links

          Activity

          There are no comments yet on this issue.

            People

            • Assignee:
              rxu Ruslan Uzdenov
              Reporter:
              jask Jan Skovsgaard
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development