Moodle plugin: Aardvark theme – Anchor Offset to Adjust for Fixed Header

I have using Aardvark theme for many years (thanks Shaun). With my latest Aardvark theme deployment I had a problem that the fixed header was relative big (160 pixel) and when using hash tag links in the courses the content of the anchors was covered by the header. I needed to offset the anchors for […]

MAC OS X – Renaming Multiply Filenames to Lowercase in a Directory

You will need the Terminal for this operation. Open Terminal and navigate to the directory using the cd command where you want to change the case of the files. Then run the following command: for FILE in `ls -A1 *`; do FILENAME=`echo ${FILE} | sed ‘s/ /\\ /g’`; echo mv ${FILENAME} `echo ${FILENAME} | tr […]

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) 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 […]