cancel
Showing results for 
Search instead for 
Did you mean: 

Custom model property name case sensitive problem

joko71
Confirmed Champ
Confirmed Champ

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?

2 REPLIES 2

EddieMay
World-Class Innovator
World-Class Innovator

Hi @joko71 

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

HTH,

Digital Community Manager, Alfresco Software.
Problem solved? Click Accept as Solution!

afaust
Legendary Innovator
Legendary Innovator

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.