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.