Shoutbox Help

[hetal]

Thanks for looking into this...

With your reply I was totally lost on how to fix this problem but I guess this is SMF problem which is causing by some database table not being correct ?  Did I get that right ?

[IchBin]

Do you have access to phpMyAdmin in your control panel for your host?

I don't know if I would consider it an SMF problem. It could be just a database setting that creates a certain collation if the collation is not specified. The collation is what character set the table is using. So if the software you're using doesn't specify a collation, it could automatically use a default setting. And then if you install something that sets a different collation setting, you get the illegal mix of collations error.

Make a backup before you make any changes. If you'd like to try this, here's how. If you have access to phpMyAdmin go into it, and click on your database in the left column. From there you should see something like the attached image #1. Just select the row you need to change by checking the checkbox on the left of the row. Then click the "Operations" tab after selecting the row. Then take a look at image2 attached. You change the collation to match your other tables, and then click go.  Then end, life is good.

[hetal]

I tired to follow your steps on it but it looks like it does not change I even tired one at a time but still it stays in utf8_unicode_ci so most of them are in that type...

[IchBin]

Ask your host if they are restricting permission or something.

[hetal]

Well he said he never did restrict any permission on my phpadmin would be kind to have look at it if send you info...

[IchBin]

Sure, I'll take a look if you need. Go ahead and PM me the info.

[hetal]

Done let me know if you have any problem with login-in

[IchBin]

Ok, I've changed all the collations. This did not fix it. I'm not 100% sure why, but I think it is because your database is set to default ut8_unicode_ci. Thus when a query is run, if character set is not supplied when needed, it defaults to the wrong one since SMF/TP is using utf8_general_ci. My only suggestion at this point would be to ask your host if they can change the default for the mysql server to uft8_general_ci. I highly doubt they will do it, but hey it's worth a shot IMO. Other than that, I'm betting you'll have to change each table, and each row to use ut8_unicode_ci. This will be a tedious task at best. It'll probably take you an hour at least to go through each table to change it.

--edit--
Unless of course, your host would be willing to run the queries to change all those tables and rows to utf8_unicode_ci for you.

[hetal]

Thank You so much ! I would have no idea how to do all that so I guess I have to depend on my host...If not I will have to deal with no shoutbox!


Ones again thank you so much for going one step extra to help me... :angel:

[Joe B]

you can do it yourself by clicking on the browse button of the file you want to change the collation then go to operations and change it there. It will take awhile