Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Template file not found
Avatar
Joakim (Simple:Press)
Sweden
Admin
sp_UserOfflineSmall Offline
Oct 12, 2023 - 11:31 am

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

Avatar
Joan Alamo Vallejo
Member
Free Members
sp_UserOfflineSmall Offline
Oct 12, 2023 - 11:34 am

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;}

Avatar
Joakim (Simple:Press)
Sweden
Admin
sp_UserOfflineSmall Offline
Oct 16, 2023 - 4:24 pm

Hi!

That looks ok. Did you get things working?

Best regards,
Joakim @ Simple:Press

Avatar
Joan Alamo Vallejo
Member
Free Members
sp_UserOfflineSmall Offline
Oct 16, 2023 - 6:57 pm

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

Avatar
Joakim (Simple:Press)
Sweden
Admin
sp_UserOfflineSmall Offline
Oct 17, 2023 - 7:28 am

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

Avatar
Joan Alamo Vallejo
Member
Free Members
sp_UserOfflineSmall Offline
Oct 18, 2023 - 6:41 am

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

Avatar
Joakim (Simple:Press)
Sweden
Admin
sp_UserOfflineSmall Offline
Oct 18, 2023 - 9:03 am

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

Avatar
Joan Alamo Vallejo
Member
Free Members
sp_UserOfflineSmall Offline
Oct 18, 2023 - 7:36 pm

Correct

Avatar
Joan Alamo Vallejo
Member
Free Members
sp_UserOfflineSmall Offline
Oct 18, 2023 - 8:06 pm

The hosting just told me there's an error in the table wp_sfmembers. The "admin" column is a reserved keyword in mysql 8

Avatar
Joakim (Simple:Press)
Sweden
Admin
sp_UserOfflineSmall Offline
Oct 19, 2023 - 8:31 am

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.12

which 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

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 649
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 618
Members: 17348
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10120
Posts: 79605