Environment details: Drupal version - 10.2.5, PHP - 8.2.9
Activities are not getting listed under Learning Path or Courses inside Groups.
Facing the below issue:
"rowCount() is supported for DELETE, INSERT, or UPDATE statements performed with structured query builders only, since they would not be portable across database engines otherwise. If the query builders are not sufficient, use a prepareStatement() with an $allow_row_count argument set to TRUE, execute() the Statement and get the number of matched rows via rowCount()." at /core/lib/Drupal/Core/Database/StatementWrapperIterator.php line 244
Create a training path or a course from the groups listing page and proceed till adding the activities.
The activities listing page will not provide any options to add new activities.
Also, if there are existing Training path/Courses, then the activities performed will not be listed.
There would be a console error as show below:
Failed to load resource: the server responded with a status of 500 (Internal Server Error)
against /group//modules/get-items
Patch proposed to modify the below function:
function countActivityInModule
The above function returns the count of activities.
Have fixed the issue by changing the function accordingly.
This patch is tested and is working fine on my environment.
I have reviewed and tested the patch # opigno_learning_path_activities_listing_issue_3450789_1.patch → Working for me and rowCount issue resolved.