Last modified: 2008-09-07 22:49:15 UTC
I'm getting the following SQL error in my test wiki:
1267: Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' (localhost)
SELECT ft_tmp_rev_id FROM `flaggedtemplates` WHERE ft_rev_id = '5470' AND ft_namespace = '10' AND ft_title = 'USA_emberes_űrprogram' LIMIT 1
called from FlaggedRevsHooks::parserFetchStableTemplate
The bug only occurs on a specific page and it's nondeterministic, sometimes it appears, sometimes not. The page has been imported from the Hungarian Wikipedia via XML dump.
Both MediaWiki and FlaggedRevs are fresh (r40555), MySQL version is 5.0.32. LocalSettings.php lines that seem relevant:
$wgDBTableOptions = "ENGINE=InnoDB, DEFAULT CHARSET=utf8";
$wgDBmysql5 = true;
I would avoid using $wgDBmysql5, it tends to be broken...
Sounds like /*$wgDBTableOptions*/; wasn't replaced when the SQL table queries were done. This is easiest to do automatically. Drop the tables and run update.php.
Thanks. Does that mean update.php will create the table automatically if it does not exist? Then you could just delete these two lines from readme.txt:
* (MySQL) Run the 'FlaggedRevs.sql' query, substituting in your wiki's table prefix.
* (PostgreSQL) Use 'FlaggedRevs.pg.sql' instead.
Also, update.php seems to expect flaggedrevs.sql in all lowercase.
(In reply to comment #3)
> Thanks. Does that mean update.php will create the table automatically if it
> does not exist? Then you could just delete these two lines from readme.txt:
> * (MySQL) Run the 'FlaggedRevs.sql' query, substituting in your wiki's table
> * (PostgreSQL) Use 'FlaggedRevs.pg.sql' instead.
Already removed :)
(In reply to comment #4)
> Also, update.php seems to expect flaggedrevs.sql in all lowercase.
This was developed on XP, where that doesn't matter. Fixed case in r40600.