Sophist
Guest
I have joined my table to Joomla's users, user_usergroup_map and usergroups tables.
When I save the form it tries to update the user_usergroup_map with:
UPDATE `j3_user_usergroup_map` SET `group_id`='13' WHERE user_id='456'
This is invalid because there are several records with user_id='456' (all of which will be updated by this) and there is a primary key on user_id+group_id.
I have set the group_id element to have both Read-Only and Disable Element set to yes, but this UPDATE statement is still executed.
When I save the form it tries to update the user_usergroup_map with:
UPDATE `j3_user_usergroup_map` SET `group_id`='13' WHERE user_id='456'
This is invalid because there are several records with user_id='456' (all of which will be updated by this) and there is a primary key on user_id+group_id.
I have set the group_id element to have both Read-Only and Disable Element set to yes, but this UPDATE statement is still executed.