We have been using Moodle v3.0, and we found v3.5 will be useful for other purposes, so we installed Moodle v3.5 and made other changes (courses, categories, theme, etc.). When we create courses and categories, we made all ids match as v3.0, and everything was working fine.
However, after we imported/appended below data, some courses are missing Scorm package, and doesn't display the course video.
Imported: mdl_cohort, mdl_cohort_member, mdl_enrol, mdl_event, mdl_role_assignments, all user tables
Appended: context users from mdl_context
I checked mdl_files, mdl_context, mdl_course_modules, mdl_course, mdl_scorm, and everything looks fine except mdl_file table has many duplicated records for same filename (ex: CC_001.zip). The component, "mod_scorm", is not duplicated, but the component, "user" has 12 records for same contenthash and filename. I also checked src, and it has /mod/scrom/loadSCO.php?a=12&scoid=24¤torg=videoname&mode=&attempt=1. It seems like "a" is id of mdl_scorm table, but I am not sure what "scoid" is.
Can someone please help me to understand how mdl_file table is working with the Scrom package (.zip file)? I have been looking into it for so long, but I cannot understand how it's working. BTW, we have about 70 files, already uploaded to the server, and most of them are not working. If it's not related with mdl_file table, please let me know what I need to check.
Please let me know if you need more information.