https://bugzilla.wikimedia.org/show_bug.cgi?id=19085
David Biesack <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #3 from David Biesack <[email protected]> 2009-06-05 19:19:05 UTC --- (In reply to comment #2) > I've fixed this now by running the following SQL query on the wikidb: > > ALTER TABLE `smw_atts2` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; > ... > I have a similar problem installing SMW/Semantic Forms on MediaWiki 1.11.1 I get A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "SMW::getUnusedPropertySubjects". MySQL returned error "1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_bin,IMPLICIT) for operation '=' (<hostname>)". I am not a MySQL DBA all. How should I change the SQL above, if at all? I don't know from the message which table is using latin1_swedish_ci and which is using latin1_bin. i.e. do I need to change the SMW tables to use latin1_swedish_ci instead of utf8/utf8_general_ci ? If so, what ALTER TABLE statement options? i.e. ALTER TABLE `smw_atts2` CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci; -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
