2021-04-14, 19:02
(2021-04-14, 13:59)Supay Wrote:(2021-04-14, 13:56)BigMong Wrote:(2021-04-14, 10:34)Supay Wrote: 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.
Thank you, BigMong! If you have a beer fund donation anywhere, let me know as you deserve it.
After my last post I was like Ha! bet it's a Char Set stuff
I have update my main post about it as below.
Please Note:
Lower Versions or MariaDB 10 you will need to change the Character Set and Collate.
Within each file do a find and replace in this order;
utf8mb4_0900_ai_ci -> utf8_general_ci
utf8mb4 -> utf8
Now I didn't ask for a error you was getting but that's the error I got on MariaDB 10 till I update the Char Set and Collate, if your getting something else please let me know
If you like to know a little more about the change take a look at this. It's not some dev blog (but that is linked within the post) so it's easier to understand
https://www.monolune.com/what-is-the-utf...collation/