Donation System Error (Log)

[Tyler 2]

I am currently getting the following log whenever a user tries to use the donation system:

SELECT *, SUM(amount) AS total_amount FROM `donate_users` WHERE status=1 AND anon=0 AND date>1491969600 GROUP BY `member_id` ORDER BY total_amount DESC LIMIT 5
IPS\Db\Exception: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'webcom_ips.donate_users.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (1055)
#0 /usr/www/webcom/public/system/Db/Select.php(378): IPS\_Db->preparedQuery('/*IPS\\donate\\wi...', Array, true)
#1 /usr/www/webcom/public/system/Db/Select.php(440): IPS\Db\_Select->runQuery()
#2 /usr/www/webcom/public/applications/donate/widgets/donateDonations.php(130): IPS\Db\_Select->rewind()
#3 /usr/www/webcom/public/system/Widget/Widget.php(797): IPS\donate\widgets\_donateDonations->render()
#4 /usr/www/webcom/public/system/Theme/Theme.php(824) : eval()'d code(17385): IPS\_Widget->__toString()
#5 /usr/www/webcom/public/system/Theme/SandboxedTemplate.php(58): IPS\Theme\class_core_front_global->widgetContainer('sidebar', 'vertical')
#6 /usr/www/webcom/public/system/Theme/Theme.php(824) : eval()'d code(15022): IPS\Theme\_SandboxedTemplate->__call('widgetContainer', Array)
#7 /usr/www/webcom/public/system/Theme/SandboxedTemplate.php(58): IPS\Theme\class_core_front_global->sidebar('right')
#8 /usr/www/webcom/public/system/Theme/Theme.php(824) : eval()'d code(6230): IPS\Theme\_SandboxedTemplate->__call('sidebar', Array)
#9 /usr/www/webcom/public/system/Theme/SandboxedTemplate.php(58): IPS\Theme\class_core_front_global->globalTemplate('25161dcbab12e64...', '\n\n\n<div class='...', Array)
#10 /usr/www/webcom/public/system/Dispatcher/Dispatcher.php(166): IPS\Theme\_SandboxedTemplate->__call('globalTemplate', Array)
#11 /usr/www/webcom/public/system/Dispatcher/Standard.php(118): IPS\_Dispatcher->finish()
#12 /usr/www/webcom/public/system/Dispatcher/Front.php(574): IPS\Dispatcher\_Standard->finish()
#13 /usr/www/webcom/public/system/Dispatcher/Dispatcher.php(148): IPS\Dispatcher\_Front->finish()
#14 /usr/www/webcom/public/index.php(13): IPS\_Dispatcher->run()
#15 {main}

Any Ideas?

 

Edit:

Additionally, I have tried to run the query

SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

But this appears to have no effect on the error.

Edited May 1, 2019 by Tyler

[disps1004 1]

Hi Tyler

Try giving this command a go.

set global sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';