Moodle – .vtt Captions do not Work with Internet Explorer

Another thing that works in every other browser but does not work in Internet Explorer. So my solution is to set the MIME type for the .vtt files. This can be done under the Site administration / Server / File types (Moodle >= 2.9). Click on “Add a new file type” button. Set Extension to […]

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