/
Make searching in other languages in CCC work (New languages with pre DC 4.10)

Make searching in other languages in CCC work (New languages with pre DC 4.10)

DC 4.9.1 and older versions have a bug concerning adding new languages. The bug results in some meta data not being correctly copied into the new language. 

This means that CCC simply wont allow a user to see assets when the user is set to use a "non-OOBE" language, i.e. anything other than english.

The fix is quite simple, but does require access to the database:

Simply copy the attached SQL script and run it on the database. 


A bit more technical description of the bug:

This is an issue for configuration metafields of the metafield type "multi combo" with more than 1 value selected. The problem is that the ref_itemid in the Meta_Value_Version tabel are not copied correctly when adding a new language. 

The only multi combo config metafields in CCC are "Sorting Types", "Low resolution media formats", and "High resolution media formats". There is currently not an issue with the latter 2, because they only have 1 value selected. If the latter 2 do have more than 1 value set, then please come see me (Jeppe Bo Bartel (Deactivated)) and I'll help you modify the script, so that the other 2 are fixed as well. Unfortunately I cannot hardcode unknown values into the script in advance. 

Related content