| Problem with polish character set on new install [message #28446] |
Tue, 25 October 2005 10:43  |
bialy
Messages: 2
Registered: October 2005
Karma: 0
|
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. 
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,
|
|
|
|
|
|
| Re: Problem with polish character set on new install [message #28491 is a reply to message #28450] |
Wed, 26 October 2005 18:24  |
bialy
Messages: 2
Registered: October 2005
Karma: 0
|
Junior Member |
|
|
| Ilia wrote on Tue, 25 October 2005 09:16 |
You need to alter the collation settings of the individual tables.
|
How? There are the same settings of collation in database on old server. I don't know what is the difference between these two configurations.
|
|
|
|
|
|
| Re: Problem with polish character set on new install [message #28999 is a reply to message #28496] |
Thu, 24 November 2005 02:38 |
Mikolaj
Messages: 8
Registered: November 2005
Location: Olsztyn, Poland
Karma: 0
|
Junior Member |
|
|
It seems that I've got exactly the same problem:
?866 ?1132795260?(/home/users/plastikowe/public_html/forum/index.php:76<br />
/home/users/plastikowe/public_html/forum/index.php:176<br />
/home/users/plastikowe/public_html/forum/theme/default/login.php:554<br />
/home/users/plastikowe/public_html/forum/index.php:1181<br />
) 1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,COERCIBLE) for operation '='<br />
Query: SELECT id, passwd, login, email, users_opt, ban_expiry FROM fud26_users WHERE login='Piotr Mikołajski'<br />
_GET: array (
't' => 'login',
)<br />
_POST: array (
'SQ' => '0',
'adm' => '1',
)<br />
Server Version: 4.1.12-standard-log
Am I right? And what exactly should I do? I'm pretty far for being MySQL power user and "Check the collation settings of individual tables" unfortunately means nothing to me 
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Problem with polish character set on new install [message #29081 is a reply to message #29079] |
Mon, 28 November 2005 15:18 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
| Quote: |
1. Not all info are translated, i.e. "Show Own Posts" in profile menu, "Access Keys" in help menu or "Syndicate this forum (XML)".
I know that this is minor problem, but it should be corrected. When I find some spare time I'll certainly fix it.
|
Just a matter of a Polish translator catching up to the English translation, temporary issue at best.
| Quote: |
2. English Admin Control Panel and moderator's options, i.e. "Delete All Selected", "Move All Selected".
This is major problem. Your script is far better than very popular phpBB, but many users doesn't speak English. They have to get complete l10n.
|
The admin control panels are left untranslated to keep the code simple, to allow easier recovery when things go wrong.
| Quote: |
3. Database set on latin1 not latin2.
This is huge problem. I'm damn sure that most users have no idea how to run SQL queries and they will not use FUD. I guess that even users who have minor knowledge about phpMyAdmin will not run 51 queries on all tables - it's time consuming.
IMVHO such users should run one script changing all settings to latin2.
|
I'll definately consider adding a control panel to do that.
FUDforum Core Developer
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
because Polish characters are displayed in latin2, not latin1. Proper query is:
]