santacruzjohnleephotography.com
Updating failed. Could not insert post into the database.
Trying to edit the Contact page (applicable to all pages), I simply remove one line item, trying to save it, and keep seeing the same error message. And the page can never be saved. I cannot update any page on my website. Please help. Thank you.
Hi and welcome to the forum! The ones on the topic I’ve found about that suggest you to remove characters like emojis, as they might be the cause of the error you’re having:
OMG. You are right. After removing all the emoji’s, the problem is gone. Much much appreciated. And now I started pondering constraints (sometime crazy) vs free resources (e.g. InfinityFree). Does being free allow someone to be crazy? Does this issue help or hinder InfinityFree’s fundamentals? I would argue such issue hinder InfinityFree’s effort to push users to paid plans because now I lost confidence of this engineering team. The mental is like “Now I am pissed. I guess I have to pay anyway for the quality. No way I am gonna pay here because I doubt similar issues or corner-cutting will be in my way someday soon.”
I’m not sure why you had this issue with your website, but I can tell you that there is absolutely no problem with using emoji on a well configured website.
Searching through a few other posts about this issue confirms what I expected: it’s a character encoding issue. Specifically, one which appears to occur most frequently on older tables, which have the older utf8mb3 encoding instead of utf8mb4, which is known to be unable to save emoji.
I found this guide which seems like it should fix this issue for your WordPress website: phpMyAdmin: How to Convert utf8_general_ci Database to utf8mb4_unicode_ci – Marius Hosting
Don’t forget to backup your database before making changes!
Thanks for getting back to me and the link. I have to say it is way too technical to me. I am simply setting up the website using all the available tools and scripts provided as it is and am absolutely NOT savvy enough to mess up with website settings, database settings, or encoding settings. Your test team simply needs to cover more test cases to uncover mysterious issues like this one. You guys are doing a great services for many many people. It’s a shame that such issue happens and simply saying “I’m not sure why you had this issue with your website,…” I am just very reluctant to go through all the hoops described in the article you provided but I guess I have to because this is a free resources. Appreciate your effort I have to acknowledge.
Just follow the steps described in the link you provided and tested by adding emoji chars in the page, and I can save the page successfully. Thank you for the help and the solution. But I have to say whoever facing this issue, very few would report (you lost them), and very few would arrive at the solution (you lost them). Please keep making this place better. Thanks.
I’m not sure you understand what is causing this problem. InfinityFree just provides the server, not the software that you load onto it. It’s the software (From WordPress) and your configuration of it that is causing it.
If you repeated the exact same steps on a different host you would end up with the exact same problem. This is a software problem, not a host problem, and the host can’t fix it for you or prevent it from happening.
And because you are the one that loaded the software, it is your responsibility to get it working how you want it. We are happy to help you out, but it’s not our problem so we’re not going to fix it for you.
I think you don’t understand the general concept of a web hosting service.
Our hosting works exactly as it’s supposed to. We provide a MySQL database server for you to use. Like all MySQL database servers, it supports various text encodings you can choose from. Your website is setup to use a character set that doesn’t support emojis. So then your website can’t support emojis.
That’s not a problem with our hosting. The problem is an issue with your website. And that’s not something we can fix for you.
Please understand that with web hosting, we don’t manage or maintain your website code, settings or configuration. We just provide the server space, and it’s up to you to setup and maintain the website itself.
If you don’t want to manage that, then managed hosting offers exist. You could also setup your WordPress website with WordPress.com for example. But be prepared to pay a lot more for a lot fewer features.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.