Seopress issue with database

  • Resolved d009

    (@d009)


    8 months, 1 week ago

    Hi, I have the page still in dev mode, in my error_log file I found the following problems repeated uncountable times. I noticed that there is nothing about seopress in my database. Before I never encounter this issue. I can see it from at least the 12/03. I removed seopress and reinstalled it but the issue comes back.

    Do you know what it could be? Is there any way to recreate the database?

    [21-Mar-2024 10:34:25 UTC] WordPress database error Unknown character set: ‘utf8mb4_unicode_ci’ for query CREATE TABLE wp_seopress_content_analysis (
    id bigint(20) NOT NULL AUTO_INCREMENT, post_id bigint(20) DEFAULT NULL, title longtext DEFAULT NULL, description longtext DEFAULT NULL, og_title longtext DEFAULT NULL, og_description longtext DEFAULT NULL, og_image longtext DEFAULT NULL, og_url longtext DEFAULT NULL, og_site_name longtext DEFAULT NULL, twitter_title longtext DEFAULT NULL, twitter_description longtext DEFAULT NULL, twitter_image longtext DEFAULT NULL, twitter_image_src longtext DEFAULT NULL, canonical longtext DEFAULT NULL, h1 longtext DEFAULT NULL, h2 longtext DEFAULT NULL, h3 longtext DEFAULT NULL, images longtext DEFAULT NULL, meta_robots longtext DEFAULT NULL, meta_google longtext DEFAULT NULL, links_no_follow longtext DEFAULT NULL, outbound_links longtext DEFAULT NULL, internal_links longtext DEFAULT NULL, json_schemas longtext DEFAULT NULL, keywords text DEFAULT NULL, permalink text DEFAULT NULL, score text DEFAULT NULL, analysis_date datetime DEFAULT NULL, PRIMARY KEY (id)
    ) DEFAULT CHARACTER SET utf8mb4_unicode_ci; made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, SEOPress\Actions\Table\CreateTable->init, SEOPress\Services\Table\TableManager->createTablesIfNeeded, SEOPress\Services\Table\TableManager->create, SEOPress\Core\Table\QueryCreateTable->create, maybe_create_table
    [21-Mar-2024 10:34:25 UTC] WordPress database error Table ‘NameDatabase_name_surname.wp_seopress_content_analysis’ doesn’t exist for query CREATE INDEX idx_post_id ON wp_seopress_content_analysis (post_id) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, SEOPress\Actions\Table\CreateTable->init, SEOPress\Services\Table\TableManager->createTablesIfNeeded, SEOPress\Services\Table\TableManager->create, SEOPress\Core\Table\QueryCreateTable->create

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Benjamin Denis

    (@rainbowgeek)

    Hi,

    it seems your our custom table has not been created.

    Try to disable and reactivate SEOPress to automatically recreate it.

    Let us know if it solves the issue or not.

    Thanks

    Thread Starter d009

    (@d009)

    Hi Benjamin,

    thank you for the answer. I did it but the result was the same. I deactivated it, then I removed it completely, then purged all cache, transients, then reinstalled it. The strange thing is that when I reinstalled it, considering that there’s no associated database, it remembered all the settings ans seo options as i left them.

    In database I should find something like wp_seopress or similar, right?

    Thread Starter d009

    (@d009)

    Hi Benjamin,

    I changed all database collations to – utf8mb4_unicode_ci – so it matches the wp-config.php file but I still have the same problem as reported above in the error_log. The Seopress entries are located in wp_postmeta and wp_options tables right?
    What do you suggest to do to fix it?

    Plugin Author Benjamin Denis

    (@rainbowgeek)

    Yes we store our post meta and options with this prefix seopress_

    https://www.seopress.org/support/guides/uninstall-seopress/

    Can you contact your host to make sure your SQL configuration supports utf8mb4_unicode_ci

    Thanks

    Plugin Author Benjamin Denis

    (@rainbowgeek)

    Due to topic inactivity, we’re now closing this topic. Thank you for your understanding.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Seopress issue with database’ is closed to new replies.