Could someone explain how to fix this error? I'm starting to see this on my mediawiki site. As an example :
From http://asianmediawiki.com/SP is you click on any of the cast member pages it produces this error message:
Database error
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 "Parser::replaceLinkHolders". MySQL returned error "1271: Illegal mix of collations for operation ' IN ' (asianmediawiki1.asianmediawiki.dreamhosters.com)".
Except for person "Taro Omiya".
Anybody could provide clues on this problems? Thanks
2008/11/11 WikiSysop asianmediawiki@gmail.com:
Could someone explain how to fix this error? I'm starting to see this on my mediawiki site. As an example :
From http://asianmediawiki.com/SP is you click on any of the cast member pages it produces this error message:
Database error
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 "Parser::replaceLinkHolders". MySQL returned error "1271: Illegal mix of collations for operation ' IN ' (asianmediawiki1.asianmediawiki.dreamhosters.com)".
Except for person "Taro Omiya".
Anybody could provide clues on this problems? Thanks
Works for me. Are you still having the problem? If so, does it only occur when you are logged in?
2008/11/11 asianmediawiki:
Could someone explain how to fix this error? I'm starting to see this on my mediawiki site. As an example:
Did it start just by itself or did it began after some update?
From http://asianmediawiki.com/SP is you click on any of the cast member pages it produces this error message:
Database error
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 "Parser::replaceLinkHolders". MySQL returned error "1271: Illegal mix of collations for operation ' IN ' (asianmediawiki1.asianmediawiki.dreamhosters.com)".
You have your tables with different collations. What table format did you choose? Does setting $wgDBmysql5 = false; on localsettings fix it?
Thomas Dalton wrote:
Works for me. Are you still having the problem? If so, does it only occur when you are logged in?
RamenLover removed the multibyte characters from links. See this old version: http://asianmediawiki.com/index.php?title=Shin%27ichi_Tsutsumi&oldid=594...
mediawiki-l@lists.wikimedia.org