Title: database error
Last modified: May 9, 2020

---

# database error

 *  Resolved [popeating](https://wordpress.org/support/users/popeating/)
 * (@popeating)
 * [6 years ago](https://wordpress.org/support/topic/database-error-311/)
 * 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: [http://www.puredesign.it](http://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)

 *  [Suwash Kunwar](https://wordpress.org/support/users/suascat_wp/)
 * (@suascat_wp)
 * [6 years ago](https://wordpress.org/support/topic/database-error-311/#post-12809208)
 * Hi [@popeating](https://wordpress.org/support/users/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://wordpress.org/plugins/yoast-test-helper/](https://wordpress.org/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.
 *  [Md Mazedul Islam Khan](https://wordpress.org/support/users/mazedulislamkhan/)
 * (@mazedulislamkhan)
 * [6 years ago](https://wordpress.org/support/topic/database-error-311/#post-12847501)
 * 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.

 * ![](https://ps.w.org/wordpress-seo/assets/icon-256x256.gif?rev=3419908)
 * [Yoast SEO - Advanced SEO with real-time guidance and built-in AI](https://wordpress.org/plugins/wordpress-seo/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordpress-seo/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordpress-seo/)
 * [Active Topics](https://wordpress.org/support/plugin/wordpress-seo/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordpress-seo/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordpress-seo/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)

 * 2 replies
 * 3 participants
 * Last reply from: [Md Mazedul Islam Khan](https://wordpress.org/support/users/mazedulislamkhan/)
 * Last activity: [6 years ago](https://wordpress.org/support/topic/database-error-311/#post-12847501)
 * Status: resolved