Custom Multi-select in Contacts not editable

[rbooz]

All...

At some point between 4.5.0c and 4.5.0e I lost the ability to edit my custom fields in contacts edit view. I thought it was limited to my multiselect dropdowns, but it appears that all of my custom fields for contacts are now not saving edits. As noted below, I turned up logging and can see that no UPDATE statements are being run against "contacts_cstm" at all. Custom fields in Accounts works fine (the only other place I have customer fields right now).

Many thanks for any help I can get!
Ryan

Server OS: Windows 2003, IIS 6
Sugar: OS 4.5.0f
PHP: 5.1.2
MySQL: 5.0.24a

[rbooz]

An update for anyone that might know where to look from here. In an effort to try and see if the UPDATE statement was even being run on the 'contacts_cstm' table, I turned the "slow query" logging on for anything over 1ms. I was able to see that for the contacts module, my contacts_cstm table is not being updated, only the "contacts" table. However, in accounts, there are two update statements run, one for "accounts" and one for "accounts_cstm".

Why would Sugar seem to lose the link that these are custom fields and need to be updated?

Thanks again for any hints.

Ryan

[eaho]

I recently had the exact same issue (same debugging info). For those that run across this article here's the fix...

go to admin
click studio
click Repair Custom Fields

works like a charm and the update statements start using the contacts_cstm. Would have saved me a lot of time if that link had been in the "Repair" area of the admin section.