?
avatar lorenzopf
lorenzopf
23 Aug 2017

Sql dump off the assets table joined

good before upgrade : only 6 occurences for com_zoo ACL
Bad after upgrade 1 : 82 occurences found for com_zoo
bad after upgrade 2 : 84 occurences found for com_zoo when try to modify them via BO

Expected result

modify Administrator ACL on SYSTEM > CONFIGURATION > ZOO > ACL.

Assets table looks like :

wz1mj_assets_good_beforeupgrade.txt

Actual result

Administrator ACL are blocked as "refused" on SYSTEM > CONFIGURATION > ZOO > ACL.

Assets table looks like :

wz1mj_assets_broken_after_uprage1.txt

Additional content

I add ASSETS TABLE file before the joomla 3.7.4 upgrade and ASSETS TABLE file after the joomla 3.7.4 upgrade.

After the upgrade :

wz1mj_assets_broken_after_uprage1.txt

Before the upgrade :

wz1mj_assets_good_beforeupgrade.txt

Votes

# of Users Experiencing Issue
0/1
Average Importance Score
4.00

avatar lorenzopf lorenzopf - open - 23 Aug 2017
avatar joomla-cms-bot joomla-cms-bot - labeled - 23 Aug 2017
avatar franz-wohlkoenig franz-wohlkoenig - change - 23 Aug 2017
Priority Urgent Medium
Status New Information Required
avatar franz-wohlkoenig
franz-wohlkoenig - comment - 23 Aug 2017

have you asked Devs. of com_zoo?


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/17690.

avatar ggppdk
ggppdk - comment - 23 Aug 2017

One of the asset handling changes in J3.7.4+ is that empty assets will not be saved
so actually the asset entries should now be less than before ...

we adjusted our initial asset creation in our component (flexicontent component) to account for this
because we were creating a small number of empty assets ...

about zoo component:

Administrator ACL are blocked as "refused" on SYSTEM > CONFIGURATION > ZOO > ACL.

the problem is that you have about 20 or 30 of assets for 'com_zoo' component !!!
(i mean of the component itself !, i do not speak of its categories or its fields, etc)

i am not sure how this happened, but once you have 2 assets for a component and you click to save component configuration, then you will get 1 new asset every time (if i remember correctly)

The multiple assets can manifest the behaviour that all non-super user groups (e.g. administrator usergroup) will show as having all permissions refused !

  • a solution is delete all these duplicates assets of component

e.g. make full site backup and do execute an SQL query to delete the assets

and then hopefully next time you save component only 1 component asset
and any further saves will not create any more duplicate component assets

in any case report to the authors that multiple assets of the component itself are created ...

i do not know who should be responsible for checking for duplicate assets,

but it is good if the component checks ... and account for this case, and deletes all duplicate assets and then creates a single one ...

avatar lorenzopf
lorenzopf - comment - 25 Aug 2017

thank you for your answer, I will follow your instructions.


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/17690.

avatar joomla-cms-bot joomla-cms-bot - change - 25 Aug 2017
Closed_By franz-wohlkoenig joomla-cms-bot
avatar joomla-cms-bot joomla-cms-bot - close - 25 Aug 2017
avatar franz-wohlkoenig franz-wohlkoenig - change - 25 Aug 2017
Status Information Required Closed
Closed_Date 0000-00-00 00:00:00 2017-08-25 12:53:16
Closed_By franz-wohlkoenig
avatar joomla-cms-bot
joomla-cms-bot - comment - 25 Aug 2017
avatar franz-wohlkoenig
franz-wohlkoenig - comment - 25 Aug 2017

closed as stated above; it can always reopened.


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/17690.

Add a Comment

Login with GitHub to post a comment