[Mediawiki-l] Illegal mix of collations and Extension:DynamicPageList

Alessandra alessandra.bilardi at gmail.com
Tue Jan 20 22:07:19 UTC 2009


Hi all,
I have got install http://www.mediawiki.org/wiki/Extension:DynamicPageList
I'm using it into two wiki web site: gbrowse.org and other internal site.
wiki version is 1.13.1 and DPL version is 1.7.4
I'm testing some tips about dpl as

{{#dpl:
 |category=Animalia{{!}}Plantae{{!}}Archea{{!}}Fungi{{!}}Bacteria{{!}}Protista
 |notnamespace=Category
 |ordermethod=title
 |mode=userformat
 |includepage={Shortcut}:image
 |format=, {{OrganismsList{{!}}name=[[:%NAMESPACE%:%TITLE%|%TITLE%]]{{!}}image=,}},
 |count=1000
}}

it works in http://gbrowse.org/wiki/index.php/GBrowse:Organisms
but it doesn't works in internal site and I have got this error:

The DPL extension (version 1.7.4) produced a SQL statement which lead
to a Database error.
The reason may be an internal error of DPL or an error which you made,
especially when using DPL options like titleregexp.
Query text is:
SELECT DISTINCT `page`.page_namespace as
page_namespace,`page`.page_title as page_title,
REPLACE(REPLACE(CONCAT( IF(`page`.page_namespace=0, , CONCAT(CASE
`page`.page_namespace WHEN 1 THEN 'Talk' WHEN 2 THEN 'User' WHEN 3
THEN 'User_talk' WHEN 4 THEN 'CRIBI_Genomics' WHEN 5 THEN
'CRIBI_Genomics_talk' WHEN 6 THEN 'Image' WHEN 7 THEN 'Image_talk'
WHEN 8 THEN 'MediaWiki' WHEN 9 THEN 'MediaWiki_talk' WHEN 10 THEN
'Template' WHEN 11 THEN 'Template_talk' WHEN 12 THEN 'Help' WHEN 13
THEN 'Help_talk' WHEN 14 THEN 'Category' WHEN 15 THEN 'Category_talk'
END, ':')), `page`.page_title), '_', ' '),'♣','⣣') as sortkey FROM
`page` INNER JOIN `categorylinks` AS cl0 ON `page`.page_id=cl0.cl_from
AND (cl0.cl_to='Grape_Genome_Team') WHERE 1=1 AND
`page`.page_is_redirect=0 ORDER BY sortkey ASC LIMIT 0, 500

Error message is:
Illegal mix of collations (utf8_general_ci,COERCIBLE) and
(latin1_bin,IMPLICIT) for operation 'concat' (localhost)

unique difference about wiki site is that gbrowse.org was born with
1.13.1 wiki version and internal site was upgraded to 1.13.1 wiki
version.
I observed that others have got egual problem:
after upgrade,
http://semeb.com/dpldemo/index.php?title=Issue:DPL_SQL_Error_with_MediaWIki_1.14
after mistake,
http://mwusers.com/forums/showthread.php?t=8707
..

can you help me about?
thanks,
alessandra.



More information about the MediaWiki-l mailing list