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

              was caused by solution of

              Bug - A problem which impairs or prevents the functions of the product. PHPBB3-9008 Incorrect unread topic tracking for unapproved topics

              • Minor - Minor loss of function, or other problem where easy workaround is present.
              • Unverified Fix

                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