DNN Course Gradebook 1.3.1 - Edit Grade Bug
I have been notified of an error with the Course Gradebook Module version 1.3.1 where if you try to edit a users grade that you will end up putting a duplicate grade in the system. I will provide a fix below that can be ran via the "SQL" option from the host account for anyone that is using the current version of the module. Also in the next release of this module I will be including this fix as well as data integrity constraint code that will prevent this issue from occuring.
To perform the temporary fix simply run the below script from the "SQL" menu under the host menu. Be sure to check the box next to "Run as Script".
ALTER PROCEDURE dbo.ICG_GetUserGradebook
@PortalId int,
@CourseId int,
@UserId int
AS
--Doing a left outer join to ensure that all assignments will show,
-- joining to username in the join clase this ensures we always have all records.
SELECT a.AssignmentId,
a.AssignmentName,
a.PointsPossible,
a.DueDate,
ISNULL(ua.UserAssignmentId, -1) AS "UserAssignmentId",
ua.Score AS "ScoreReceived",
ua.DateEntered AS "DateGraded"
FROM ICG_Assignments a
LEFT OUTER JOIN ICG_UserAssignments ua
ON (a.assignmentId = ua.AssignmentId
AND ua.UserId = @UserId)
WHERE a.PortalId = @PortalId
AND a.CourseId = @CourseId
ORDER BY a.DueDate, a.AssignmentName
Sorry for the troubles, if anyone needs assistance implementing this fix, or cleaning up any incorrect data please e-mail me!
Posted by Mitchel on Thursday, July 19, 2007
Name (required)
Email (required)
Website