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

DB error while running mysql database in strict sql mode

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Resolved
    • 3.0.11
    • None
    • Search
    • None

    Description

      When you have enabled strict SQL checking on the mysql database (ONLY_FULL_GROUP_BY) then you get an db error when you hit the "own posts" button in the forum:

      ====================================
      SQL ERROR [ mysql4 ]

      'phpbb3_db.p.post_id' isn't in GROUP BY [1055]

      SQL

      SELECT DISTINCT SQL_CALC_FOUND_ROWS p.post_id FROM phpbb_topics t, phpbb_posts p WHERE p.poster_id = '2' AND t.topic_id = p.topic_id GROUP BY t.topic_id, t.topic_last_post_time ORDER BY t.topic_last_post_time DESC

      BACKTRACE

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

      FILE: [ROOT]/includes/search/fulltext_native.php
      LINE: 1009
      CALL: dbal_mysql->sql_query()

      FILE: [ROOT]/search.php
      LINE: 513
      CALL: fulltext_native->author_search()
      ====================================

      When you look at the sql statement you can see that it's not valid sql
      compared to sql standards.

      Best regards
      McA

      Attachments

        Issue Links

          Activity

            People

              bantu Andreas Fischer [X] (Inactive)
              _McA_ _McA_ [X] (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: