Votes
For: 0 (0%)
Against: 0 (0%)
Total: 0
January 14, 2009 01:00 AM
csd
Symptom: product-level permissions change 'by themselves' :)
I suspect there is a data type conversion error at the product-level permissions. The permission table has a 'mask smallint NOT NULL' column in the DB, while the permissions from 'canadmingroups' to 'canviewownhidden' have greater values obviously according to the includes/permissions.php file.
Possible solution: extending the data type of permission.mask to integer seams to eliminate the problem.
I suspect there is a data type conversion error at the product-level permissions. The permission table has a 'mask smallint NOT NULL' column in the DB, while the permissions from 'canadmingroups' to 'canviewownhidden' have greater values obviously according to the includes/permissions.php file.
Possible solution: extending the data type of permission.mask to integer seams to eliminate the problem.
January 15, 2009 04:35 PM
Robert
Thanks for catching this. The upgrade script for 1.2.3 will fix the issue. Here are the queries you can use to fix this:
ALTER TABLE bugfieldpermission CHANGE mask mask int unsigned NOT NULL DEFAULT 0;
ALTER TABLE permission CHANGE mask mask int unsigned NOT NULL DEFAULT 0;
--------------- AUTOMATIC RESPONSE ---------------
Thank you for your bug report. This issue has been closed and fixed in git. This change will be available in a future release, but you can download the change at any time from the git repository, found at http://www.bluestatic.org/git/.
ALTER TABLE bugfieldpermission CHANGE mask mask int unsigned NOT NULL DEFAULT 0;
ALTER TABLE permission CHANGE mask mask int unsigned NOT NULL DEFAULT 0;
--------------- AUTOMATIC RESPONSE ---------------
Thank you for your bug report. This issue has been closed and fixed in git. This change will be available in a future release, but you can download the change at any time from the git repository, found at http://www.bluestatic.org/git/.
On January 15, 2009 04:35 PM, Robert changed:
- Status from "Unconfirmed" to "Closed"
- Resolution from "Open" to "Fixed"
- Fixed in Revision from "" to "master/aaf0aa5, 1.2.x/5ed744d"