Every once in a while we can end up in a state where the cmsPropertyData table wipes away data for no apparent reason. The data can still exist in the XML cache even though it's missing in the database, so the site itself will look fine, but in the back office, the data will be missing. If a user saves the page while in this state, the null value will overrule the data in the cache and wipe out whatever was in that property from the cache as well.
Other times, when trying to enter a value into a previously empty property, the user can put data in, hit save, and the data will not be saved to the cmsPropertyData table at all.
We have not been able to reliably reproduce the bug yet, but from what we have been able to tell, it's not a failing on the side of the server or database. We use SQL 2014 Enterprise and IIS 8.5.
I've seen similar issues reported on the forum, but they seem to have been blamed on IIS Express and/or SQL CE, neither of which we use.
Does anyone have any insight into this issue, why it might be happening, or any workarounds? Please note that we are currently not in a place where we can do a full Umbraco upgrade soon.
We seem to have experienced the same issue this week:
Our installation:
Umbraco version 7.13.2
SQL server 2016 SP1
IIS 8
The issue;
Homepage document type seemed to be corrupted, it wouldn't load the website. We re-saved this document type and everything seemed to be fixed. A little bit after we found out some settings were 'empty' in the CMS, but the data was still available in the XML cache versions.
At the same time this also occured on our Member Type, we had a custom property, and the values for this property were gone for all our members.
Data disappearing from cmsPropertyData table
We're on Umbraco v. 7.4.3
Every once in a while we can end up in a state where the cmsPropertyData table wipes away data for no apparent reason. The data can still exist in the XML cache even though it's missing in the database, so the site itself will look fine, but in the back office, the data will be missing. If a user saves the page while in this state, the null value will overrule the data in the cache and wipe out whatever was in that property from the cache as well.
Other times, when trying to enter a value into a previously empty property, the user can put data in, hit save, and the data will not be saved to the cmsPropertyData table at all.
We have not been able to reliably reproduce the bug yet, but from what we have been able to tell, it's not a failing on the side of the server or database. We use SQL 2014 Enterprise and IIS 8.5.
I've seen similar issues reported on the forum, but they seem to have been blamed on IIS Express and/or SQL CE, neither of which we use.
Does anyone have any insight into this issue, why it might be happening, or any workarounds? Please note that we are currently not in a place where we can do a full Umbraco upgrade soon.
We seem to have experienced the same issue this week:
Our installation:
The issue; Homepage document type seemed to be corrupted, it wouldn't load the website. We re-saved this document type and everything seemed to be fixed. A little bit after we found out some settings were 'empty' in the CMS, but the data was still available in the XML cache versions.
At the same time this also occured on our Member Type, we had a custom property, and the values for this property were gone for all our members.
Does anyone have any updates on this?
is working on a reply...