Fixed: Update Failed Could Not Update Post in the Database

Updated:

by

how to fix Update failed, could not update post in the database featured

Are you getting the error, “Update Failed: Could not update post in the database” on clicking the Save draft or Update button while creating or updating a post in the WordPress Block Editor (Gutenberg Editor)? Don’t panic! You’re in the right place.

In this tutorial, I will guide you on what is the cause of this error, and how to get rid of it.

This is the how the error “Update Failed” appears in the WordPress Editor.

Cause of the Error & Solution

The most common cause of this error is either a piece of code or a special symbol such as UTF-8 symbol/character that you would have added in the post content, might not be compatible with MySQL database.

MySQL database might not support full UTF-8 Emojis, Asian Symbols, Mathematical Symbols, Chinese, Japanese and Korean signs, Musical notation, Ancient Languages, and User-defined font icons.

Primary Solution

Find that piece of code or a special symbol/character in your post content which is causing the error and remove it.

If the special characters/symbols are very important for you to use in the post content, then you can use those characters/symbols which are compatible with MySQL.

I have shown in the next section that how I found special symbols that I had added was stopping from saving the post, and how I got rid from the “Update Failed” error by removing them.

Other Solutions

If the above cause is not the reason then the following solutions can help you to get rid of this error:

  1. Deactivate your WordPress plugins and activate them one-by-one until you find the cause.
  2. Switch the Block Editor to Classic Editor for a while and see whether the post is saved or not.
  3. Go to Site health from WordPress Sidebar (Tools => Site health) and click the Status tab to check whether it is showing you a relevant issue or recommendation.

How I Got Rid of Update Failed Error?

Here I will share two scenarios (1) Update Failed Error Appeared While Updating an Old Post (2) Update Failed Error Appeared While Creating a New Post.

01. Error Appeared While Updating an Old Post

Below you can see there are three special symbols i.e. Heart, Rocket, and a Shinning Star. When I had created this post, they were allowed to be saved in the database. After few months, when I tried to update the post, I was getting the error “Update Failed: Could not update post in the database” .

I deleted the three special symbols from the post and got rid of the error.

02. Error Appeared While Create a New Post

Below you can see a Link Symbol that I had copied from Google search results. Initially, my WordPress admin would logged out as I would click the Save draft. I had no clues what was happening.

After some time WordPress Editor started to display the “Update Failed: Could not update post in the database” error. I did so many attempts and tried many solutions to fix the error, but nothing was working.

Afterwards I got a hint i.e. the content above the Link Symbol would save, and the content lying below the LINK Symbol wouldn’t save. So, I thought the Symbol might be stopping the post from being saved.

  • Below you can see that I have removed the Link Symbol and typed its Name.
  • Now to check whether the post is being saved or not, click the Save draft or Update button.
  • Here you can see the notification Draft saved at bottom. When the “Update Failed” error occurs, the Draft Saved notification doesn’t appear.

I hope that my suggested solution would have helped you to remove the error. If you like this post then don’t forget to share with the other people. Share your feedback in the comments section below.

Also Read

Related Topics: , ,
Buy Domain and Hosting on Namecheap Now
Rank Math Best SEO WordPress Plugin Download
Download Website Themes
Mangools SEO Tools
Order Motivational T-Shirts With Quotes from Our Store Fire Ram 23.4.

Subscribe to Our Newsletter!

8 responses

  1. Avatar
    Molly

    Unexpectedly, a common video emoji has been bothering me for a month. Reading your article solved my problem. Thank you so much.

    1. Meer Basit

      You’re most welcome, Molly!

  2. Avatar

    Can’t believe that a plain wink emoji is causing the entire page updating issue. Thank you very much for your article, super helpful.

    1. Meer Basit

      You’re most welcome.

  3. Avatar
    Julie

    That helped to resolve the issue, but do you have a solution for putting the emojis back on the page?

    1. Meer Basit

      (1) You can use those characters/symbols which are compatible with MySQL (2) You can install the plugin called “Insert Special Characters” that allows you to insert special characters in the WordPress post directly from the Toolbar.

  4. Avatar
    At

    Yes Helpful, was having the same issue, resolved by reading your post. Thanks

    1. Meer Basit

      You’re most welcome!

Leave a Reply

Your email address will not be published. Required fields are marked *