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:
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.
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:
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!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
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.