I keep getting a JQuery pop-up in the upper left of my forum that keeps saying “Invalid Database Query”. My user account is the only one that sees this at this point.
About 6 days ago (Dec. 6th), I was using a WP plugin called “Plugins Garbage Collector” and deleted what I thought were unused tables by SP5. However, immediately after deleting those tables (whose names I don’t even remember), all my users including myself starting getting “Invalid Database Query”.
Talking with my host, I had him restore some “missing” tables from a older database backup from before WP 3.3 RC1 and before SP5 install. Once those tables were put back in, every other user on the site and forums stop receiving that error message. However, I am still seeing it. Promoting a test user to my priveliges does not show up the “Invalid Database Query” message. I’m the only one who’s still seeing it.
The tables that were “restored” are these:
– notice
– options
– ratings
– settings
– meta
– tags
Secondly, the forum’s error log still shows these messages:
| December 11, 20111:05 pm | database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
1:05 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
1:05 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
1:05 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
1:05 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=3 |
| December 11, 2011
1:05 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=3 |
| December 11, 2011
1:02 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
1:02 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
1:00 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
1:00 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:57 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:57 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:57 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:57 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:57 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:57 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:57 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:57 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:57 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:57 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:57 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:57 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:56 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:56 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:56 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:55 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:55 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:55 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:55 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:55 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:55 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:55 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:55 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:54 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:54 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:52 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:52 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:52 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:52 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:52 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:52 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:52 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:52 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:52 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:52 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:52 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:52 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:52 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:52 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:51 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
| December 11, 2011
12:51 pm |
database | file: /problem-with-post-edit-buttonome/grscgami/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 304 function: sp_pm_do_user_class error: Table ‘grscgami_cms.wp_sfadversaries’ doesn’t exist SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1 |
What can be done? Do I have to roll back my entire site and lose any new content in order to fix this or is there some simpler method?