Details
-
Bug
-
Resolution: Cannot Reproduce
-
Medium
-
4.6.0-dev, 4.6.0beta1
-
None
-
Operating System: RHEL 6.1
PHP Version: 5.3.3
Database and version: mysql 5.1.52
Browser (and version):
Description
Changing the the notification time and running the respective cronjobs is showing some strange values in the mysql tables.
1. Verification after creating the user:
+------------------+------------------------+-----------------------------+-----------------------+------------------+--------------------------+----------------+ | contentobject_id | expirationnotification | expirationnotification_sent | password_last_updated | passwordlifetime | passwordvalidationregexp | updatechildren | +------------------+------------------------+-----------------------------+-----------------------+------------------+--------------------------+----------------+ | 4 | 172800 | 0 | 0 | 3 | | -1 | | 10 | 172800 | 0 | 0 | 3 | | -1 | | 11 | 172800 | 0 | 0 | 3 | | -1 | | 12 | 172800 | 0 | 0 | 3 | | -1 | | 13 | 172800 | 0 | 0 | 3 | | -1 | | 14 | 172800 | 0 | 1317900964 | 3 | | -1 | | 42 | 172800 | 0 | 0 | 3 | | -1 | | 57 | 172800 | 0 | 0 | 3 | | -1 | +------------------+------------------------+-----------------------------+-----------------------+------------------+--------------------------+----------------+
2. Verfication after changing the the expiration date and before the runing the cronjob
+------------------+------------------------+-----------------------------+-----------------------+------------------+--------------------------+----------------+ | contentobject_id | expirationnotification | expirationnotification_sent | password_last_updated | passwordlifetime | passwordvalidationregexp | updatechildren | +------------------+------------------------+-----------------------------+-----------------------+------------------+--------------------------+----------------+ | 4 | 172800 | 0 | 0 | 3 | | -1 | | 10 | 172800 | 0 | 0 | 3 | | -1 | | 11 | 172800 | 0 | 0 | 4 | | 1 | | 12 | 172800 | 0 | 0 | 3 | | -1 | | 13 | 172800 | 0 | 0 | 3 | | -1 | | 14 | 172800 | 0 | 1317900964 | 3 | | -1 | | 42 | 172800 | 0 | 0 | 3 | | -1 | | 57 | 172800 | 0 | 0 | 3 | | -1 | +------------------+------------------------+-----------------------------+-----------------------+------------------+--------------------------+----------------+
3. Verification after the cronjob
+------------------+------------------------+-----------------------------+-----------------------+------------------+--------------------------+----------------+ | contentobject_id | expirationnotification | expirationnotification_sent | password_last_updated | passwordlifetime | passwordvalidationregexp | updatechildren | +------------------+------------------------+-----------------------------+-----------------------+------------------+--------------------------+----------------+ | 4 | 172800 | 0 | 0 | 3 | | -1 | | 10 | 172800 | 0 | 0 | 3 | | -1 | | 11 | 172800 | 0 | 0 | 4 | | 0 | | 12 | 172800 | 0 | 0 | 3 | | -1 | | 13 | 172800 | 0 | 0 | 3 | | -1 | | 14 | 172800 | 0 | 1317900964 | 3 | | -1 | | 42 | 172800 | 0 | 0 | 3 | | -1 | | 57 | 172800 | 0 | 0 | 4 | | -1 | +------------------+------------------------+-----------------------------+-----------------------+------------------+--------------------------+----------------+
Steps to reproduce
Create test user Log in as admin in admin interface Click "User accounts" in top menu Click "Guest accounts" Click "Create here" button First name : te Last name : st Username : test Password : test1 Confirm password : test1 Email : test@example.com Click "Send for publishing" Verify database Run querry : mysql> select * from ezx_mbpaex; Verify that all rows has passwordlifetime=3 Update parent (usergroup) Click "User accounts" in top menu Click "Edit" icon for "Guest accounts" Edit form data: Password LifeTime (DAYS): 4 Update children nodes?: Checked Click "Send for publishing" mysql> select * from ezx_mbpaex; Verify that one row has passwordlifetime=4 and updatechildren=1 On the command line, go to the test instance ( .run/ directory ) $php runcronjobs.php ezmbpaex_updatechildren Verify the result mysql> select * from ezx_mbpaex; Verify that *two* rows now have passwordlifetime=4 Verify that all rows has updatechildren=0