So the key is what has happened to your users? If you look in the database do you have users ion the WP users table and the SP sfmembers table?

The loss of users is not my top priority now. My priority is to fix the error with the PM’s. when I activate the plugin still gives me the same error, “failed to create the tables in the database”
I have contacted my server and according to the my database is correct.
So: I can create it manually I table in the database?
If so: How I can do and what are the parameters?
¿I can create a backup, uninstall the forum, then reinstall and load the backup?
What do you suggest I use?
thanks
Translated by Google

check with your host… does your mysql user have the create table permission??  any decent host would allow so, but some are low end…

the backup must have been made before the upgrade as we recommend…

if you look in the private messaging plugin, file sp-pm-install.php you will see the structure needed to create the db tables… if you have phpmyadmin or other access to the db, you should be able to create…

Use Bluehost server and I have permission to create tables, I have ALTER priority. Besides simple-press, I have other installations requiring creation of tables.
Then understand that the tables are created:

SPPMMESSAGES

SFMEMBERS

SPPMADVERSARIES

I leave one?

depends. if upgrade, then sfmessages (diff between actual name and #define) and sfmembers will already exist… sfadverseraries will be the only new table created…

The tables I need (I see that do not exist in the database) are SPPMMESSAGES and SPPMADVERSARIES. But I am not able to complete all data manually asking me, Structure, Documentation, Type, Length / Values ​​* …
You can guide me?

so your host does not have ALTER permissions on your db user?? that is what is failing…

and you did not say if upgrade or new install…  suspect latter since they would already exist for upgrade…

look in file wp-content/sp-resources/forum-plugins/sp-pm-install.php for the specifics on the db tables needed…

My installation is an upgrade from 4.4.5 to 5 beta. Everything worked fine until an update of the PM’s plugin error occurs. In the area of ​​administration appeared to duplicate the PM’s plugins. Then delete the pluguin from filezilla. I went up again and since then I have this error. That’s why we do not think it ALTER permission problems. I have other plugins that are not simple-press, creating tables without problems.

well the sfmessages existed long before 5.0… for private messaging the only new table is the sfadversaries…  same for sfmembers… in fact no way your forum could have worked without sfmembers previously…

post #5 seems to indicate you think those three tables are missing… did you actually look in the database?  you error message only indicates the sfadversaries table is missing…

if you uploaded stuff with filezilla, might be a corrupt file issue too – its notorious for failing on large files or when doing numerous ones…  but it wont cause a db error…

so to remove teh error you need to manually create that table in your db…  look in the pm plugin install file for the specifics on that table…

Well, Uninstall the plugin and created the table in the database. or install the plugin and created the table in the database???

sorry, not following your last…

you should be able to manually create the table in the db using phpmyadmin or whatever tool your host gives you for accessing the db…

Mr Papa said

sorry, not following your last…

you should be able to manually create the table in the db using phpmyadmin or whatever tool your host gives you for accessing the db…

 

Yes, I understand that. But I ask, first I installed the plugin and then do the table, or make the table first and then install the plugin

I thought you already had the plugin activated? dont uninstall as that will remove your data…

you should be able to just go create the table in the db and it should start working without that error.

Error log

public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 320
function: sp_pm_do_user_class
error: Table ‘xxx_xxxxx.xxxxxxxx_sfadversaries‘ doesn’t exist

SELECT adversary_id FROM xxxxxxx_sfadversaries WHERE user_id=1

But in the sp-pm-instal.php is SPPMADVERSARIES. Which is correct, I do not understand.