have you visited the admin since the update?  to make sure the upgrade ran…

in your database, do you have tables sfpmthreads, sfpmmessages and sfpmrecipients? 

was there anything in the error log before you tried to roll back (normally not a good idea with db upgrades)?

a bit disturbing since we havent lost any data on the upgrade to date… 

Mr Papa said
have you visited the admin since the update?  to make sure the upgrade ran…

Yes, it’s the first thing I did before visiting the forums.

in your database, do you have tables sfpmthreads, sfpmmessages and sfpmrecipients? 

Yes, however, the messages and recipients rows appear to have been cleared out. There are 1,000+ rows for pmthreads but only 4 messages and 3 recipients, 2 of which are messages I just sent to test the system.

Any suggestions? Should I clear out the legacy pmthreads rows, or will they eventually be deleted based on my “delete old messages” setting in the SP admin? Or, if I can get a dump of these tables from a db backup, what kind of nightmare am I creating for myself by importing the lost pmmessages and pmrecipients?

was there anything in the error log before you tried to roll back

I didn’t check at the time, but see nothing during that time frame in the
 server error logs. The SP error log includes many Notices, but the only thing referencing the PM system is:

file: /simple-press/sp-api/sp-api-plugins.php
line: 501
function: filemtime
Warning | filemtime() [function.filemtime]: stat failed for wp-content/sp-resources/forum-themes/default-custom4/styles/sp-pm.css

a bit disturbing since we havent lost any data on the upgrade to date… 

Disturbing indeed.

did you have the suggested backup from before the upgrade?  would be interested to see why your single site has failed the upgrade…

at this point, if you dont have a backup, I would remove the threads, messages and recipients… that is truncate each table…

btw, looking at the warning message, if you have a previous pm css file in the theme, you should remove it… or more correctly start over if you want to customize it…  it largely should inherit stuff from your sp theme now (most but not all)…  leaving the old stuff in the pm css may cause display issues…

Mr Papa said
at this point, if you dont have a backup, I would remove the threads, messages and recipients… that is truncate each table…

Thanks, though this will also delete any new messages and threads from inboxes over the past few days, since the update. Still looking into getting the tables out of a recent db backup…

you have a previous pm css file in the theme, you should remove it…

I figured that much after seeing the overhauled inbox. Thanks again.

PS: That actually fixed a few wacky styling issues too!

Mr Papa said
remove the threads, messages and recipients… that is truncate each table…

Would that be the same as “empty” using PHP MyAdmin?

empty?  I would imagine so though I dont remember an empty button in phpmyadmin… truncate is the mysql term for removing all rows in a table…

Mr Papa said
empty?  … I dont remember an empty button in phpmyadmin…

As it turns out, I’m having to do a lot of db work via ssh since MyAdmin has been choking due to the size of our database. Any chance I might get a hint about the command for truncating tables via the CLI?

lol, really??

truncate tablename;