Support Forum
try changing the reference error code (the line) to:
sp_pm_delete_message($message->message_id, $message->thread_id);
Visit Cruise Talk Central and Mr Papa's World
nvm, seems I can't pm a txt file, here is a snippet of the errors, it goes on for quite a bit
[Fri Dec 19 15:33:58 2014] [error] [] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 for query SELECT attachment_id FROM rufus_sfpmmessages WHERE attachment_id IS NOT NULL AND attachment_id != 0 AND message_id=3 AND user_id= /* From [thehomesteadingboards.com/wp-cron.php?doing_wp_cron=1419003237.2353498935699462890625] in [/wp-content/plugins/simple-press/sp-api/sp-api-wpdb.php:172] */ made by do_action_ref_array, call_user_func_array, sp_pm_remove_pms, sp_pm_do_remove_pms, sp_pm_delete_message, spdb_select
[Fri Dec 19 15:33:58 2014] [error] [] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 for query DELETE FROM rufus_sfpmrecipients WHERE thread_id=3 AND message_id=3 AND user_id= /* From [thehomesteadingboards.com/wp-cron.php?doing_wp_cron=1419003237.2353498935699462890625] in [/wp-content/plugins/simple-press/sp-api/sp-api-wpdb.php:209] */ made by do_action_ref_array, call_user_func_array, sp_pm_remove_pms, sp_pm_do_remove_pms, sp_pm_delete_message, spdb_query
[Fri Dec 19 15:33:58 2014] [error] [] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 for query SELECT attachment_id FROM rufus_sfpmmessages WHERE attachment_id IS NOT NULL AND attachment_id != 0 AND message_id=4 AND user_id= /* From [thehomesteadingboards.com/wp-cron.php?doing_wp_cron=1419003237.2353498935699462890625] in [/wp-content/plugins/simple-press/sp-api/sp-api-wpdb.php:172] */ made by do_action_ref_array, call_user_func_array, sp_pm_remove_pms, sp_pm_do_remove_pms, sp_pm_delete_message, spdb_select
[Fri Dec 19 15:33:58 2014] [error] [] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 for query DELETE FROM rufus_sfpmrecipients WHERE thread_id=3 AND message_id=4 AND user_id= /* From [thehomesteadingboards.com/wp-cron.php?doing_wp_cron=1419003237.2353498935699462890625] in [/plugins/simple-press/sp-api/sp-api-wpdb.php:209] */ made by do_action_ref_array, call_user_func_array, sp_pm_remove_pms, sp_pm_do_remove_pms, sp_pm_delete_message, spdb_query
[Fri Dec 19 15:33:58 2014] [error] [] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 for query SELECT attachment_id FROM rufus_sfpmmessages WHERE attachment_id IS NOT NULL AND attachment_id != 0 AND message_id=5 AND user_id= /* From [thehomesteadingboards.com/wp-cron.php?doing_wp_cron=1419003237.2353498935699462890625] in [/wp-content/plugins/simple-press/sp-api/sp-api-wpdb.php:172] */ made by do_action_ref_array, call_user_func_array, sp_pm_remove_pms, sp_pm_do_remove_pms, sp_pm_delete_message, spdb_select
[Fri Dec 19 15:33:58 2014] [error] [c] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 for query DELETE FROM rufus_sfpmrecipients WHERE thread_id=3 AND message_id=5 AND user_id= /* From [thehomesteadingboards.com/wp-cron.php?doing_wp_cron=1419003237.2353498935699462890625] in [/wp-content/plugins/simple-press/sp-api/sp-api-wpdb.php:209] */ made by do_action_ref_array, call_user_func_array, sp_pm_remove_pms, sp_pm_do_remove_pms, sp_pm_delete_message, spdb_query
yes, it was fixed... and this is something different... appears related still to pms, but not the same thing...
will have to investigate what might be going on...
Visit Cruise Talk Central and Mr Papa's World
yeah... see the issue now... but no clue how to fix quickly... gonna have to take some thought...
it was broke when we added the attachment removing stuff... and not seen before because of the previously fixed error keeping auto deletion of pms from working...
so good news, doesnt affect use of the pm system... only affects the auto deletion of pms after some period of time...
ticket open...
Visit Cruise Talk Central and Mr Papa's World