server is messed up after cpanel tech logged in

NovemberRain

Well-Known Member
Sep 24, 2003
111
3
168
İstanbul
cPanel Access Level
Root Administrator
Hello

I had a problem with 2 of my accounts on the server. Turkish charachters was not displaying correctly and there was "??" sings instead of them. (using mysql 4.1) Other accounts had no problem.

So I sent a support ticket asking what the problem could be. The tech requested the root pass of the server and he said he will have a look.

After this, guess what? He did something and all the sites on the server started to have this problem. Sites which use mysql are full of "??" charachters instead of turkish charachters and most of my customers are using mysql. Now it is not even possible to post a forum message on the sites etc. I always get errors if there is a turkish charachter in the forum post. For example:


Could not insert new word matches

DEBUG MODE

SQL Error : 1267 Illegal mix of collations (latin5_bin,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation ' IN '

INSERT INTO nuke_bbsearch_wordmatch (post_id, word_id, title_match) SELECT 604924, word_id, 0 FROM nuke_bbsearch_wordlist WHERE word_text IN ('ğpğpğ')

Line : 252
File : functions_search.php
This is the same for all kind of mysql enabled scripts, guestbooks, portals, forums etc. All sites have this error, before the tech logged in, I had this problem only with 2 cilents!

I have an open ticket about this issue (108313) but no reply for hours. I have very busy sites and lots of customers sites and they have started complaining.

I don't know what to do.. Any help would be greatly apprecited.

Thank you.
 

NovemberRain

Well-Known Member
Sep 24, 2003
111
3
168
İstanbul
cPanel Access Level
Root Administrator
Thanks chirpy

Still no response from cpanel.. But, I think I figured out what he has done wrong.

I had 2 clients with this problem, the server default charset for mysql was latin1_swedish_ci and it was working ok, then this two clients changed it to "latin5_turkish_ci" only for their accounts, and turkish charachters disappeared. (strange? turkish chars work in latin1 swedish but don't work with latin5 turkish)

Anyway I asked about this problem to cpanel, a tech logged in and changed all accounts charset to "latin5_turkish_ci" and now all sites have this problem. So I guess the variables have to be set to the old values. But I don't know how to do that. I can see the varibles through phpmyadmin.

Current values are: (causes problems)

character set client utf8 latin5
character set connection utf8 latin5
character set database latin5 latin5
character set results utf8 latin5
character set server latin5 latin5
character set system utf8 utf8
character sets dir /usr/share/mysql/charsets/ /usr/share/mysql/charsets/
collation connection utf8_turkish_ci latin5_turkish_ci
collation database latin5_turkish_ci latin5_turkish_ci
collation server latin5_turkish_ci latin5_turkish_ci

Old values: (used to work ok)

character set client utf8 latin1
character set connection utf8 latin1
character set database latin1 latin1
character set results utf8 latin1
character set server latin1 latin1
character set system utf8 utf8
character sets dir /usr/share/mysql/charsets/ /usr/share/mysql/charsets/
collation connection utf8_general_ci latin1_swedish_ci
collation database latin1_swedish_ci latin1_swedish_ci
collation server latin1_swedish_ci latin1_swedish_ci
How can I change these to the old values? I hope it will be solved if I can change them..

Thanks.
 

jackie46

BANNED
Jul 25, 2005
537
0
166
Why didnt you just type history to see what he did. Then you can reverse the process. :p
 

jeroman8

Well-Known Member
Mar 14, 2003
410
0
166
In what file is all these character settings ?

I also have a issue with bad signs (swedish), mostly in Horde but also, what I suspect, outputs from xml files !? Make any sence ?
Since 95% don't have this issue but 5% does I have no idea where to look.