DB Table #__user_usergroup_map has two cols user_id and group_id
One user can be added multiple, because of multiple groups, but user_id is set as primary key.
Try import a #__user_usergroup_map where a user is associated to more aus one usergroup
you will see it runs into duplicate entry error
Duplicate entry ... for key 'PRIMARY'
Should be possible to import
Error
Duplicate entry ... for key 'PRIMARY'
Because of PRIMARY Key user_id could only be exists once
Same foru group_id
Joomla! 4.0.0-beta1 Beta [ MaƱana ] 30-May-2020 18:32 GMT
Database Type | mysql 5.7.25-28
Labels |
Added:
?
|
Status | New | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2020-06-04 10:24:15 |
Closed_By | ⇒ | HLeithner |
You are right, thanks and sorry @HLeithner
The primary key uses 2 column that means the combination of both columns have to be unique which is correct.
It seams your import data has duplicated entries. ex. 2 rows with user_id: 1 and group_id: 1