Thanks Steve. I’ll give that a try. PHP 5.6 is the highest version Godaddy offers.
I also wanted to clarify, when the page content disappears, I am in the visual editor. Clicking the update button after an edit causes the content to vanish on both the visual editor and on the viewed page.
I’ll let you know how this goes.
Spoke to Godaddy support. They are claiming this isn’t a database issue, it’s a WordPress, theme or content issue. Just to get this out of the way, below is a screenshot of the DB user settings showing all privileges checked:
I rather think this is a Godaddy issue. They are saying there is something in the website or the theme which is causing this. The theme is a child theme of GeneratePress. I tested their theory by switching to the Twenty Sixteen theme, just in case there was something in the GeneratePress parent theme which could be causing the problem. All page content still deleted itself after an update under Twenty Sixteen.
Including the steps I have taken above, here are the troubleshooting steps I have taken:
- Double-checked the DB user priveleges
- Turned off all plugins
- Cleared my browser cache
- Tried rebuilding a page from scratch
- Upgraded tp PHP 5.6
- Switched to an unrelated theme
- Checked both wp-config.php and functions.php for any extra returns at the bottom of the page.
In every case the problem of the page content deleting itself after an update persists. The development copy of the website on a subdomain on my host at Siteground isn’t giving me any of these problems.
I am looking for other troubleshooting options to try or suggestions for making an argument to Godaddy that they need to take a closer look at this.
Yeah, I’m thinking that has to be my next step. When I created the DB user there was a single button to apply all privileges. Seems like something may have gone wrong.
I’ll post back if it gets resolved.
Thanks Steve. I’m not sure how to customize the DB specifically for Godaddy. This has never come up before.
When I update a page, whatever was on that deletes itself completely. The existing content that carried over from my development server is gone and I am left with an empty page. Any new edits to the page, even just one word does not save to the DB and I am still left with an empty page.
The database does not seem to want to accept any new content. This only affects pages & widgets. With the widgets, the content doesn’t delete itself but all ned changes don’t update and save.
One clue I jut discovered is that that tags in the dummy placeholder custom post type pages elsewhere on the site all work.
The one difference in the “Forever Homes Real Estate” page is that this custom post type page was created under a custom user role called “Small Business” while the placeholders were created by the “Administrator” user role.
The plugin I used to create this role is “User Role Editor.”
Thanks ancawonka. I’ll give Members a try.
@bcworkz: Yes, Gravity Forms has several payment gateway addons including paypal and Authorize.net. I am actually leaning towards it even though the inventory management in woocommerce is easier.
Thanks @swansonphotos for the suggestions on membership.
Thanks! Worked like a charm.
Thanks. Sorry for the delay. I didn’t get your response in my inbox. Works great now.
The “Mark as resolved” checkbox is not showing up for me. Otherwise I would have clicked it.
I deactivated, de-installed and re-installed 3 plugins. Seems to have solved the problem. Thanks for the help.
I’m trying to get more comfortable with github to avoid these issues in the future.
Thanks kmessinger. I’ll start to delete and replace the plugins with problems.
Regarding the database, I did a google search and there wasn’t much info to tell me how to identify problems in the database from phpMyAdmin. I found no articles that would tell me how to spot a problem in one or more of the tables. Closest I came was this article. About ⅓ of the way down, under the heading “Optimizing your WordPress Database in phpMyAdmin,” it talks about “Optimize Table” and “Repair Table.” Would these be an option?
By the way, the wp-config file is from a brand new installation of WP. The only edits I made were the DB name, user and password.
Could this possibly be a memory issue? I’m wondering if I were to boost the memory allocation of WP if it might resolve the issue.
