Messages

  Entire forum

Auto Light Dark

English

Ran this:

Code Select Expand


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.

Even this:

Code Select Expand


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).

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.

Just took a look at a similar topic, I cant change the collation for some reason.

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:

Code Select Expand


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.

DS, kcmartz is saying that thanks to this mod, he noticed those 20,000 errors that he had before he installed it...

Been inactive, but that's what I meant, yes.

He is not a native english speaker, if you didn't know. He has been a member of my site previously before I 'reformatted' my forum.

Thanks anyway! I'm keeping to a simpler install of smf on my site; if I need this topic again I'll reopen topic

Ok. If it removes the error, I will have to figure out how to integrate Elgg (another social mod) with SMF.

Installed again. I had over 20,000 errors! I had not gone into the error log once since redoing whole site/forum brand new. I got it down to about 4 errors that keep re-appearing. Other than that no errors!

(Sent from my Google Notebook - cr-48 on Verizon Wireless 3g mode)

there were 4 errors total. 2 for Social Groups Lite, and 2 for Simpledesk. None (I checked) have more than 325 lines! there is no line 406!!

I get these two errors below. I JUST installed it. Screenshot attached.

Also: I am using RC4.