phpBB • Free and Open Source Forum Software

Code: Select all

SQL ERROR [ mysqli ]

Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'Sql1658823_2.txn.payment_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1055]

SQL

SELECT txn.user_id, txn.mc_currency, MAX(txn.transaction_id) AS max_txn_id, SUM(txn.mc_gross) AS amount, MAX(u.username) FROM (phpbb_ppde_txn_log txn) LEFT JOIN phpbb_users u ON (u.user_id = txn.user_id) WHERE txn.user_id <> 1 AND txn.payment_status = 'Completed' AND txn.test_ipn = 0 GROUP BY txn.user_id, txn.mc_currency ORDER BY txn.payment_date DESC LIMIT 50

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1031
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 211
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/mysql_base.php
LINE: 45
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 296
CALL: phpbb\db\driver\mysql_base->_sql_query_limit()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 345
CALL: phpbb\db\driver\driver->sql_query_limit()

FILE: [ROOT]/ext/skouat/ppde/entity/main.php
LINE: 432
CALL: phpbb\db\driver\factory->sql_query_limit()

FILE: [ROOT]/ext/skouat/ppde/entity/main.php
LINE: 407
CALL: skouat\ppde\entity\main->limit_query()

FILE: [ROOT]/ext/skouat/ppde/controller/main_donor_list.php
LINE: 117
CALL: skouat\ppde\entity\main->get_data()

FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php
LINE: 151
CALL: skouat\ppde\controller\main_donor_list->handle()

FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php
LINE: 68
CALL: Symfony\Component\HttpKernel\HttpKernel->handleRaw()

FILE: [ROOT]/app.php
LINE: 35
CALL: Symfony\Component\HttpKernel\HttpKernel->handle()