Messages

  Entire forum

Auto Light Dark

English

Did you change every one of the helpdesk tables? I'm guessing you did if it's working properly. Unfortunately you'll hit the same problem when upgrading SimpleDesk - you'll also hit the same problem if you install things like Aeva Media.

You may have been better modifying the collation for SMF itself to be the same as the tables generated by the package manager (instead of changing the helpdesk to suit SMF, changing SMF to suit the helpdesk will mean no problems in future mod installs)

Ummm, yeah, I changed all the helpdesk tables ... So what should I do now , shall I need to change it back?
Actually, This HelpDesk system is nice to use ... I don't know about coding or somethings similar to that ...

Thanks

It's a known SMF bug, as Nao will more than readily confirm (probably even in Mantis by now, if not it giggly well should be as it IS an SMF bug), where the package manager doesn't properly enforce the same collation as the installer does. Normally only occurs on less well configured shared hosts.

It only kicks in if you use an SMF table and a mod-own table in the same query with different collations, which is applicable here for instance since the ticket-loading query joins to the SMF members table.

The only cure is to modify the table collations manually.

Well , my problem solved ...
I changed the collation of helpdesk db table from utf8_unicode to utf8_general ...
Here is Our Forum helpdesk link ---> http://www.myanmarsarpay.info/Latest/index.php?action=helpdesk;sa=main
Thanks for good Modification and support ...

Yay for SMF bugs.

Do you have access to phpMyAdmin?

Yes, I can access to phpMyAdmin ...
And I changed the collation for SimpleDesk DB Table ... But Still can't solve the problem ...

Shall I need to change the collation for members?

I got the below error when I view the tickets 

Code Select Expand

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation 'ifnull'
File: /home/mmsarpay/public_html/Latest/Sources/Subs-SimpleDesk.php
Line: 450