Database query error (1267) while login/signup attempt
Closed, DeclinedPublic
Actions

Assigned To

Authored By

	• bzimport
	Feb 4 2011, 3:27 AM

Description

Author: wiki.mikolka

Description:
I keep getting an error on http://prototype.wikimedia.org/rc-pl/index.php?title=Specjalna:Zaloguj when attemting to login/create an account with my username containing polish diacritical marks (Mikołka). The error notice says:

Błąd bazy danych

Wystąpił błąd składni w zapytaniu do bazy danych. Może to oznaczać błąd w oprogramowaniu. Ostatnie, nieudane zapytanie to:

SELECT gu_id, lu_wiki, gu_salt, gu_password,gu_auth_token, gu_locked,gu_hidden, gu_registration, gu_email, gu_email_authenticated, gu_home_db FROM `globaluser` LEFT OUTER JOIN `localuser` ON gu_name=lu_name AND lu_wiki='rc_plwiki' WHERE gu_name='Mikołka'

wysłane przez funkcję „DatabaseBase::safeQuery”. Baza danych zgłosiła błąd „1267: Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' (localhost)”.

Version: unspecified
Severity: critical
URL: http://prototype.wikimedia.org/rc-pl/index.php?title=Specjalna:Zaloguj

Details

Reference: bz27150

Event Timeline

• bzimport raised the priority of this task from to Medium.Nov 21 2014, 11:12 PM

• bzimport added a project: Wikimedia-Prototype-server.

• bzimport set Reference to bz27150.

• bzimport created this task.Feb 4 2011, 3:27 AM

wiki.mikolka wrote:

MediaWiki version: 1.17alpha (r81444)

Hrm. Thanks, this looks like it might affect deployment.

Bryan.TongMinh wrote:

I think this is caused by [[Manual:$wgDBmysql5]] = true; which is not set on Wikimedia.

This generally indicates that the databases haven't been properly maintained and there's a mismatch in data types between various tables.

Most likely an ops issue for prototype server?

The prototype server is being decommissioned hence any issue with it will disappear whenever the shutdown button is pressed.

Database query error (1267) while login/signup attemptClosed, DeclinedPublicActions

Description

Details

Event Timeline

Database query error (1267) while login/signup attempt
Closed, DeclinedPublic
Actions