Listing Display
Bug Id ?
148
Reporter ?
csd
Product/Version ?
Bugdar / 1.2.2
Status ?
Closed
Severity ?
Trivial
Duplicate Of ?
- none -
Fixed in Revision ?
master/aaf0aa5, 1.2.x/5ed744d
Mstone ?
Summary ?
Type mismatch at Product-Level Permission's mask
Report Time ?
January 14, 2009 01:00 AM
Assignment ?
Robert
Resolution ?
Fixed
Priority ?
Normal
Dependencies ?
- none -
Mstone (old) ?


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.

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/.

On January 15, 2009 04:35 PM, Robert changed: