• Resolved andreios

    (@andreios)


    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

    (@ajay)

    Do you still see the prompt after running the update?

    please can you try a reinstall of the plugin.

    Thread Starter andreios

    (@andreios)

    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?

    Thread Starter andreios

    (@andreios)

    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.