User tests: Successful: Unsuccessful:
Pull Request for Issue joomla-projects/privacy-framework#201.
This moves action log user notification option to separate table. It is a performance improvement on larger sites and shouldn't affect existing behavior. Except when going from 3.9-alpha as existing preference will be nullified in this case.
Download and install package https://github.com/SharkyKZ/joomla-cms/archive/comActionlogsPerf_1.zip or, if using Patchtester, apply Database Fix after installing patch.
Test that user settings in User Actions Log Options
tab continue to be saved properly and that Send notifications for User Actions Log
continues to be respected.
Also if someone could thoroughly review SQL file changes that would be great.
Comments on table structure welcome too.
Database changes, plugin field names changed.
Status | New | ⇒ | Pending |
Category | ⇒ | Administration SQL com_admin Postgresql MS SQL Installation Front End Plugins |
I have tested this item
Applied the patch, but unsuccessful. New table '#__action_logs_users' is not created and log out is not possible. On log out an error is shown.
@pjasmits please mark your Test as unsuccessfully:
Labels |
Added:
?
|
@pjasmits The error should be fixed now.
@BurtNL it's best to test by downloading the package (https://github.com/SharkyKZ/joomla-cms/archive/comActionlogsPerf_1.zip) and doing a fresh install. Alternatively, you can execute Database Fix to install missing tables. I'll update testing instructions.
I have tested this item
patch gives error on logout
Thanks SharkyKZ, I used 'Fix database', which solved the log out problem. I will do some additional testing on this.
I have tested this item
Tested successfully on Joomla 3.9.0-alpha2-dev, on a fresh install, applied the patch, run the Fix Datase.
The new table has been created and contains content. Log out working proberly as well.
Patch works as intended by submitter, needs further testing.
Labels |
Added:
?
Removed: ? |
I have tested this item
Updated 2 or 3 days old nightly 3.9.
Applied patch and fixed database.
Saved all existing "Super Users" (!!!!). Have now rows in #__action_logs_users. Received or not emails according user settings.
Created new "Super Users" and some with other groups. Only "Super Users" see Acions Log tabulator after first saving. Other groups never see it.
Switched groups of users and deleted "Super Users". Rows in #__action_logs_users correctly deleted or created (after additional saving).
Don't receive emails anymore if "Send notifications" disabled or not "Super User" any longer.
Don't forget to remove and apply patch newly if you upgrade nightly 3.9 with "Upload&Update"!
I have tested this item
Fresh install of Joomla_3.9.0-beta2-dev-Development-Full_Package, applied the patch, fixed the database.
Test with change options of User Actions Log failed.
When all 'Events to log' are not selected then all events will be selected again after 'Save'.
Changing individual events seems to work fine.
And when should the table '#action_logs_users' be filled?
What do I need to test to trigger the creation of records in that table?
I have tested this item
Fresh install of Joomla_3.9.0-beta2-dev-Development-Full_Package, applied the patch, fixed the database.
Test with change options of User Actions Log failed.
When all 'Events to log' are not selected then all events will be selected again after 'Save'.
Changing individual events seems to work fine.
And when should the table '#action_logs_users' be filled?
What do I need to test to trigger the creation of records in that table?
When all 'Events to log' are not selected then all events will be selected again after 'Save'.
This is the default behavior and not related to this PR. Unselecting all would defeat the purpose of logging.
And when should the table '#action_logs_users' be filled?
Edit your account and update User Actions Log Options
.
Use phpMyAdmin and view `action_logs_users' table for your saved settings.
When all 'Events to log' are not selected then all events will be selected again after 'Save'.
And when should the table '#action_logs_users' be filled?
This is the default behavior
I can't confirm your find.
Maybe we're using completely different Joomlas ? ;-) I've installed mine (nightly) some hours ago. And with the older version I also could save without any selected box.
When all 'Events to log' are not selected then all events will be selected again after 'Save'.
I stated incorrectly in my previous reply.
In PHP error log file, when no checkboxes selected:
PHP Notice: Undefined index: actionlogsExtensions in \plugins\system\actionlogs\actionlogs.php on line 342
@BurtNL this can be reproduced without patch (try fresh 3.9.0 Beta 2) too. If you deselect all options on first save, no value is saved to database but form shows all options as selected (this is what the field defaults to). You would have to save again (with all or some options selected) to have the options stored.
Scenario # 2: select some options. Save. Deselect all options. Save again. The data still contains previously selected options. So, yes, you can't deselect all options.
Updating this so it works like without patch.
Alternatively, we could just add required
attribute to the field...
@ReLater I'm using a new nightly build, but we are on different pages.
I'm on the Options page, you are on a user profile page.
@ReLater I'm using a new nightly build, but we are on different pages.
I'm on the Options page, you are on a user profile page.
@SharkyKZ Yes, you are right, I'm sorry about that.
I just run a test again and with or without the patch the behaviour is the same, so not related to the patch.
I agree with you to add the required attribute, because now the behaviour is a bit odd, to my opinion.
Later today I will have a look at the other test instructions about how to get some entries into one of the tables.
Wouldn't it be nice to have the 'Yes/No' switches instead of the select boxes in the Option page?
Like on the other pages in the admin interface.
@SharkyKZ Yes, you are right, I'm sorry about that.
I just run a test again and with or without the patch the behaviour is the same, so not related to the patch.
I agree with you to add the required attribute, because now the behaviour is a bit odd, to my opinion.
Later today I will have a look at the other test instructions about how to get some entries into one of the tables.
Wouldn't it be nice to have the 'Yes/No' switches instead of the select boxes in the Option page?
Like on the other pages in the admin interface.
I have tested this item
Did a fresh install of Joomla_3.9.0-rc2-dev, applied the patch, fixed the database and tested the User Actions Log Options.
Looks good!
I have tested this item
This has solved #22662
Status | Pending | ⇒ | Ready to Commit |
RTC
@mbabker
Please merge as this corrects important bugs.
Status | Ready to Commit | ⇒ | Fixed in Code Base |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2018-10-17 12:00:41 |
Closed_By | ⇒ | mbabker | |
Labels |
Added:
?
|
patch is not working. After logout I get the following error:
0 syntax error, unexpected '')'' (T_CONSTANT_ENCAPSED_STRING), expecting ',' or ')'