View Issue Details

IDProjectCategoryView StatusLast Update
0006925OXID eShop (all versions)6. ------ Setup -------public2019-04-18 14:54
Reportermichael_keiluweit Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Fixed in Version6.1.4 
Summary0006925: EE only. Two user groups have the same RR id.
DescriptionWhen 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 Reproduce1. 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 InformationThe 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.
TagsDemo Data, EE
ThemeNot defined
BrowserNot defined
PHP VersionNot defined
Database VersionNot defined

Activities

michael_keiluweit

2018-11-29 13:23

administrator   ~0012709

Last edited: 2018-12-03 14:52

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

anton.fedurtsya

2019-04-18 14:54

administrator   ~0012862

This one will be fixed in new demodata version, so in any release which will use the new one - v6.0.2 and up.