Support Forum
Support Forum
Offline
Before you begin. I beg your pardon for so many reports, sorry.
Do not know why all my posts appear as posted by guest and now I have to reassign themone at a time. There is the possibility of reassigning the fastest way?
And also do not know why, in the section of users do not see any, just me.
In the options I have not enabled automatic removal of users.
In addition, I wanted to remember that the plugin is giving me the error MP
Translated by Google
| ate | Type | Description |
|---|---|---|
| 14 febrero 2012
08:11 |
database | file: /problem-with-post-edit-buttonome5/masalla1/public_html/wp-content/sp-resources/forum-plugins/private-messaging/sp-pm-plugin.php
line: 151 function: sp_pm_do_upgrade_check error: Table 'masalla1_wrd2.patriblog_sfmessages' doesn't exist ALTER TABLE patriblog_sfmessages ADD KEY message_status_idx (message_status) |
Offline
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?
 |
YELLOW
SWORDFISH
|
Offline
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
Offline
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...
Visit Cruise Talk Central and Mr Papa's World
Offline
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?
Offline
depends. if upgrade, then sfmessages (diff between actual name and #define) and sfmembers will already exist... sfadverseraries will be the only new table created...
Visit Cruise Talk Central and Mr Papa's World
Offline
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?
Offline
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...
Visit Cruise Talk Central and Mr Papa's World
Offline
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.
Offline
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...
Visit Cruise Talk Central and Mr Papa's World
All RSS1 Guest(s)