Bug 245897 - Userbase won't open the unicode pages and ending up with error.
Summary: Userbase won't open the unicode pages and ending up with error.
Status: RESOLVED FIXED
Alias: None
Product: www.kde.org
Classification: Websites
Component: general (show other bugs)
Version: unspecified
Platform: Unlisted Binaries Linux
: NOR normal
Target Milestone: ---
Assignee: kde-www mailing-list
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-07-27 12:52 UTC by Andrii
Modified: 2010-08-04 11:27 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
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 :)