Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
plugins-topic
PM PHP error
Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
Dec 9, 2014 - 1:05 pm

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

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Dec 9, 2014 - 1:12 pm

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

andy-signature.png
YELLOW
SWORDFISH
Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
Dec 9, 2014 - 1:19 pm

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

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Dec 9, 2014 - 3:14 pm

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

andy-signature.png
YELLOW
SWORDFISH
Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Dec 10, 2014 - 9:16 pm

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

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

Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
Dec 19, 2014 - 12:50 pm

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 

Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
Dec 19, 2014 - 12:58 pm

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

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Dec 19, 2014 - 1:08 pm

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...

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Dec 19, 2014 - 1:33 pm

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...

Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
Dec 19, 2014 - 1:39 pm

okay, thank-you

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17363
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625