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.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: