I own a Minecraft server, and I have installed SimpleDesk for members to request staff assistance with something in-game or on-site. I successfully created a ticket, but when trying to view it, I get this:
Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'ifnull'
File: /home/smartz/public_html/minersr.us/Sources/sd_source/Subs-SimpleDesk.php
Line: 758
I have hid the menu item until this is fixed.
Just took a look at a similar topic, I cant change the collation for some reason.
Okay, I manually converted all the database collations to utf8_unicode_ci and still gives me the error, I cleared browser cache, tried in 3 browsers, and cleared site cache.
Even this:
SELECT CONCAT('ALTER TABLE `', t.`TABLE_SCHEMA`, '`.`', t.`TABLE_NAME`, '` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;') as stmt
FROM `information_schema`.`TABLES` t
WHERE 1
AND t.`TABLE_SCHEMA` = 'database_name'
ORDER BY 1
Didn't work (I did change all the information for database_name to the correct name).
Ran this:
alter table <some_table> convert to character set utf8 collate utf8_unicode_ci;
Except for all helpdesk_ prefixes only. Now it works!
Please mark as solved, it gives me an error on this site (no text) on attempting to mark it so.
Yeah, topic solved has been broken a while.
Also, note that any future mods will likely have this same problem as it's yet another flaw in the package manager in SMF, it should really be enforcing a collation.