After uploading a new zip file against our scorm module within our course, all of the student previous attempt data is now missing (obtained when you click on the 'view reports for n attempts' link - which takes you to mod/scorm/report.php?id=7). We have done this several times and this has never happened before so I am now trying to see what went wrong and if I can fix it.
I have been looking at the database to see how the data all links together and all of the ids look correct within the tables so I cannot figure out why the link to the data has been 'broken' and is not being pulled out of the database anymore. The tracking data is still within the database.
To help me understand does any developer out there know the sql used for this report? I have been sifting through the code files and have established that the report is displayed within the following line:
but can not find the sql statement created from this function.
Any help/pointers in the right direction would be much appreciated.