Last modified: 2012-01-16 19:20:32 UTC
Steps to reproduce: 1) Go here: http://prototype.wikimedia.org/rc-en/index.php?title=Sandbox2&action=submit (should not exist, if it does, pick another title) 2) Put "[[File:Дамрак.JPG|250px]]" in the text area 3) Press "Show preview" Expected result: Either an embedded image or a redlink. Actual result: Database error A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: SELECT img_size,img_width,img_height,img_bits,img_media_type,img_major_mime,img_minor_mime,img_metadata,img_timestamp,img_sha1,img_user,img_user_text,img_description FROM `image` WHERE img_name = 'Дамрак.JPG' LIMIT 1 from within function "LocalFile::loadFromDB". Database returned error "1267: Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' (localhost)".
This is because the prototype databases don't have their collations set up right.
Who can fix / reinstall these?
(In reply to comment #2) > Who can fix / reinstall these? I could, if I cared and had time. Or anyone else with shell access to the prototype box, like Aaron, Chad, Sam, or you.
Is it worth actually doing this? Or just wait till they are migrated/recreated?
Labs are coming online, making even less of an incentive to fix this
