Support Forum

PM PHP error

KV kvr28
kvr28
Member

I am seeing these in my error log, any suggestions?

[Tue Dec 09 15:33:40 2014] [error] [] PHP Fatal error: Call to undefined function sp_pm_delete() in /wp-content/sp-resources/forum-plugins/private-messaging/library/sp-pm-components.php on line 216

12 Answers

New Answer

YS Yellow Swordfish
Yellow Swordfish
Member

Now that one is odd and might be a bug.
Let me investigate and look at the function history…

KV kvr28
kvr28
Member

this is in the server error log and not the sp error log by the way

YS Yellow Swordfish
Yellow Swordfish
Member

Looks like a problem our end. It will be checked out ASAP

MP Mr Papa
Mr Papa
Member

try changing the reference error code (the line) to:

sp_pm_delete_message($message->message_id, $message->thread_id);

KV kvr28
kvr28
Member

was this fixed in the new update? I can’t remember if pm’s were updated or not. I totally forgot about this issue until I just checked my error log, I am going to pm a copy of it to you to look at 

KV kvr28
kvr28
Member

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

MP Mr Papa
Mr Papa
Member

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…

MP Mr Papa
Mr Papa
Member

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…