Recently I come across a very important Sitecore error
SCENARIO:
I unchecked the “Shared” from a field, and deployed to the Test Server, during the test, I saw that whatever content I put on the field, Sitecore always replaced with the old one, So, even the field was not Shared Anymore, the content somehow was locked, and I could not change the field value(i even tried the raw values), but nothing seems to work. Just a reminder: Locally it was working, the issue was present just on QA server and after the deployment.
SOLUTION:
After some research a found this article from Sitecore, and I was able to solve the issue https://kb.sitecore.net/articles/045873 – Installing templates with a modified field sharing type may cause database corruption
It consists basically of installing a KB and running a script, (this page will also show the broken Sitecore Items that you will need to review)
That being said, we can observe that it is a very important detail that must be considered when building a deployment package.
Sitecore Tips 