Exception - count(): Argument #1 ($value) must be of type Countable|array, null given about moodle-report_advancedgrading HOT 6 OPEN

Thanks Richard, any chance you can give me access to a course where this happens?

from moodle-report_advancedgrading.

That is kinda difficult to realize as we do not create accounts in our own Moodle, everyone logs in using ADFS.

What I could do is create a backup from this specific assignment and send it to you? Would that help?

Also, we are using multiple attempts in assignments. Could that be a problem in the report?

from moodle-report_advancedgrading.

Yes a backup/restore would probably help and yes multiple attempts might be an issue (though I have a vague recollection of testing against that).
This report does a similar thing and it would be interesting to know if it runs without error on your site..
https://github.com/brickfield/moodle-gradereport_rubrics

from moodle-report_advancedgrading.

Error message

Exception - count(): Argument #1 ($value) must be of type Countable|array, null given

More information about this error

Debug info:
Error code: generalexceptionmessage×Dismiss this notification
Stack trace:
line 54 of /report/advancedgrading/guide.php: TypeError thrown
×Dismiss this notification
Output buffer:

Looking into the plugin function
https://github.com/marcusgreen/moodle-report_advancedgrading/blob/main/locallib.php#L41

/**

• Get the structure of this grading definition
• @param int $assignid
• @return \stdClass
  */
  function get_grading_definition(int $assignid): \stdClass {
  global $DB;
  $sql = "SELECT gdef.id AS definitionid, ga.activemethod, gdef.name AS definition
  FROM {assign} assign
  JOIN {course_modules} cm ON cm.instance = assign.id
  JOIN {context} ctx ON ctx.instanceid = cm.id
  JOIN {grading_areas} ga ON ctx.id=ga.contextid
  JOIN {grading_definitions} gdef ON ga.id = gdef.areaid
  WHERE assign.id = :assignid";
  $definition = $DB->get_record_sql($sql, ['assignid' => $assignid]);
  return $definition;
  }

The current query has the potential to join to unrelated course module or context records, that is why it is happening the error.

$sql = "SELECT gdef.id AS definitionid, ga.activemethod, gdef.name AS definition
FROM {assign} assign
JOIN {course_modules} cm ON cm.instance = assign.id
JOIN {modules} m ON m.id = cm.module AND m.name = 'assign'
JOIN {context} ctx ON ctx.instanceid = cm.id AND ctx.contextlevel = 70
JOIN {grading_areas} ga ON ctx.id=ga.contextid
JOIN {grading_definitions} gdef ON ga.id = gdef.areaid
WHERE assign.id = :assignid"

from moodle-report_advancedgrading.

I will investigate

from moodle-report_advancedgrading.

I still had this on my to do list, but unfortunately I was unable to share the backup as there's personalized data inside the course.

So thanks to @CristhianBohorquez for sharing additional info.

I think the trouble is the many 0 points in the rubric.

from moodle-report_advancedgrading.