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

            • Assignee:
              Marc Marc
              Reporter:
              nuno-lopes nuno-lopes
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: