I have found an issue with making a field with being required as part of a user profile - the SQL is always posting : (Carriage Returns inserted to make ledgible)
UPDATE xoops_user_profile_field SET
field_type = 'select',
field_valuetype = 7,
field_name = 'notify_mode',
field_title = 'Default Notification Mode', field_description = '',
field_required = 0,
field_maxlength = 0,
field_default = '',
field_moduleid = 1,
field_notnull = 1,
field_edit = 1,
field_show = 1,
field_config = 0,
field_options = 'a:3:{i:0;s:33:"Notify me of all selected updates";i:1;s:19:"Notify me only once";i:2;s:48:"Notify me once then disable until I log in again";}',
field_register = 0
WHERE fieldid = 4
where the field_required is ALWAYS the original field of field_required as opposed to the new set value.
I can manually set the values in the database and then I am able to proceed with the task that I was performing.
If you require addition trace log information please let me know and I will get the information you ask for.
Thanks