Database error when sorting PM by sender

Started by Ravey76, June 23, 2022, 10:13:41 AM

Previous topic - Next topic

Ravey76

Hello everyone,

my users have brought to my attention that when trying to sort the "Personal Messages" by sender, a database error occurs. Important: This error occurs only with the "sent messages". The received messages can be sorted as desired.

I see the following error message in the error log:

http://xxxxxxx/forum/index.php?action=pm;f=sent;start=0;sort=name
/xxxxxxxxxx/htdocs/forum/Sources/PersonalMessage.php%20(Line 932)


Database error: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'XXXXXXXXXXX.mem.real_name' which is not functionally dependent on columns in GROUP BY clause;
this is incompatible with sql_mode=only_full_group_by

Does anyone have any idea what is causing this?

And: i don't have any mods installed that access the PN functionality.
My forum version: SMF 2.1.2

Thank you and best regards

Karl

Diego Andrés

Seems this happens on this site too.
I'll move this to the bugs board.

SMF Tricks - Free & Premium Responsive Themes for SMF.

Oldiesmann

What version of MySQL or MariaDB are you running? It works fine on my forum with MariaDB 10.3.34
Michael Eshom
Christian Metal Fans

Ravey76

The database version is: MySQL 5.7

I also have a second forum running, different database (also MySQL 5.7).

There I get the same error message, but slightly modified:

Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'XXXXXX.mem.real_name' which is not
functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
File: /XXXXXXXXXX/forum/Sources/PersonalMessage.php
Row: 932


Addition:

The error message is the same; only the one above appears directly when I click on "Sort" and the one from post #1 is from the error log

shawnb61

Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Advertisement: