CHARACTER SET ERROR on upgrade attempt
I was trying to upgrade from v3.08 (build 2120) to v3.11. After uploading/replacing the cmsb folder and then attempting to go to the admin.php page, I get this browser error:
mysqli: error setting character set utf8mb4: Can't initialize character set utf8mb4 (path: /usr/share/mysql/charsets/)
The host is running php 5.6.31. They are not upgrading to php 7 until March 2018. I do have access to the cpanel - in phpMyAdmin it shows the following:
- Server connection collation: utf8_general_ci
- Server charset: UTF-8 Unicode (utf8)
- PHP extension: mysqli
I converted back to the previous working version until I could get some advice on this error.
Thank you! Tina
Thanks for reporting this, I've never seen that error before. I can take a look at this directly for you if you like. Can you email me CMS & FTP login details as well as a link to this forum thread to email@example.com? Note, don't post login details to the forum.
It's a default part of MySQL 5.5 so it should be supported. I've attached a test script. Just set your mysql details at the top of the script. You can find them in your /data/settings file.
Can you let me know the output and what your host says? Also, who is your host? I'm wondering if it's the same host.
I cannot connect to the mysql with only localhost, username and password but without db name, I'm getting
Failed to connect to MySQL: (1045)Thanks,