Whole column "level" in users_permission table gets nulled out
- Status
- Open
- Subject
- Whole column "level" in users_permission table gets nulled out
- Version
- 2.x
- Category
- Error
- Feature
- Group
Permission - Submitted by
- RandyH
- Lastmod by
- RandyH
- Rating
- Description
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.
- Solution
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.
- Importance
- 5
- Priority
- 25
- Demonstrate Bug (Tiki 19+)
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Version: Create show2.tiki.org instanceAbout show2.tiki.orgTo help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tiki.org instance. To start, simply select a version and click on "Create show2.tiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show2.tiki.org.
- Ticket ID
- 2537
- Created
- Sunday 31 May, 2009 22:32:02 GMT-0000
by Unknown - LastModif
- Sunday 31 May, 2009 22:37:09 GMT-0000
Attachments
| filename | created | hits | comment | version | filetype | ||
|---|---|---|---|---|---|---|---|
| No attachments for this item | |||||||
;){kind=link}
;){kind=link}
- Needed for Tiki 26: Color mode switch module
- Feature request: Be able to exclude (by category) the pages listed in Latest Changes module
- Add a command to console.php to invalidate certain objects in the search index
- Counting items in Items List Doesn't Work due to lack of , between items
- Modals in Quartz theme are too narrow
;){kind=link}
;){kind=link}