SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

PM database error

Started by Sir Osis of Liver, January 28, 2021, 04:37:38 PM

Previous topic - Next topic

Sir Osis of Liver

Anyone know what this error means?;f=sent
Database Error: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column '' 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
     She is happy where she lies
     With the dust upon her eyes.


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:
$mysql_set_mode = true;

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

Sir Osis of Liver

Will see what it does.  Thanks.
     She is happy where she lies
     With the dust upon her eyes.


Thanks      Learning every day.