FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » Problem with polish character set on new install
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Problem with polish character set on new install [message #28446] Tue, 25 October 2005 10:43 Go to previous message
bialy is currently offline  bialy
Messages: 2
Registered: October 2005
Karma:
Junior Member
Hi,

I've got FUDforum installed on one server, about 600 messages, and everything works just fine. I must move it to the new server, and taht's the problem. Razz
I've installed FUD 2.7.3RC3 on new server (same as on old) and everything went just fine, but when I'm trying to post a message with some polish characters the error message is shown:
(/home/grzegorz/domains/hermetic-club.com/public_html/forum/index.php:200
/home/grzegorz/domains/hermetic-club.com/public_html/forum/theme/default/post.php:2763
/home/grzegorz/domains/hermetic-club.com/public_html/forum/theme/default/post.php:1656
/home/grzegorz/domains/hermetic-club.com/public_html/forum/theme/default/post.php:3879
/home/grzegorz/domains/hermetic-club.com/public_html/forum/index.php:1181
) 1270: Illegal mix of collations (latin1_swedish_ci,IMPLICIT), (latin2_general_ci,COERCIBLE), (latin2_general_ci,COERCIBLE) for operation ' IN '
Query: INSERT INTO fud26_index (word_id, msg_id) SELECT id, 2 FROM fud26_search WHERE word IN('odp','ąśćęś')
_GET: array ( 't' => 'post', )
_POST: array ( 'msg_subject' => 'Odp: ???', 'msg_icon' => '', 'fnt_size' => '', 'fnt_color' => '', 'fnt_face' => '', 'msg_body' => 'ąśćęś', 'tmp_f_val' => '1', 'msg_poster_notif' => 'Y', 'msg_show_sig' => 'Y', 'minimsg_pager_switch' => '0', 'S' => '383b7d7d6fd41a90b7b83d9e637fd383', 'SQ' => 'b0b949ecdc20c8b53c00dfce70496cca', 'submitted' => '1', 'reply_to' => '1', 'th_id' => '1', 'frm_id' => '1', 'start' => '0', 'msg_id' => '0', 'pl_id' => '0', 'old_subject' => 'Odp: ???', 'prev_loaded' => '1', 'btn_submit' => 1, )
Server Version: 4.1.10-standard


I think this is something to do with MySQL, but... on first server (where everything works) collation on database and all tables is latin1_swedish_ci. On new server (when the error is produced) default collation of database is latin2_general_ci, which I've changed to latin1_swedish_ci, but error is still showing.

Can you tell me what I'm doing wrong? Or maybe it's problem with new server configuration?

Best regards,
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: ini_set function
Next Topic: svp.ne does not find the way
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 22:01:37 GMT 2024

Total time taken to generate the page: 0.04565 seconds