mediawiki mysql mixing illegal characters when using hebrew

Reported by Alon Swartz on 2008-12-22
2
Affects Status Importance Assigned to Milestone
TurnKey Linux
Fix Released
High
Alon Swartz
2009.02-hardy-x86
New
Undecided
Unassigned

Bug Description

reported by: arbel
I am using the Turnkey MediaWiki's live cd, and in English every thing is going well. but when I try to use Hebrew, I get a mysql error that I am mixing illegal charecters. So I cant search and I can't link to other pages. is there a way to install Hebrew support?

Alon Swartz (alonswartz) wrote :

reproduced by specifying hebrew in the url (reference: http://he.wikipedia.org)

Database error
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

    (SQL query hidden)

from within function "Article::pageData". MySQL returned error "1267: Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' (localhost)".

Changed in turnkeylinux:
status: New → Confirmed
Alon Swartz (alonswartz) wrote :

workaround: disable experimental charset support
    file: /etc/mediawiki/LocalSettings.php
    setting: $wgDBmysql5 = true; --> $wgDBmysql5 = false;

    example:
    sed --in-place "s/\$wgDBmysql5 = true;/\$wgDBmysql = false;/" /etc/mediawiki/LocalSettings.php

resource: http://www.mediawiki.org/wiki/Manual:$wgDBmysql5
Set to true to engage MySQL 4.1/5.0 charset-related features; for now will just cause sending of 'SET NAMES=utf8' on connect.
You should not generally change this value once installed -- if you create the wiki in Binary or UTF-8 schemas, keep this on! If your wiki was created with the old "backwards-compatible UTF-8" schema, it should stay off.

This setting will be disabled in future versions while experimental.

Changed in turnkeylinux:
assignee: nobody → alonswartz
importance: Undecided → High
status: Confirmed → Triaged
Alon Swartz (alonswartz) on 2008-12-23
Changed in turnkeylinux:
status: Triaged → Confirmed
Alon Swartz (alonswartz) wrote :

fixed in 2009.02 release.

Changed in turnkeylinux:
status: Confirmed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers