Support Forum

Advanced Search
Forum Scope


Forum Options

Minimum search word length is 3 characters - maximum search word length is 84 characters
Bug report: private messaging
Pro Subscribers
sp_UserOfflineSmall Offline
Mar 24, 2020 - 10:12 am


When a user composes a private message but does not add a recipient he gets a popup "Database error". The message is not saved. The window is closed and returns to the list of PM.

Also this generates an SQL error in the server logs:

Database error. WordPress You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'a \xc3\xa9t\xc3\xa9 selectionn\xc3\xa9";}' WHERE id=2250651' at line 1 pour la requ\xc3\xaate UPDATE wp_tpf_sftrack SET notification = 'a:2:{i:0;i:1;i:1;s:41:"Aucun destinataire n'a \xc3\xa9t\xc3\xa9 selectionn\xc3\xa9";}' WHERE id=2250651 faite par do_action('wp_ajax_pm-post'), WP_Hook->do_action, WP_Hook->apply_filters, sp_pm_ajax_post, require_once('/sp-resources/forum-plugins/private-messaging/ajax/sp-pm-ajax-post.php'), sp_pm_save_message, spcNotifications->message, spcDB->update, spcDB->execute, QM_DB->query,


Obviously this is not good: I would rather the user be warned that he forgot a recipient and that he can simply add the recipient and send his PM. As is today he loses his PM.

Thanks and good luck

SP Community Support
SP Moderator
sp_UserOfflineSmall Offline
Mar 25, 2020 - 4:36 pm

We're unable to reproduce this database error.  We do show a message about no recipients entered (though you do lose the message). Can you let us know what the following versions of components are?

  • Simple:Press Forums Plugin
  • WordPress
  • Simple:Press Private Messaging plugin
  • MariaDB

The section referenced in the error message  ‘a \xc3\xa9t\xc3\xa9 selectionn\xc3\xa9″;}’ seems like a partial serialized array which is weird - there might be something in the database that is corrupted.  What happens if you log in as a different user and try to send a PM without a recipient? 


Pro Subscribers
sp_UserOfflineSmall Offline
Mar 31, 2020 - 12:51 pm


Yes: different user (non admin) and same error.

  • Simple:Press Forums Plugin: 6.5.1
  • WordPress: 5.3.2
  • Simple:Press Private Messaging plugin 3.3.0
  • MariaDB: my sql 5.5.5

Also PHP 7.3.16

It's not serialised array: this is a conversion of French accents. The string is a été selectionné and it's translated in the logs like that.

If you let me know in which file the "UPDATE" request in the error message is done I will try to debug this for you.

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 649
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 618
Members: 17348
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10120
Posts: 79607