29 Oct 2019 Edited #1

MYSQL Error

Ultimate subscriber
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
Shade 29 Oct 2019
#2
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