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

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

so does your db not have a table called wp_sfadversaries?

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

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

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…

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

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…

did it with no luck

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…

hey, grab the new version of the pm plugin and see if it helps correct your issue…

I can get into phpmyadimin and i will try the new one  woohoo it works

good news.

I am running the theme black-gold but when you look at the pm messages it hard to see the word can i change it to match the color of the theme if so how

I would copy the css file in private-messaing/resources/css to your sp theme (you do have your own, right?)… and then edit that to change the color to what you want…

#spMainContainer #spPmThreadList

and

#spMainContainer #spPmMessageList

or other to your liking…