PM database error

[Sir Osis of Liver]

Anyone know what this error means?

https://weaponsguild.com/forum/index.php?action=pm;f=sent
Database Error: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'weaponsg_jestism.pm.id_pm' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT MAX(pm.id_pm) AS id_pm, pm.id_pm_head
FROM hbf_personal_messages AS pm
WHERE pm.id_member_from = 15493
AND pm.deleted_by_sender = 0
GROUP BY pm.id_pm_head
ORDER BY pm.id_pm ASC
LIMIT 0, 15
Apply Filter: Only show the errors from this file
File: /home/weaponsg/public_html/forum/Sources/PersonalMessage.php
Line: 700

Very busy forum, error doesn't happen for days, then there'll be several.  PMs seem to be working correctly.

Version Information:
Forum version: SMF 2.0.17 (more detailed)
Current SMF version: SMF 2.0.17
GD version: bundled (2.1.0 compatible)
Database Server: MySQL
MySQL version: 5.7.33
PHP: 7.3.26
Server version: Apache

[shawnb61]

Yes, that's another mysql strict mode restriction.

First thing I'd try is to add the following to Settings.php, which should disable strict mode:

Code Select Expand

$mysql_set_mode = true;


See also:
https://www.simplemachines.org/community/index.php?topic=576212.0

[Sir Osis of Liver]

Will see what it does.  Thanks.

[showngo]

Thanks      Learning every day.