Where to find table wp_options under phpMyAdmin?

Resolved reachingout
(@reachingout)

6 years, 3 months ago
Hi,
Where can I find wp_options under phpMyAdmin?
I am using bluehost.
I get a
“There has been a critical error on your website.
Learn more about debugging in WordPress” – error.

So I want to deactivate plugins. This error happenden after a restoration with Updraftplus to an earlier date.

According to manual:
“Use phpMyAdmin to deactivate all plugins.
In the table wp_options, under the option_name column (field) find the active_plugins row
Change the option_value field to: a:0:{}”
- This topic was modified 6 years, 3 months ago by reachingout.
- This topic was modified 6 years, 3 months ago by reachingout.

Viewing 14 replies - 1 through 14 (of 14 total)

Moderator Yui
(@fierevere)

永子

6 years, 3 months ago

You can just rename your
/wp-content/plugins folder
to something like “plugins2”
It will disable all plugins without editing mysql tables, which is less safe, especially if you have troubles using PHPMyAdmin

Thread Starter reachingout
(@reachingout)

6 years, 3 months ago

I tried to rename my Plugins folder before, but I still have the same error.
So I am trying to access wp_options.
Maybe the plugins are not the issue…

Moderator Steven Stern (sterndata)
(@sterndata)

Volunteer Forum Moderator

6 years, 3 months ago

See if this helps: https://my.bluehost.com/hosting/help/deactivate_plugins_themes_wordpress

See https://i.imgur.com/tqzR83t.png

See https://i.imgur.com/qnXXJU9.png
Thread Starter reachingout
(@reachingout)

6 years, 3 months ago
Ok, I did set option_value=a:0:{}

But my issue from debugging seems to be about:
Warning: require_once(/home3/botasoci/public_html/wp-admin/includes/class-wp-site-health.php): failed to open stream: No such file or directory in /home3/botasoci/public_html/wp-settings.php on line 370

wp-settings.php:
…
// Create an instance of WP_Site_Health so that Cron events may fire.
if ( ! class_exists( ‘WP_Site_Health’ ) ) {
require_once ABSPATH . ‘wp-admin/includes/class-wp-site-health.php’;
}
WP_Site_Health::get_instance();
…
- This reply was modified 6 years, 3 months ago by reachingout.
- This reply was modified 6 years, 3 months ago by reachingout.
- This reply was modified 6 years, 3 months ago by reachingout.
- This reply was modified 6 years, 3 months ago by reachingout.
Moderator Steven Stern (sterndata)
(@sterndata)

Volunteer Forum Moderator

6 years, 3 months ago

Is the file wp-admin/includes/class-wp-site-health.php there?

Thread Starter reachingout
(@reachingout)

6 years, 3 months ago

Yes, it is.

Moderator Steven Stern (sterndata)
(@sterndata)

Volunteer Forum Moderator

6 years, 3 months ago

Please look, via FTP or the file manager app in your hosting control panel, at that directory. Does this file have the same permissions and ownership as the rest of them?

Thread Starter reachingout
(@reachingout)

6 years, 3 months ago

Or actually, my file is under:
/public_html/wp-content/wp-admin/includes/class-wp-site-health.php

But my debug.log says:
/public_html/wp-admin/includes/class-wp-site-health.php

Moderator Steven Stern (sterndata)
(@sterndata)

Volunteer Forum Moderator

6 years, 3 months ago

Your file is in the wrong place! Did you manually copy WP files onto your site at some point?

>> This error happenden after a restoration with Updraftplus to an earlier date. <<
I think you did that incorrectly and that’s what caused this.

On the dashboard, go to UPDATES and click the buttton to reinstall WordPress.

Thread Starter reachingout
(@reachingout)

6 years, 3 months ago

I did not copy any files.
I think it crashed somehow during the Updraftplus restoration.

I can not access the WordPress dashboard…do not know why, I come to a page
about “WordPress Tools API Reference”

Thread Starter reachingout
(@reachingout)

6 years, 3 months ago

I tried to come the file to
/public_html/wp-admin/includes
but it does not seem to work.

Moderator Steven Stern (sterndata)
(@sterndata)

Volunteer Forum Moderator

6 years, 3 months ago

Maybe the updraft folks have a good way to recover from this. I recommend asking at https://wordpress.org/support/plugin/updraftplus/#new-post so the plugin’s developers and support community can help you with this.

Thread Starter reachingout
(@reachingout)

6 years, 3 months ago

OK, thanks.
The damage is not so big even if it would not work.

Thread Starter reachingout
(@reachingout)

6 years, 2 months ago

Just closing this 🙂