Last modified: 2012-02-28 20:54:48 UTC
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)”.
MediaWiki version: 1.17alpha (r81444)
Hrm. Thanks, this looks like it might affect deployment.
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.