topic Re: Custom model property name case sensitive problem in Alfresco Forum

Custom model property name case sensitive problem

joko71 — Tue, 11 May 2021 06:22:28 GMT

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?

Re: Custom model property name case sensitive problem

EddieMay — Tue, 11 May 2021 10:11:19 GMT

Hi @joko71

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

HTH,

Re: Custom model property name case sensitive problem

afaust — Tue, 11 May 2021 10:20:36 GMT

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.