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

Mysql 5.7.X support

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 3.1.6, 3.2.0-dev
    • None
    • PHP 5.6.15, MYSQL 5.7.9, Firefox 42

      When the post number is pressed in viewtopic.

      Example.
      http://domain.com/forum/search.php?author_id=2&sr=posts

      This error is shown.

      General Error
      SQL ERROR [ mysqli ]
       
      Expression #1 of ORDER BY clause is not in SELECT list, references column 'psy.p.post_time' which is not in SELECT list; this is incompatible with DISTINCT [3065]
       
      SQL
       
      SELECT DISTINCT SQL_CALC_FOUND_ROWS p.post_id FROM phpbb_posts p WHERE p.poster_id = 2 AND (p.post_visibility = 1 OR p.forum_id IN (1, 2)) ORDER BY p.post_time DESC
       
      BACKTRACE
       
      FILE: (not given by php)
      LINE: (not given by php)
      CALL: msg_handler()
       
      FILE: [ROOT]/phpbb/db/driver/driver.php
      LINE: 855
      CALL: trigger_error()
       
      FILE: [ROOT]/phpbb/db/driver/mysqli.php
      LINE: 193
      CALL: phpbb\db\driver\driver->sql_error()
       
      FILE: [ROOT]/phpbb/db/driver/factory.php
      LINE: 329
      CALL: phpbb\db\driver\mysqli->sql_query()
       
      FILE: [ROOT]/phpbb/search/fulltext_native.php
      LINE: 1197
      CALL: phpbb\db\driver\factory->sql_query()
       
      FILE: [ROOT]/search.php
      LINE: 550
      CALL: phpbb\search\fulltext_native->author_search()
      

            Unassigned Unassigned
            DoYouSpeakWak?? DoYouSpeakWak?? [X] (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: