The following was sent from my IT person, and might be helpful to others:
We had problems updating to Moodle 3.5 using MySQL 8.0 because the word system is a reserved word. Had to make the following changes:
The following was sent from my IT person, and might be helpful to others:
We had problems updating to Moodle 3.5 using MySQL 8.0 because the word system is a reserved word. Had to make the following changes:
Hi Debbie,
TNX for sharing your issue and solution too: when working at MDL-60793 we believed people would jump to 3.5 via 3.3 or 3.4 - by updating first to the latest 3.3.x/3.4.y available and still working w/ MySQL 5.7 and then moving to MySQL 8 being then Moodle compatible with it -, but eventually we were wrong .
Could you give us more details on how you moved to MySQL 8.x running what version of Moodle before upgrading?
The more the better : I'm going to file an issue into the Tracker, including proposing a fix compatible with all the DB supported by Moodle.
HTH,
Matteo
The following was the information that my IT person sent me:
TNX Debbie!
I'll file the issue into the Tracker.
Moodle addressed all the known issues - both in the modules code and in the unit tests testing some edge cases in the DB API - around MySQL 8 since 3.3.7/3.4.4/3.5.1, even if MDL-59098 is still open for some feedback.
HTH,
Matteo
many thanks for your solution. We have just successfully upgraded to mysql 8.0.3 an moodle 3.5.1 after reading your contribution.
You are welcome!