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