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

Mysql 5.7 support Q&A plugin

    XMLWordPrintable

Details

    Description

      With MySQL 5.7 I get the following error message when trying to register a new user because of the Q&A plugin:
       

      SQL ERROR [ mysqli ]
       
      Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'phpbb.q.question_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1055]
      

       

      The query is as follows (phpbb/captcha/plugins/qa.php):

      $sql = 'SELECT q.question_id, q.lang_iso
                  FROM ' . $this->table_captcha_questions . ' q, ' . $this->table_captcha_answers . ' a
                  WHERE q.question_id = a.question_id';
                  GROUP BY lang_iso';
      

       

      The fix is simply remove the 'GROUP BY'. It's not doing anything there.

      Attachments

        Activity

          People

            Marc Marc
            nuno-lopes nuno-lopes [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: