Whole column "level" in users_permission table gets nulled out

• Error

Confirmed on clean install of 2.4. Testing on opensourcecms.org, it does not appear this bug carried into 3.0. Have not found this reported in the forums nor bug tracker.

Since upgrading to 2.4 (sorry, only have Fantastico), there is a bug introduced with the permission level assignment capability (level configuration at bottom of tiki-assignpermission.php page). If used once as expected / described, then any further "update" to permissions in that same group will Null out the whole "Level" column in the users_permission table.

Go to groups, admin a group, admin its permissions. Click "level configuration: show" way at the bottom. Do an assign of a level to that group and hit update. Once done, simply hit the normal "update" button in the "assign permissions" section. Does not matter if you change a permission or not. Now if you try to "level configuration: show" again, the level fields for every permission are nulled out and no levels appear in the "assign" list at the bottom of the page. Browsing the table in PHPMyAdmin confirms this behavior.

Note that you do not have to do a level assign a second time. Simply trying to change the inclusion of any individual permission (or making no changes but simply clicking the update button in assign permissions) will cause this to occur. Also, it does not matter whether "level configurations" are shown or hidden.

Have not tried to spelunk into the code base.

User level recovery is to extract the appropriate code from tiki.sql to recreate the table in phpmyadmin as it existed at install. Any local changes the user may have made to create new levels and new assignments of levels to permission are obviously lost.

Would like to know if patch is available until I can upgrade to 3.0. Seems I am in making permission changes often on 3 different installations I have setup and am still tuning and adding features to.

This bug has been demonstrated on show2.tiki.org

Please demonstrate your bug on show2.tiki.org

This bug has been demonstrated on show.tikiwiki.org

Please demonstrate your bug on show.tikiwiki.org