Count link features doesn’t find the database

  • Resolved Jeffinho2016

    (@jeffinho2016)


    7 years, 4 months ago

    Hi, I’m getting this message.
    The Text link counter feature (introduced in Yoast SEO 5.0) is currently disabled. For this feature to work Yoast SEO needs to create a table in your database. We were unable to create this table automatically.
    Please read the following knowledge base article to find out how to resolve this problem.

    However, when I went to phpmyadmin to manually create the tables, they were already created, and with appropriate prefix (which is not wp_ in my case).
    See this screenshot : https://prntscr.com/fuo325

    Yet, Yoast can’t see them.

    How is that?

    Thanks for any advice!

Viewing 5 replies - 1 through 5 (of 5 total)
  • Anonymous User 12851872

    (@anonymized-12851872)

    Hi,
    All yours tables are under utf8mb4_unicode_520_ci ?

    CREATE TABLEwp_yoast_seo_links` (
    id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    url varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    post_id bigint(20) unsigned NOT NULL,
    target_post_id bigint(20) unsigned NOT NULL,
    type varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL,
    PRIMARY KEY (id),
    KEY link_direction (post_id,type)
    ) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

    CREATE TABLE wp_yoast_seo_meta (
    object_id bigint(20) unsigned NOT NULL,
    internal_link_count int(10) unsigned NOT NULL DEFAULT ‘0’,
    incoming_link_count int(10) unsigned DEFAULT NULL,
    UNIQUE KEY object_id (object_id)
    ) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;`

    • This reply was modified 7 years, 4 months ago by Anonymous User 12851872.
    Thread Starter Jeffinho2016

    (@jeffinho2016)

    Hi @noaeno,
    Deleted the tables (that the plugin created, not me).
    Recreated them manually reusing the query.
    Now I’ve got this: https://prntscr.com/fup3dl

    Yoast is still telling me that it can’t create the table, event though it’s created (and that the table is populated with values)
    https://prntscr.com/fup3wb

    Anonymous User 12851872

    (@anonymized-12851872)

    Hi,
    sorry, red this https://kb.yoast.com/kb/how-to-check-for-plugin-conflicts/
    For further assistance, please contact plugin support: https://kb.yoast.com/kb/support/

    Thread Starter Jeffinho2016

    (@jeffinho2016)

    Yeah, turns out it’s the plugin “Admin Columns” that creates the issue

    Anonymous User 12851872

    (@anonymized-12851872)

    Happy for you, report to the author of the plugin the problem
    Thanks for putting the subject in resolved

    Nice day

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Count link features doesn’t find the database’ is closed to new replies.