Martin,
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.
regards,
Jeff
Hardware and performance
What is the minimum MySQL version for 1.5?
This discussion has been locked so you can no longer reply to it.