Situation
Multi Language Tool - Query Error
OpenEMR Version
I’m using OpenEMR version 7.0.3
Browser:
I’m using: Microsoft Edge
Operating System
I’m using: Windows 11
Search
Did you search the forum for similar questions? Yes. No luck.
My issue relates to when I try and search on Multi-Language Tool. I am experiencing a Query Error which states “Error: COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘latin1’”
I have looked through the entirety of my database and there is NO character set as ‘latin1’. I have tried multiple things. I have even asked ChatGPT to talk me through fixing this error but it will not fix!
Please can someone assist me. I am using the most current version of XAMPP. I am using the most current version of OpenEMR and nothing.
Please can someone assist me as to whether this is a bug and if so, how to fix it! Everything else works perfectly however this lets the side down.