I am not sure I can send over the database tables as it is a paid membership site and will contain sensitive data. I just uploaded the sfmessages table should I have uploaded it into an existing table?
ashley briscoe said
Hi Guys,I uploaded the sfmessages table and it has made no difference. I also enabled PM permissions for all relevant users. To answer Mr Papa’s question I installed the plugin after the upgrade because the previous version was so old it had PM’s as standard not a plugin. I still need to figure this out before I upgrade the live site.
This being an off-site ‘test’ type environment then just uploading the ‘sfmessages’ table is not going to make any difference. What you need to do to try and re-run the PM upgrade is to ‘uninstall’ (NOT deactivate) the new PM plugin to get rid of ALL data associated with it. This includes the new tables and, sadly, permission settings. It should NOT remove the old sfmessages table but double check it is still there are the uninstall in case it does as a part of general clean up. If not there – add it back into the database.
Then reactivate the PM plugin. What you are looking for is the removal of sfmessages and the creation of the new tables with the data in them.
If this does not happen then can you check your php error log because I will have to assume you have hit a hitherto unknown condition.
Do I need to rename the table before upload. The old table is sfmessages the new is sfpmmessages
No – that was the point of the exercise. By uninstalling the PM plugin it will remove the new tables. The aim is to put things back to the way they were so that you can try a proper re-upgrade of PM again.
Right I performed exactly what you asked and it kept the old table and created the new ones.
There are a lot of php errors on the site around depreciated code for the sites theme that I need to fix but I can’t see any related to the forum.
This is most disturbing. And the fact that it left the old table in place is even more strange – which still to me suggests an error…
Tell me – after you reactivated the PM plugin and ran the next page did it sem to take a long time to load? Just wondering about a timeout condition…
Do you know how to run database queries at all? Another approach would be to find out exactly what should get selected… and I can probably create a query to find out.
No much experience with DB queries but i am sure i can figure it out.
Quite the opposite it actually activates the plugin in 1-2 seconds which seems too fast
No it should activate quite fast. It would be the next admin page load that probably mattered more.
I would try this query:
SELECT DISTINCT title, message_slug FROM wp_sfmessages ORDER BY message_id WHERE to_id <> from_id';
You may need to change the table prefix (wp_) if you changed to from the default at set up time,
You can run this via phpMyAdmin. It is a simple select and really we just need to find out if it returns any data rows – and if so – how many.
Whoops. Sorry – should not have that single quote at the end. Copy and paste error. The semi-colon is optional.
Unfortunately still getting errors even without the semi colon:
SQL query: 
SELECT DISTINCT title, message_slug FROM wp_sfmessages ORDER BY message_id WHERE to_id <> from_id
LIMIT 0, 25
MySQL said:
From the error message it looks like the angle brackets are getting converted to html entities and thus mangled as far as SQL goes. You probably need to type it in not copy and paste.
Hi I typed it in and it has made no difference. Is there anyway I can just rename the old table and import the data?
The plugin is not seeing the table at all, I am not sure where to go from here. I need to upgrade the live forum asap but don’t want users to loose there PM’s.
This is a far from ideal situation.
It was not supposed to make any difference. The purpose was as explained in post 24 above – to find out of ot returned any data and, if so, how many rows of data…