2021-04-14, 13:56
(2021-04-14, 10:34)Supay Wrote:(2021-04-13, 21:15)BigMong Wrote: Database Version 119 [aka Matrix]
This has been tested with MySQL Server Version 8.X I don't know if this will (it should) work with lower versions.
Let me know if you have any problems or questions with this.
I believe I have identified an issue. I am receiving a syntax error warning when I run the .sql files. However, I note that you have referenced using MySQL 8.X and I have till now been using MariaDB as that is the commonly available option for docker containers and it is what I run on my Pi Kubernetes cluster. I don't know much about the differences between them, but I have read that there are changes in MySQL 8 that have potentially diverged the two projects now after a long time of retaining compatibility, and the MariaDB pages also do not show current compatibility with MySQL 8. I understand this is likely an issue for those choosing to use MariaDB if you build this for MySQL, but it may generate further posts here if there is a compatibility issue now. You might want to add a clear header to advise if MariaDB is not supported and that people need to use MySQL only now.
Oh shoot, didn't even think about that, I will get MariaDB install on my NAS and do some testing.