Database Update Fails | WordPress.org

[ad_1]

Plugin Author
Ajay

(@ajay)

Do you still see the prompt after running the update?

please can you try a reinstall of the plugin.

I only see the error message above when try to update. The update button is still there.
I have deactivated reactivated the plugin. On activation I got this error in server log
AH01071: Got error 'PHP message: WordPress database error Unknown character set: 'utf8imb4' for query CREATE TABLE 6Sra5_bsearch (\n\t\t\tsearchvar VARCHAR(100) NOT NULL,\n\t\t\tcntaccess int NOT NULL,\n\t\t\tPRIMARY KEY (searchvar)\n\t\t) DEFAULT CHARACTER SET utf8imb4 made by activate_plugin, do_action('activate_better-search/better-search.php'), WP_Hook->do_action, WP_Hook->apply_filters, WebberZone\Better_Search\activate_bsearch, WebberZone\Better_Search\Admin\Activator::activation_hook, WebberZone\Better_Search\Admin\Activator::single_activate, WebberZone\Better_Search\Admin\Activator::maybe_create_table, dbDelta; PHP message: WordPress database error Unknown character set: 'utf8imb4' for query CREATE TABLE _bsearch_daily (\n\t\t\tsearchvar VARCHAR(100) NOT NULL,\n\t\t\tcntaccess int NOT NULL,\n\t\t\tdp_date date NOT NULL,\n\t\t\tPRIMARY KEY (searchvar, dp_date)\n\t\t) DEFAULT CHARACTER SET utf8imb4 made by activate_plugin, do_action('activate_better-search/better-search.php'), WP_Hook->do_action, WP_Hook->apply_filters, WebberZone\Better_Search\activate_bsearch, WebberZone\Better_Search\Admin\Activator::activation_hook, WebberZone\Better_Search\Admin\Activator::single_activate, WebberZone\Better_Search\Admin\Activator::maybe_create_table, dbDelta; PHP message: WordPress database error Table 'user_bsearch' doesn't exist for query CREATE TABLE _bsearch_backup LIKE _bsearch made by activate_plugin, do_action('activate_better-search/better-search.php'), WP_Hook->do_action, WP_Hook->apply_filters, WebberZone\Better_Search\activate_bsearch, WebberZone\Better_Search\Admin\Activator::activation_hook, WebberZone\Better_Search\Admin\Activator::single_activate, WebberZone\Better_Search\Admin\Activator::recreate_overall_table, WebberZone\Better_Search\Admin\Activator::recreate_table; PHP message: WordPress database error Table 'user._bsearch_daily' doesn't exist for query CREATE TABLE _bsearch_daily_backup LIKE _bsearch_daily made by activate_plugin, do_action('activate_better-search/better-search.php'), WP_Hook->do_action, WP_Hook->apply_filters, WebberZone\Better_Search\activate_bsearch, WebberZone\Better_Search\Admin\Activator::activation_hook, WebberZone\Better_Search\Admin\Activator::single_activate, WebberZone\Better_Search\Admin\Activator::recreate_daily_table, WebberZone\Better_Search\Admin\Activator::recreate_table', referer: https://example.com/wp-admin/plugins.php?plugin_status=search&paged=1&s=better

Obviously there is a problem with a wp-config.php setting.
define( ‘DB_CHARSET’, ‘utf8imb4’ );

Plugin Author
Ajay

(@ajay)

What if you change this to only utf8mb4?

Wait, that’s a typo, there is no UTF8IMB4

I have now set it to UTF8MB4 No more error message.

Thanks for your help.

 

This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Buy WordPress Transfer