As the MySQL manual states the INNER JOIN with join conditions works from 3.23.17, however the regular JOIN and CROSS JOIN do not work with join conditions until 4.0.11. The majority (all?) of the files I flagged in the previous post were using the regular JOIN with join conditions and thus were not working in our 3.23.58 install of MySQL.
From the documentation it appears that in order to use JOIN safely MySQL users must be running version 4.0.11 or greater. It looks like we are moving to 4.0.25, here but, this will probably be an issue for other Moodle users and I just wanted to bring it to attention.
Hardware and performance
What is the minimum MySQL version for 1.5?
This discussion has been locked because a year has elapsed since the last post. Please start a new discussion topic.