database error

  • Resolved popeating

    (@popeating)


    4 years, 6 months ago

    since some day i got this notice in my wordpress admin:

    Yoast SEO was unable to create the database tables required and as such will not function correctly.

    Looking at my server error log i found the following error

    2020/05/09 13:32:34 [error] 7251#0: *110358 FastCGI sent in stderr: “PHP message: WordPress errore sul database Table ‘wp_yoast_indexable’ already exists per la query CREATE TABLE wp_yoast_indexable (….
    ….
    while reading response header from upstream, client: 2.236.77.43, server: https://www.puredesign.it, request: “POST /wp-admin/admin-ajax.php

    also when saving a post it come up with the following error:
    WordPress database error Unknown column ‘blog_id’ in ‘field list’ for query INSERT INTO wp_yoast_indexable

    and the post is not saved
    i tried to drop the tables, unsinstalling, delteting and reinstalling, but still no fix

    i had to deactivate the plugin to have my site working
    what can be wrong

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Suwash

    (@suascat_wp)

    Hi @popeating,

    Thank you for contacting the Yoast Support Team. We are sorry about the issue with creating database tables by the plugin.

    We would suggest performing the following steps:
    1. Install the Yoast Test Helper plugin, you can add it by going to Plugins > Add New > Search for ‘Yoast Test Helper’ – or download it https://www.ads-software.com/plugins/yoast-test-helper/.
    2. Go to Tools > Yoast Test
    3. Click the Reset indexables tables & migrations button.
    4. Go to SEO > Tools and click the “Speed up my Site” button to let the indexation run

    The reset button with the Help Test Plugin should recreate the necessary tables and then you can re-run the process.

    Does this resolve the issue? We look forward to hearing from you.

    Plugin Support Md Mazedul Islam Khan

    (@mazedulislamkhan)

    This thread has been marked as resolved due to a lack of activity. You’re always welcome to re-open this topic.

    Thanks for understanding!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘database error’ is closed to new replies.

Tags