Details
-
Type:
Bug
-
Status: CLOSED
-
Priority:
Blocker
-
Resolution: Fixed
-
Affects Version/s: 12.0, 19.0
-
Component/s: Assignments
-
Labels:None
-
12 status:Resolved
-
Test Plan:
Description
It seems like after the assignment conversion is run, it's not setting the value of "SCALE_FACTOR" in the database. It should probably either
- Set the default value when the conversion is run
- Return the default value from the model if it is null
For people already on 12 I think we can just update them all to their defaults which looks like 100
SET SQL_SAFE_UPDATES = 0; UPDATE ASN_ASSIGNMENT SET SCALE_FACTOR = 10 WHERE SCALE_FACTOR IS NULL AND GRADE_TYPE = 3; SET SQL_SAFE_UPDATES = 1;
You can also update the SCALE_FACTOR to 100 allowing for 2 decimal places with
SET SQL_SAFE_UPDATES = 0; UPDATE ASN_ASSIGNMENT SET SCALE_FACTOR = 100, MAX_GRADE_POINT=(MAX_GRADE_POINT * 10) WHERE SCALE_FACTOR = 10 AND GRADE_TYPE = 3; SET SQL_SAFE_UPDATES = 1;