[Bug 245897] New: Userbase won't open the unicode pages ending up with error.

[Andrii]

https://bugs.kde.org/show_bug.cgi?id=245897

           Summary: Userbase won't open the unicode pages ending up with
                    error.
           Product: www.kde.org
           Version: unspecified
          Platform: Unlisted Binaries
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: general
        AssignedTo: kde-www at kde.org
        ReportedBy: vityazdron at gmail.com


Version:           unspecified
OS:                Linux

When trying to switch the language of any UserBase page to the one using
unicode (russian, ukrainian, czech, taiwan, etc.) ends up with error.

For the query:
SELECT page_id, page_namespace, page_title, page_len, page_is_redirect,
pp_value FROM `page` LEFT JOIN `page_props` ON pp_propname='hiddencat' AND
pp_page=page_id WHERE (page_namespace=14 AND page_title='С_чего_начать_(ru)')

Error: «1267: Illegal mix of collations (latin1_bin,IMPLICIT) and
(utf8_unicode_ci,COERCIBLE) for operation '=' (localhost)».

In function: «OutputPage::addCategoryLinks»

Example URL: http://userbase.kde.org/Welcome_to_KDE_UserBase/ru

Reproducible: Always

Steps to Reproduce:
On UserBase website select any unicode language in the language box.

Actual Results:  
see Details

Expected Results:  
Switching the language of the page into selected one.

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.