Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-10497

SQL error when guest visits forum with unread topic

XMLWordPrintable

      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.

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

              Created:
              Updated:
              Resolved: