Lessons page statistics not being displayed in siteStats

GENERAL

TESTING

GENERAL

TESTING

Description

The lesson page statistics is not being displayed in the Site Statistic tool. Steps to replicate :

Login as Instructor
Access a site and add the Lessons and Statistics tools
Access the Lessons tool and add some content (Create a couple of pages add some text)
Login to the site a student
Access the Lessons tool and click through the pages to create a read event
As the Instructor access the site and click on the Statistics pages

Expected result :

The Lessons statistics should reflect the correct number of pages and pages read

Actual Result:

The Lessons statistics does not. I still see 0 pages and 0 pages read.

Tested on 11.x, 12.x, and Trunk nightly servers.

Attachments

05 Apr 2018, 05:54 AM
29 Mar 2018, 09:39 AM
29 Mar 2018, 09:38 AM
29 Mar 2018, 06:48 AM
29 Mar 2018, 04:53 AM
28 Mar 2018, 07:39 AM

Linked issues

Activity

Show:

Johan Evelönn April 16, 2018 at 6:34 AM

Thanks @Miguel Pellicer for the information!

I have not been successful in running the script, since I get a timeout. This is probably because my sakai_event table contains to many rows. I changed the script a bit, but I still won't get it to work. It seems like we have a procedure where we move events from the table into another table from time to time, my guess is because it gets to big. So to solve this issue now for me I will probably have to move data from the table, but that kind of breaks the historic statistics, so I guess we will settle for the future statistics issue.

Matthew Jones April 13, 2018 at 7:53 AM

@Miguel Pellicer Yeah, that one needs to be marked as verified then I'll merge it.

Miguel Pellicer April 13, 2018 at 2:59 AM

Thanks @Matthew Jones ,

Would you mind to merge this https://jira.sakaiproject.org/browse/SAK-32104 to 11.x as well?

Matthew Jones April 12, 2018 at 4:27 PM

I pulled an import from https://sakaiproject.atlassian.net/browse/LSNBLDR-790#icft=LSNBLDR-790 and found the 2 conflict dependencies (which made sense to include) and merged this all to 11.x

Miguel Pellicer April 12, 2018 at 3:26 AM

There are two things:

Future events. Apply the software changes to make it work (Including this JIRA and https://jira.sakaiproject.org/browse/SAK-32104)
Past events. Run the scripts (Only the part of 11.4 to 11.5)

The second point is not part of the community release yet, I think I'm the only one who tested them. Would you mind to test them in a dev environment and provide feedback?

Feedback about the entire JIRA will be appreciated too.

Thanks you @Johan Evelönn