Last modified: 2014-02-26 12:55:09 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T47718, the corresponding Phabricator task for complete and up-to-date bug report information.

Bug 45718 - Different Collations specified for the 'log' database vs the tables in them


Summary:	Different Collations specified for the 'log' database vs the tables in them

Status:	RESOLVED FIXED

Product:	Analytics
Classification:	Unclassified
Component:	EventLogging (Other open bugs)
Version:	unspecified
Hardware:	All All

Importance:	Unprioritized normal
Target Milestone:	---
Assigned To:	Ori Livneh

URL:
Whiteboard:
Keywords:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2013-03-05 00:09 UTC by Yuvi Panda
Modified:	2014-02-26 12:55 UTC (History)
CC List:	8 users (show)

See Also:
Web browser:	---
Mobile Platform:	---
Assignee Huggle Beta Tester:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Description Yuvi Panda 2013-03-05 00:09:06 UTC

The database is set to use the collation "latin1_swedish_ci", while the tables are all set to use "utf8_general_ci". This causes problems when you're trying to use computed columns, since they'll be using the database's collation.

Fix would be to set the database's collation to "utf8_general_ci"

Comment 1 Yuvi Panda 2013-03-05 00:09:32 UTC

It errors out with Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,NUMERIC) for operation '>'

Comment 2 Ori Livneh 2013-03-05 06:53:23 UTC

Done:

    > show variables like "character_set_database";
    +------------------------+-------+
    | Variable_name          | Value |
    +------------------------+-------+
    | character_set_database | utf8  |
    +------------------------+-------+
    1 row in set (0.00 sec)

    > show variables like "collation_database";
    +--------------------+-----------------+
    | Variable_name      | Value           |
    +--------------------+-----------------+
    | collation_database | utf8_general_ci |
    +--------------------+-----------------+
    1 row in set (0.01 sec)

Comment 3 Andre Klapper 2014-02-26 12:55:09 UTC

[moving from MediaWiki extensions to Analytics product - see bug 61946]

Wikimedia Bugzilla is closed!

Search

Personal tools

Navigation

Links