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_... after mistake, http://mwusers.com/forums/showthread.php?t=8707 ..

can you help me about? thanks, alessandra.