Support Forum
Support Forum
Offline
Hi!
From what you describe it sounds like you have lost your admin role in WP. The adminbar with a link to the forum shows for everyone in the last release. We have a release that only shows that to admins in Simple:Press but we have not released that yet.
If you have access to the database I would start looking into that and verify your WP roles.
Best regards,
Joakim @ Simple:Press
Offline
I've checked the table wp_usermeta and it looks all my privileges are OK
a:16:{s:13:"administrator";s:1:"1";s:18:"SPF Manage Options";s:1:"1";s:17:"SPF Manage Forums";s:1:"1";s:22:"SPF Manage User Groups";s:1:"1";s:22:"SPF Manage Permissions";s:1:"1";s:21:"SPF Manage Components";s:1:"1";s:17:"SPF Manage Admins";s:1:"1";s:16:"SPF Manage Users";s:1:"1";s:19:"SPF Manage Profiles";s:1:"1";s:18:"SPF Manage Toolbox";s:1:"1";s:18:"SPF Manage Plugins";s:1:"1";s:17:"SPF Manage Themes";s:1:"1";s:15:"SPF Manage Tags";s:1:"1";s:22:"SPF Manage Integration";b:1;s:16:"SPF Manage Polls";b:1;s:21:"SPF Manage Promotions";b:1;}
Offline
Hi!
That looks ok. Did you get things working?
Best regards,
Joakim @ Simple:Press
Offline
I've created a new administrator user in sql but I still can't access the admin, maybe it's related to the theme issue
Offline
Hi
So, you have access to WP-admin at the moment? But you can't access the forum admin? Is anything showing up in your logs, any errors?
What versions are you using? WP and SP.
In your first post you wrote that your theme was not longer supprting PHP8. Does this mean that you upgraded PHP to another version? Do you have any clue why files were missing? Maybe there are more files missing.
Best regards,
Joakim @ Simple:Press
Offline
Everything is updated and I can't access neither of them
I've checked and the hosting updated the mysql version, not the php. They changed from 5.7 to 8
Offline
Hi.
Ok, so after the update of MySQL you lost access to Wordpress-admin and Simple:Press-admin is that correct?
Best regards,
Joakim @ Simple:Press
Offline
The hosting just told me there's an error in the table wp_sfmembers. The "admin" column is a reserved keyword in mysql 8
Offline
Hi!
You are correct that the `admin` word is or has been a reserved word. We are running MySQL `8.0.23` on our servers without any issues. From what i can read the documentation says that
ADMIN; became nonreserved in 8.0.12which means that using a MySQL version later than that should solve the issue.
Could you please check your MySQL version just to verify?
Best regards,
Joakim @ Simple:Press
All RSS1 Guest(s)