Difference between revisions of "Template:Glossary builder"

From 2value wiki 2
Jump to navigation Jump to search
(Created page with '{{#dpl: | namespace = {{NAMESPACE}} |category = {{{category|Glossary terms}}} |format = ,\n==%TITLE%==\n\n,, |notnamespace...')
 
Line 1: Line 1:
 
{{#dpl:
 
{{#dpl:
| namespace              = {{NAMESPACE}}
+
|namespace              = {{NAMESPACE}}
|category                = {{{category|Glossary terms}}}
+
|category                = {{{1|Glossary terms}}}
 
|format                  = ,\n==[[%PAGE%|%TITLE%]]==\n\n,,
 
|format                  = ,\n==[[%PAGE%|%TITLE%]]==\n\n,,
 
|notnamespace            = Category
 
|notnamespace            = Category

Revision as of 15:07, 18 September 2009

The DPL extension (version 2.3.0) 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,`page`.page_id AS page_id, `page`.page_title COLLATE latin1_general_ci AS sortkey FROM `page` INNER JOIN `categorylinks` AS cl0 ON `page`.page_id=cl0.cl_from AND (cl0.cl_to='Glossary_terms') WHERE 1=1 AND `page`.page_namespace IN ('10') AND `page`.page_namespace NOT IN ('14','10') ORDER BY page_title ASC LIMIT 500 OFFSET 0

Error message is:
COLLATION 'latin1_general_ci' is not valid for CHARACTER SET 'binary' (localhost)