Bug 245897

Summary: Userbase won't open the unicode pages and ending up with error.
Product: [Websites] www.kde.org Reporter: Andrii <vityazdron>
Component: generalAssignee: kde-www mailing-list <kde-www>
Status: RESOLVED FIXED    
Severity: normal CC: cannewilson
Priority: NOR    
Version: unspecified   
Target Milestone: ---   
Platform: Unlisted Binaries   
OS: Linux   
Latest Commit: Version Fixed In:
Sentry Crash Report:

Description Andrii 2010-07-27 12:52:56 UTC 
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.
Comment 1 Anne Wilson 2010-08-04 11:16:13 UTC 
There was a database problem after an update.  That was found late on the 26th, and tracked down and fixed on the 28th July.  You should have no problems now.  Please confirm that this is so.
Comment 2 Andrii 2010-08-04 11:27:47 UTC 
Yup, everything is fine. Thanks a lot :)