MYSQL Error

I just upgraded my server to MYSQL 5.7 and got this error when clicking on the PURCHASES link in Bankpipe:

MyBB has experienced an internal SQL error and cannot continue.



SQL Error:

    1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bigmackt_7173stang.mybb_bankpipe_payments.pid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Query:

    SELECT *, GROUP_CONCAT(bid, '|', price, '|', pid) concat FROM mybb_bankpipe_payments WHERE type NOT IN (1,0,6) AND uid = '1' GROUP BY invoice ORDER BY date DESC

Looks like a similar error comes up in the Paypal payment window when testing a payment:

MyBB has experienced an internal SQL error and cannot continue.



SQL Error:

    1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bigmackt_7173stang.mybb_bankpipe_payments.pid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Query:

    SELECT *, GROUP_CONCAT(bid, '|', price, '|', pid) concat FROM mybb_bankpipe_payments WHERE invoice = '5db827b43d78e' GROUP BY invoice ORDER BY date DESC

Any ideas how to fix? Or is this a server side setting I need to change?

Thanks,
RF

Thanks for your report. This is indeed an issue with MySQL's ONLY_FULL_GROUP_BY option which I have solved in beta 8. Since the fix is quite technical, I'd suggest you to turn off the option in your MySQL manager. Here's a handy and quick tutorial: https://stackoverflow.com/questions/2392...y/23921234