Hello, guest. We have noticed that you are not registered at this bug tracker. Your experience will be greatly enhanced if you log in. To do so, you first must register by clicking on the Register tab at the top. If you are already registered, you can login at the Login tab.
Syndicate Syndicate Listing Display Search Login/Register
Bug Id ?
Reporter ?
Bugdar / 1.2.2
Status ?
Severity ?
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 12:00 AM
Assignment ?
Resolution ?
Priority ?
Dependencies ?
- none -
Mstone (old) ?

For: 0 (0%)
Against: 0 (0%)
Total: 0

January 14, 2009 12: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 03: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 03:35 PM, Robert changed: