Whenever I follow an external hyperlink to an item or post in our forum I briefly get an “Invalid Database Query” message (see image attached). This doesn’t appear to have any adverse affect and everything seems to working OK and doesn’t happen with links within the forum but it is a little annoying. Any ideas as to what it might be?
what is the error? forum – toolbox – error log
my guess is you updated to 5.3.1 but have not updated the required plugins yet… or vice versa…
All plug-ins are up to date. Sorry, didn’t think to check the error log… here is the entry following the message..
[22-Sep-2013 07:17:52 UTC] WordPress database error Table ‘swanseaw_sw2012.ii23313696_sfbuddies’ doesn’t exist for query SELECT buddy_id FROM ii23313696_sfbuddies WHERE user_id=57 made by require(‘wp-blog-header.php’), wp, WP->main, do_action_ref_array, call_user_func_array, sp_is_forum_page, sp_load_current_user, sp_get_user, spUser->__construct, do_action_ref_array, call_user_func_array, sp_pm_add_to_user_class, spdb_select
[22-Sep-2013 07:17:52 UTC] WordPress database error Table ‘swanseaw_sw2012.ii23313696_sfbuddies’ doesn’t exist for query SELECT buddy_id FROM ii23313696_sfbuddies WHERE user_id=76 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/fitness-wp/page-fullwidth.php’), the_content, apply_filters(‘the_content’), call_user_func_array, sp_render_forum, sp_process_template, sp_load_template, include(‘/sp-resources/forum-themes/default/templates/spTopicView.php’), sp_this_topic, spTopicView->__construct, spTopicView->sp_topicview_query, sp_get_user, spUser->__construct, do_action_ref_array, call_user_func_array, sp_pm_add_to_user_class, spdb_select
[22-Sep-2013 07:17:52 UTC] PHP Notice: Trying to get property of non-object
Understood. One or two questions before we decide how to resolve it…
Is this a recent and newish installation of Simple:Press and if so, has the private messaging system been used?
And… do you know how to work with your database in tools like phpMyAdmin if I gave you a sql script to run?
Not a new installation of Simple:Press but an new implementation of the private messaging plug-in.
I’ve used phpMyAdmin for minor stuff and restoring the database from a backup and I can find the SQL tab for running SQL query but that’s my knowledge right there in one line 
The quickest fix is to uninstall the PM plugin and then reactivate it. But that will remove any current PMs from the database. Let me know if this is not a desirable fix and I can work up a simple script for you.
That’s right. Uninstall removes the sub-system – deactivate just turns it off.
There were two or three days when the release we made of SP failed to upgrade to create that new table which was quickly corrected. I assume this was the version you downloaded and installed. So – providing you are using the latest (2.0.4 as of yesterday) then uninstalling and then activating should run the install script for you.
Ah, yes, uninstalled and re-activated and it’s gone… many thanks.. great help as always
Just glad we could do it the easy way. And I learned an important lesson from that little error 