Title: Error
Last modified: August 18, 2020

---

# Error

 *  Resolved [jackstyze](https://wordpress.org/support/users/jackstyze/)
 * (@jackstyze)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/error-1395/)
 * For this feature to work, Yoast SEO needs to create a table in your database.
   We were unable to create this table automatically.
    I got this in sitehealth 
   I got the green check for all internal linking suggestions and the green check
   for your site has been optimized. I Checked my databases tables, all is fine 
   and all the plugins can create delete or others sql commands How to fix this ?

Viewing 6 replies - 1 through 6 (of 6 total)

 *  [devnihil](https://wordpress.org/support/users/devnihil/)
 * (@devnihil)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/error-1395/#post-13277767)
 * [@jackstyze](https://wordpress.org/support/users/jackstyze/) We’re sorry to hear
   you’re still experiencing the issue and we apologize for the difficulties the
   plugin is causing for you. We would like some more information to try and help
   you resolve this:
 * **1. **Verify your database has the Table and Index permissions along with Create,
   Drop, and Alter required to create these tables in your database: **wp_yoast_indexable,
   wp_yoast_indexable_hierarchy, wp_yoast_migrations, wp_yoast_primary_term**. If
   you are not sure, your host provider can help.
 * **2. **Can you confirm your server has all the right requirements? If you are
   not sure, speak to your host provider. This guide explains more: [https://kb.yoast.com/kb/plugin-requirements/](https://kb.yoast.com/kb/plugin-requirements/).
 *  Thread Starter [jackstyze](https://wordpress.org/support/users/jackstyze/)
 * (@jackstyze)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/error-1395/#post-13280899)
 * Hello,
    1- Yes i have all those tables and plus _prominent_words and_seo_links
   2- Yes of course I even installed Yoast Test and reset indexable tables and linking
   suggestions but this issue is still showingup
 *  [devnihil](https://wordpress.org/support/users/devnihil/)
 * (@devnihil)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/error-1395/#post-13283545)
 * [@jackstyze](https://wordpress.org/support/users/jackstyze/) Thanks for confirming
   that your database has the necessary permissions. Can you please check the following?:
 * **1)** Can you please let us know whether you are using a Windows server?
 * **2)** Can you please check your `wp-config.php` file and let us know what the**
   DB_CHARSET** and **DB_COLLATE **settings are?
 * **3)** Can you please check your database and verify if the following tables 
   were in fact created? : **_yoast_indexable, _yoast_indexable_hierarchy, _yoast_migrations,
   _yoast_primary_term**
 *  Thread Starter [jackstyze](https://wordpress.org/support/users/jackstyze/)
 * (@jackstyze)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/error-1395/#post-13286377)
 * [@devnihil](https://wordpress.org/support/users/devnihil/)
    1- No apache on ubuntu.
   2- define( ‘DB_CHARSET’, ‘utf8’ ); /** The Database Collate type. Don’t change
   this if in doubt. */ define( ‘DB_COLLATE’, ” ); 3- Maybe it can help but i imported
   this database from an other wordpress site but i dropped the content of the tables.
 *  [Jeroen Rotty](https://wordpress.org/support/users/jeroenrotty/)
 * (@jeroenrotty)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/error-1395/#post-13286977)
 * Thank you for your reply [@jackstyze](https://wordpress.org/support/users/jackstyze/).
 * We believe that it is related to the new information you gave in number 3 as 
   you imported them and then dropped the content.
 * We recommend trying the following:
 * 1) Install the Yoast Test Helper plugin, found here [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. 5) Click the `Start processing and speed up your
   site now` button and let it complete.
 *  [devnihil](https://wordpress.org/support/users/devnihil/)
 * (@devnihil)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/error-1395/#post-13317154)
 * We are going ahead and marking this issue as resolved due to inactivity. If you
   require any further assistance please create a new issue.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘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/)

 * 6 replies
 * 3 participants
 * Last reply from: [devnihil](https://wordpress.org/support/users/devnihil/)
 * Last activity: [5 years, 9 months ago](https://wordpress.org/support/topic/error-1395/#post-13317154)
 * Status: resolved