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
private messages
Avatar
garwar
Member
Free Members
sp_UserOfflineSmall Offline
Feb 18, 2012 - 5:47 pm

when i setup or click on  private messages inbox i get a Invalid database query

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Feb 18, 2012 - 5:49 pm

what is the message? if not displayed on the screen see forum - toolbox - error log

Avatar
garwar
Member
Free Members
sp_UserOfflineSmall Offline
Feb 18, 2012 - 6:01 pm

displayed on the screen when i click on the inbox  forum

 

file: /problem-with-post-edit-buttonome/ddownun1/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php line: 320 function: sp_pm_do_user_class error: Table 'ddownun1_WP.wp_sfadversaries' doesn't exist

SELECT adversary_id FROM wp_sfadversaries WHERE user_id=1

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Feb 18, 2012 - 6:05 pm

so does your db not have a table called wp_sfadversaries?

this is sp 5, right? and fresh install or upgrade?

Avatar
garwar
Member
Free Members
sp_UserOfflineSmall Offline
Feb 18, 2012 - 6:13 pm

yes i have sp 5 upgrade it today or to fix would i need to add the sql file if you can make one i can Import in to the database

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Feb 18, 2012 - 6:16 pm

did you see any errors when you activated the pm plugin? or any more in that error log?

appears for some reason that during the plugin activation it failed to create that table for you...

do you know how to create a table in your db? you can find the particulars in the sp-pm-install.php file in the private messaging plugin...

Avatar
garwar
Member
Free Members
sp_UserOfflineSmall Offline
Feb 18, 2012 - 6:31 pm

sorry no i don't no how to do db  table

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Feb 18, 2012 - 6:56 pm

well, that is going to make it hard...  open up the spFunctions.php file in the sp theme you are using and try adding the following code at the top:

define('SPPMADVERSARIES',     SF_PREFIX.'sfadversaries');
$sql = "
    CREATE TABLE IF NOT EXISTS ".SPPMADVERSARIES." (
        user_id bigint(20) NOT NULL,
        adversary_id bigint(20) NOT NULL,
        PRIMARY KEY  (user_id, adversary_id)
    ) ENGINE=MyISAM ".spdb_charset().";";
spdb_query($sql);

then visit your forum once...  and remove the code...

and see if the table gets created...  this is, of course, completely untested...

Avatar
garwar
Member
Free Members
sp_UserOfflineSmall Offline
Feb 19, 2012 - 2:06 am

did it with no luck

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Feb 19, 2012 - 2:12 am

well you are going to have to figure out how to get at your db then and create that table...  any self respecting host will give you access to phpmyadimin or other equivalent tool to manage your databases...

figure out how you can access your db and then we can proceed...

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: 17362
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625