Custom model property name case sensitive problem

[joko71]

A custom model property name with wrong case was deployed on the production, while the property had different cased name in the code. The property name was updated to the correct and the same case everywhere, both in the model and in the code, yet sometimes the old property name pops up when new content is created. An old property name was later found in the "alfresco" database.

I think full reindex should do the trick, repair the wrong property name, but is it possible (to avoid full reindex) to change the property name directly in the database?

[EddieMay]

Hi @joko71 

Here are some resources re: direct database queries - one, two if you think this is the best way to go.

HTH,

[afaust]

You will likely have both property names in the database at this point. You need to identify the alf_qname rows for the property with the old / new spellings, and use the ID for the old spelling to identify and update any properties in alf_node_properties to use the ID for the new spelling. The update should be done while Alfresco is inactive/offline. As always, a pre-update backup is recommended in case you make a mistake.