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

Same issue, the hosting provider saying that all permission is already granted to the database. @joostdevalk

• This reply was modified 4 years, 6 months ago by tushargrover.

I am using VPS Server. So I am my own hosting provider. My all database and file system permissions are ok. Same problem. It must be code based problem. You need to check your codes.

• This reply was modified 4 years, 6 months ago by umitdursoy. Reason: -

Same issue here on 10 sites

I think I have found a way around this without losing data. Correct me if this is too stupid an idea:

1. Go to FTP and open up the /wp-contect/plugins/wordpress-seo/wp-seo.php file.
2. Change the version number from 14 to 13.
3. Go to wp-admin
4. Update your now out of date Yoast plugin.

Worked for me. Let me know if this is a dangerous thing to do. I am not a server guy.

You can also make this change by going to (in wp-admin) Plugins->Plugin Editor and select the drop-down (far right) to Yoast and change the version number on the screen there. Save before continuing. Again, I am no security expert, but I would advise caution when playing around with plugins. Doing this, should cause a new update to be flagged. Update your Yoast plugin and that should fix the issue. I hope it works for you. I have had to do this for all 14 of my websites.

thank you! I just deleted the plugin and installed it again. Everything works)

Same problem her with all sites. Changing version number, rereupdate, fresh install doesn’t work. It’s a problem with your code. Waiting for an update for the update.

meydot (@meydot) – Might be a different issue. I hope you find the fix.

jamesmiddz (@jamesmiddz) – I don’t think so. If the database user doesn’t have the privileges to create tables, you couldn’t install the plugin at all. You even couldn’t update WordPress or install any other plugin. It creates all tables while installing. There’s a simple bug in the plugin and we have to wait for a new update or switch to another plugin.

@jamesmiddz Your method doesn’t worked for me.

@jamesmiddz Not working for my sites

If the database user doesn’t have the privileges to create tables, you couldn’t install the plugin at all. You even couldn’t update WordPress or install any other plugin.

@meydot This isn’t exactly true. Installing plugins and updating WordPress is a matter of modifying files. Modifying databases is entirely different, and yes, if you are lacking proper database permissions, then errors like this can crop up.

Now, while it is true that WordPress updates sometimes “update the database”, no recent WordPress updates have done any database changes that would require such permissions in many years.

So yes, you should check on your database permissions regardless. If you are lacking them, then that could indeed cause issues like those being reported.

@meydot This isn’t exactly true. Installing plugins and updating WordPress is a matter of modifying files. Modifying databases is entirely different, and yes, if you are lacking proper database permissions, then errors like this can crop up.

It’s exactly true. Many plugins uses their own tables and you can’t install them at all, if you don’t have the permissions. I don’t think, that all people with this issue have changed their database permissions in the last days. Some people already wrote, that all permissions are set. My permissions also allow creating tables as always. A user without these permissions is useless.

Yoast 14.0.1 was just released. While it contains a lot of fixes, it might not fix the original issue of this thread. The database user also needs the INDEX permissions on the database, these are permissions that you don’t need for day to day use and WP will operate normally without these permissions. They are only needed for the update / creation of the tables, after that those permissions are not needed anymore.

14.0.2, which is planned for tomorrow, will quite possibly fix all the issues related to the database connection. So if you’re already on 14.0.1 and still experience issues, please downgrade to 13.5 and wait for 14.0.2.

Tried 14.0.1 and still same error – host confirms we have all permissions needed including INDEX, just posting to let you know. Thank you.