PayPal Donation Extension

General error in donor's list - PayPal Donation Extension

General error in donor's list

by Lord Phobos » Wed Jun 12, 2024 3:44 pm

Hi

I'm setupping this extension on a test board.

It seems to work fine (I didn't test the actual donation this far).

But when I click on the "donors" list icon in the top, I get a general error page with this:

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()
Can you help me?

Thanks in advance.
Lord Phobos
Registered User
Posts: 934
Joined: Tue May 18, 2004 11:41 pm

Re: General error in donor's list

by Lord Phobos » Wed Jun 12, 2024 4:26 pm

Also, when I click to donate, I see:

Image

What is this "uid_2_1718209446" and how can I make it disappear?

Thanks
Lord Phobos
Registered User
Posts: 934
Joined: Tue May 18, 2004 11:41 pm

Re: General error in donor's list

by Skouat » Thu Jun 13, 2024 10:22 pm

Hi,
Lord Phobos wrote: But when I click on the "donors" list icon in the top, I get a general error page with this:
Can you try this? https://www.phpbb.com/customise/db/exte ... 71#p858571
Lord Phobos wrote: What is this "uid_2_1718209446" and how can I make it disappear?
This is a mandatory information for PPDE. It ensures that the extension can identify the donor.
Skouat
Code Contributor
Posts: 1054
Joined: Mon Mar 10, 2008 5:30 pm
Location: France

Re: General error in donor's list

by Lord Phobos » Thu Jun 13, 2024 10:32 pm

This info cannot be hidden from users?
Lord Phobos
Registered User
Posts: 934
Joined: Tue May 18, 2004 11:41 pm

Re: General error in donor's list

by Lord Phobos » Thu Jun 13, 2024 10:37 pm

Skouat wrote:Hi,
Lord Phobos wrote: But when I click on the "donors" list icon in the top, I get a general error page with this:
Can you try this? https://www.phpbb.com/customise/db/exte ... 71#p858571
Lord Phobos wrote: What is this "uid_2_1718209446" and how can I make it disappear?
This is a mandatory information for PPDE. It ensures that the extension can identify the donor.
Fixed, thanks.
Lord Phobos
Registered User
Posts: 934
Joined: Tue May 18, 2004 11:41 pm