Title: Database Update Fails
Last modified: March 3, 2024

---

# Database Update Fails

 *  Resolved [andreios](https://wordpress.org/support/users/andreios/)
 * (@andreios)
 * [2 years, 2 months ago](https://wordpress.org/support/topic/database-update-fails-2/)
 * `Database backup failed on site https://example.com. Error message: Table 'USER_wp_bsearch'
   doesn't exist`

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

 *  Plugin Author [Ajay](https://wordpress.org/support/users/ajay/)
 * (@ajay)
 * [2 years, 2 months ago](https://wordpress.org/support/topic/database-update-fails-2/#post-17469940)
 * Do you still see the prompt after running the update?
 * please can you try a reinstall of the plugin.
 *  Thread Starter [andreios](https://wordpress.org/support/users/andreios/)
 * (@andreios)
 * [2 years, 2 months ago](https://wordpress.org/support/topic/database-update-fails-2/#post-17469958)
 * 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](https://wordpress.org/support/users/ajay/)
 * (@ajay)
 * [2 years, 2 months ago](https://wordpress.org/support/topic/database-update-fails-2/#post-17469968)
 * What if you change this to only _utf8mb4_?
 *  Thread Starter [andreios](https://wordpress.org/support/users/andreios/)
 * (@andreios)
 * [2 years, 2 months ago](https://wordpress.org/support/topic/database-update-fails-2/#post-17469969)
 * Wait, that’s a typo, there is no UTF8IMB4
 * I have now set it to UTF8MB4 No more error message.
 * Thanks for your help.

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

The topic ‘Database Update Fails’ is closed to new replies.

 * ![](https://ps.w.org/better-search/assets/icon-256x256.png?rev=2988729)
 * [Better Search - Relevant search results for WordPress](https://wordpress.org/plugins/better-search/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/better-search/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/better-search/)
 * [Active Topics](https://wordpress.org/support/plugin/better-search/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/better-search/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/better-search/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [andreios](https://wordpress.org/support/users/andreios/)
 * Last activity: [2 years, 2 months ago](https://wordpress.org/support/topic/database-update-fails-2/#post-17469969)
 * Status: resolved