dozens of extra uncategorized grade book columns

dozens of extra uncategorized grade book columns

by Scott B. Johnson -
Number of replies: 1
We recently upgraded, stepwise, from v1.65 to 1.92 and now many grade books, currently running and into history, show several if not scores of extra uncategorized grade book items. I can't find how to delete them. How can I make them go away? We are getting the "Module will state: More than one item in Fetch (!)" message in conjuction with this feature.


In reply to Scott B. Johnson

Re: dozens of extra uncategorized grade book columns

by Ken Gibson -

Scott -

Had the same issue from our end on an upgrade from 1.52-1.9.  Only way to fix is to manually delete from the database.  This is what I did (I have myphpadmin installed):

Note your course ID

- On homepage - Go to Site administartion - server>>database (myphpadmin opens)
- Click on your database (top left)
- Scroll down to mdl_grade_items 
- View the mdl_grade_items  by course ID

- Scroll down to your course ID 
- Delete all databse rows (in the course ID you want) with categorytype=NULL and Itemname=Null.

This will clean out all remnant grades.

Ken 

   

 

-