Sorry for the issue. This is actually a legacy upgrade bug. You can resolve by just doing an edit to each of the Custom Profile Fields. Don't make any changes, just edit each one, and that will correct the legacy issue in the database structure.

We recently improved the upgrader for future upgrades.

It seems that attempting ANY kind of edit to the Profile gets a similar error message.

As example, I tried uploading a Photo, and change the Title. In each case, again got error messages.

The Custom Profile Fields ; is that the one in this menu tree: Home → Admin Zone → Custom Profile Fields → Edit Custom Profile Field? How can they be edited when one is not making a change to them? Do you mean just hit "Edit" and then "Save"? I tried that and still get an error message.

Any upgrades are from 10RCxx, which was a fresh install, and not upgraded from 9.x.x

See new note above asking for input as the issue appears to still exist.

Still an issue with RC 18

Sorry I didn't reply to your further question. Yes, just hit Edit and then Save.

I wasn't very clear, the v9 to v10 upgrader has been improved, but the bug here was actually in v9. So the manual repair is still needed. I'll post a repair script as a second option in a minute.

I got distracted, but I've now attached the cleanup script. Put in data_custom, then load up via URL. It will rebuilt CPF database indexes and re-set the correct database data-types.