Support Forum

First of all - my apologies for the delay. 

If, as I assume, this was updated from 5.5.2 then the changes do not go anywhere near user capabilities or admin data. In fact, with the simple exception of updating the version record there were no database changes at all in the upgrade. Which is a worry as to what might have changed your user data because it wasn't SP...

Let's perhaps check what you can do first. Can you go to your WordPress Admin > Users > Your Profile. At the very bottom of the display you should find a section headed 'Additional Capabilities'. Is anything listed on the right?

And the second question would be - do you know how to change data directly in your database just in case we need to do things that way?

And finally - is your forum public so I could visit it as a non-registered user and of so can I have a link to the page?

Well we can set you up as a forum admin (and WordPress Administrator) by a simple database update but for me the important question is why was this data lost. This is essentially WordPress data which, as I said, we do not change other than through that one place in the admin UI. So the concern is what did change it and why.

OK - for the database change you need to know your WordPress User ID.

The table you need to edit is the WordPress table 'usermeta' so if your table prefix is the default you will change 'wp_usermeta'.

You need to locate the row in the table that matches your user ID (for the user_id column) and where the meta_key column is set as 'wp_capabilities'. If your table prefix is NOT wp_ then it will be stored with your own prefix.

You are going to change the data in the meta_value column to the following:

a:17:{s:13:"administrator";s:1:"1";s:18:"SPF Manage Options";b:1;s:17:"SPF Manage Forums";b:1;s:22:"SPF Manage User Groups";b:1;s:22:"SPF Manage Permissions";b:1;s:21:"SPF Manage Components";b:1;s:15:"SPF Manage Tags";b:1;s:16:"SPF Manage Users";b:1;s:19:"SPF Manage Profiles";b:1;s:17:"SPF Manage Admins";b:1;s:18:"SPF Manage Toolbox";b:1;s:24:"SPF Manage Configuration";s:1:"1";s:18:"SPF Manage Plugins";b:1;s:17:"SPF Manage Themes";b:1;s:22:"SPF Manage Integration";b:1;s:16:"SPF Manage Polls";b:1;s:13:"SPF Manage PM";b:1;}

Use the 'Raw Code' button which will open a popup from which you can copy and then paste into the DB field. It is vitally important that all quotes etc., are correct.

I am going to say the obvious but I would always make a full database backup before doing this just in case something goes wrong and you need to restore. But assuming all is well this will set you up as a WP administrator and a Simple:Press Admin, From there you can use the UI to re-establish your other admins.

Hope it goes well. More importantly, I hope that whatever caused this data to be lost does not happen again