View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006925 | OXID eShop (all versions) | 6. ------ Setup ------- | public | 2018-11-29 13:22 | 2019-04-18 14:54 |
| Reporter | michael_keiluweit | Assigned To | |||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Fixed in Version | 6.1.4 | ||||
| Summary | 0006925: EE only. Two user groups have the same RR id. | ||||
| Description | When installing the demodata, a new user group "shop_admin" is introduced and it gets a new entry in oxgroups. But by doing this an already taken id for the field oxrrid is used. +----------------------------+--------------------+--------+ | oxid | oxtitle | oxrrid | +----------------------------+--------------------+--------+ | 36944b76defac5622.13882269 | admin_demo | 15 | | oxidnotyetordered | Noch nicht gekauft | 15 | +----------------------------+--------------------+--------+ This causes a behavior in an AJAX window for handling shop roles. By fetching one of those two groups and dropping it into the target field, both groups are assigned or unassigned. | ||||
| Steps To Reproduce | 1. install an Enterprise Edition with demodata 2. goto admin 3. Administer Users -> Shop Roles 4. Create a new role 5. Click on the tab "Users" -> Assign User Groups 6. move the group "admin_demo" to the right field. You will see that the group "Noch nicht gekauf / Not yet purchased" was also moved. 7. Move one of the two back, the other one will also disappear. | ||||
| Additional Information | The cause of the behaviour is located in /vendor/oxid-esales/oxideshop-demodata-ee/src/demodata.sql:
INSERT INTO `oxgroups` (`OXID`, `OXACTIVE`, `OXTITLE`, `OXTITLE_1`, `OXTITLE_2`, `OXTITLE_3`, `OXRRID`, `OXTIMESTAMP`) VALUES
('36944b76defac5622.13882269',1,'admin_demo','admin_demo','','',15,'2016-07-19 14:38:26'),
[...],
('oxidnotyetordered',1,'Noch nicht gekauft','Not Yet Purchased','','',15,'2016-07-19 14:38:14'),
Because of the same OXRRID (15) the Ajax window react to both objects. Solution: Change on of the OXRRID to 16. | ||||
| Tags | Demo Data, EE | ||||
| Theme | Not defined | ||||
| Browser | Not defined | ||||
| PHP Version | Not defined | ||||
| Database Version | Not defined | ||||
|
|
I made a PR for it, but it was misplaced as this is an issue of the demodata, not the EE code: https://github.com/OXID-eSales/oxideshop_ee/pull/22 |
|
|
This one will be fixed in new demodata version, so in any release which will use the new one - v6.0.2 and up. |
