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

SQL error when guest visits forum with unread topic

    XMLWordPrintable

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

              rxu rxu
              jask Jan Skovsgaard [X] (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: