Personal Messages Error

[WantSome]

Hello All!

SMF 2.0.17

I've been having quite a lot of issues recently.  It was recommended in one of my old support topics that I should do a fresh files install which I finally did today. Everything seemed to go smoothly, with just the personal messages still causing a problem.  To be clear this issue has been around for a while, but has not been fixed by the fresh install today.

Issue 1:  Unable to access sent messages:
When anyone goes to see their sent items, they get this error

Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'wnsecmxs_smf1.pm.id_pm' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
File: /home/wnsecmxs/public_html/forum/Sources/PersonalMessage.php
Line: 700

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.17 while your database is at version 2.0. The above error might possibly go away if you execute the latest version of upgrade.php.

Issue 2:  Unable to sort inbox by sender
It's the basically the same error

Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'wnsecmxs_smf1.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: /home/wnsecmxs/public_html/forum/Sources/PersonalMessage.php
Line: 700

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.17 while your database is at version 2.0. The above error might possibly go away if you execute the latest version of upgrade.php.

Now, sent items are clearly sending because people are receiving PMs.  Also, when arranging one's inbox by conversation, one's sent items appear within the topic/thread (except the latest sent item, which is only visible in the thread when someone replies).

Any help appreciated.

WS

[efk]

What is your PHP version? And do you have mods installed related with PMs?

[shawnb61]

I believe this is caused by your version of mysql having some strict mode defaults. 

You can get around this by adding this line to your Settings.php file and trying again:

Code Select Expand

$mysql_set_mode = true;

Try that & let us know if it works.

[WantSome]

Awesome, thank you that piece of code in the settings.php seemed to work.