Sorry, you are not allowed to access this page.
sorry you are not allowed to access this page. admin wordpress due to database
InnoDB doesnot support optimized, repair
| Method | Result |
| restored old database user tables (problem with user meta) | worked (not recommended) but after fewdays again |
| updated latest php version | not worked |
| deactivated themes & plugins | not worked |
| server error log | no errors |
| changed role to editor | worked |
| Activate a Default Theme | not worked |
| copy old database usersmeta table | worked not recommended |
| copied database connected newly installed wordpress install | not worked |
| deleted users and users meta and added working old backup | dashboard missed, plugin theme doesn’t exit message. Sorry, you are not allowed to access this page.
|
| Clean user meta data 0 orphaned user meta data deleted |
|
| added users & user meta from fresh install | not worked |
| copied options table from old database | worked |
wp users meta table corrupted solutions
innodb doesn’t support repair or optimize tables.
or WordPress sites, the recommended charset is utf8mb4 and the recommended collation is utf8mb4_unicode_ci
1st time: restored old backup
2nd time: upgraded php no luck
change plugins & themes not worked
wp debug true
file permissions
https://sarkariresultz.in/wp-admin/
other users able to login ..
changed to role to editor from other user login worked.
again changing role to administrator same problem you are not allowed to access.
3rd step by phpmyadmin
restoring administrator values in phpmyadmin mysql database
a:1:{s:13:”administrator”;s:1:”1″;} Administrator privileges
as editor a:1:{s:6:”editor”;b:1;} changed to role admin from other admin a:1:{s:13:”administrator”;b:1;}
a:2:{s:13:”administrator”;b:1;s:13:”bbp_keymaster”;b:1;}
a:1:{s:13:”editor”;b:1;} user2
a:1:{s:13:”administrator”;b:1;} Administrator privileges for other admin
creating new admin also not working
renamed themes & plugins
file permission set
no htacess its nginx
problem
plugin deactivation
added analytics code theme
your site’s core code or in a theme or plugin may not match what’s in your database.
Activate a Default Theme by phypmyadmin
a:2:{s:13:”administrator”;b:1;s:13:”bbp_keymaster”;b:1;}
Look for Changes in Your wp-config.php File
Upgrade to the latest version of php
NO error logs in nignx file
php -v
PHP 7.4.3
made changes define
WP Reset quickly resets the site’s database to the default installation values without modifying any files. It deletes all customizations and content, or just chosen parts like theme settings.