Can't Access Dashboard on wp-admin after resetting database Usermeta
-
I have reset my database using wordpress database reset plugin and selected to set all table to default (usermeta,post, etc.) except for user table only to get a return display on wp-admin as ‘sorry you are not allowed to access this page’ so I cant get to my dashboard.
I suspect that there might have been discrepancies between wp_user and wp_usermeta.
So I have:
1.deactivated plugins,
2.deactivated theme
3.checked wp-config.php for table prefix and matched the table prefix in wp_usermeta and wp_option through SQL query.
4.set user wp_capabilities to a:1:{s:13:”administrator”;b:1;} (my user_ID is set to 2 on wp_user)
5. set wp_user_level to 10.
6. reuploaded wp-admin & wp-includes from newly downloaded 4.8 ver wordpress through FTP filezilla.
7. Checked error.log which displayed the following:PHP Warning: array_keys() expects parameter 1 to be array, string given in /home/goodfoodfitness/public_html/wp-includes/class-wp-roles.php on line 126
Invalid argument supplied for foreach() in /home/goodfoodfitness/public_html/wp-includes/class-wp-roles.php on line 126
PHP Fatal error: require(): Failed opening required ‘/home/goodfoodfitness/public_html/wp-includes/load.php’ (include_path=’.:/opt/cpanel/ea-php56/root/usr/share/pear’) in /home/goodfoodfitness/public_html/wp-settings.php on line 19
PHP Warning: require(/home/goodfoodfitness/public_html/wp-includes/load.php): failed to open stream: No such file or directory in /home/goodfoodfitness/public_html/wp-settings.php on line 19
WHAT SHOULD I DO NEXT?
Since I set wp_usermeta to default and not wp_user, i think it has a lot to do around this. could it be wp_user-setting in wp_usermeta table?or wp_user-setting-time?or caching?which i have no idea how to flush through phpmyadmin since i have no access to dashboard. I have wp_revslider, wp_woocommerce and wp_wfReverseCache showing in the directory amongst the default wp_user,wp_usermeta,wp_option etc. in phpmyadmin.
helps appreciated.
Thanks.The blog I need help with is: (visible only to logged in users)
-
-
Hi agkrol,
It appears that you are referring to a site that you have on the self-host version of WordPress, which would be WordPress.org.
If you have a self-hosted site you would use the WordPress.org support which can be found here: https://wordpress.org/support/
You can find out the difference between .com and .org here: https://en.support.wordpress.com/com-vs-org/
-
Hi agkrol,
I have confirmed that: goodfoodfitness.com is hosted on GoDaddy
As such you are using the self-hosted version of WordPress.
Please contact WordPress.org support: https://wordpress.org/support/
- The topic ‘Can't Access Dashboard on wp-admin after resetting database Usermeta’ is closed to new replies.
WordPress.com Forums 