Another Moodle report – List of users in a course with enrolment and access info

A report was needed by my client to list participants in a course with access info, so those who did not access the course can be warned to perform the mandatory quiz before closing it. SELECT u.firstname, u.lastname, u.idnumber, c.shortname, IF(ue.status = 0, ‘Active’, ‘Suspended’) as status, e.enrol, FROM_UNIXTIME(ue.timecreated, ‘%m/%d/%Y %h:%i:%s %p’) as enrollment_date, IF(ue.timestart = […]

Moodle – Filepicker not working in 2.7.1+ on HTTPS

As a request to our client we changed to HTTPS on our server for their Moodle 2.7.1+ instance. I configured the site, but after the change the file picker stopped working. I have found that Chrome console shows the following: Failed to load resource: the server responded with a status of 404 (Not Found) https://c328740.ssl.cf1.rackcdn.com/mathjax/2.3-latest/MathJax.js?delayStartupUntil=configured Uncaught […]

MySQL Out of Resources Error

Checking my automated backup I realized that one of my database dump is empty. I chechked the database and it was ok. I tried a manual dump and I got this: mysqldump: Couldn’t execute ‘Lock tables on `tablename`’: Out of resources when opening file ‘./databasename/tablename###.MYD’ After some googling I found a solution. I have the following […]

Another Moodle report – List submitted files of an assignment by cohort users

My boss wanted a report to show who had submitted a certification of their debit by courses. We have approximately 120 courses. All courses have a consultant with teacher role. All the student are in separate cohorts. Each cohorts added  one-by-one to courses so one cohort to one course.  Consultants need to know who paid or […]