Difference between revisions of "Template:SeealsoDPL"
| Line 6: | Line 6: | ||
|namespace= | |namespace= | ||
|titlematch={{{1}}} %¦{{{2}}} % | |titlematch={{{1}}} %¦{{{2}}} % | ||
| + | |addcategories = true | ||
| + | |addpagecounter = true | ||
| + | |ordermethod=size | ||
| + | | mode=userformat | ||
| + | | listseparators={|class=sortablewikitable id=2\n!Rank\n!Article\n!Bytes\n|-,\n|%NR%.\n|[[%PAGE%]]\n|align=right|%SIZE%,\n|-,\n|} | ||
| + | | count=12 | ||
| + | | columns=3 | ||
}} | }} | ||
Revision as of 07:14, 29 November 2015
Contents
- "{{{1}}}" as separate word at the beginning of the Title
- "{{{1}}}" at the beginning of the Title
- "{{{1}}}" as separate word somewhere in the Title
- "{{{1}}}" anywhere in the Title
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_counter AS page_counter, GROUP_CONCAT(DISTINCT cl_gc.cl_to ORDER BY cl_gc.cl_to ASC SEPARATOR ' | ') AS cats FROM `page` LEFT OUTER JOIN `categorylinks` AS cl_gc ON (page_id=cl_gc.cl_from) WHERE 1=1 AND `page`.page_namespace IN ('0') AND (`page`.page_title LIKE '{{{1}}}\\_%' OR `page`.page_title LIKE '{{{2}}}\\_%') GROUP BY `page`.page_id ORDER BY page_len ASC LIMIT 12 OFFSET 0
Error message is:
Unknown column 'page.page_counter' in 'field list' (localhost)
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 AS sortkey, `page`.page_counter AS page_counter, GROUP_CONCAT(DISTINCT cl_gc.cl_to ORDER BY cl_gc.cl_to ASC SEPARATOR ' | ') AS cats FROM `page` LEFT OUTER JOIN `categorylinks` AS cl_gc ON (page_id=cl_gc.cl_from) WHERE 1=1 AND `page`.page_namespace IN ('0') AND (`page`.page_title LIKE '{{{1}}}%' OR `page`.page_title LIKE '{{{2}}}%') GROUP BY `page`.page_id ORDER BY page_title ASC
Error message is:
Unknown column 'page.page_counter' in 'field list' (localhost)
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 AS sortkey, `page`.page_counter AS page_counter, GROUP_CONCAT(DISTINCT cl_gc.cl_to ORDER BY cl_gc.cl_to ASC SEPARATOR ' | ') AS cats FROM `page` LEFT OUTER JOIN `categorylinks` AS cl_gc ON (page_id=cl_gc.cl_from) WHERE 1=1 AND `page`.page_namespace IN ('0') AND (`page`.page_title LIKE '%\\_{{{1}}}\\_%' OR `page`.page_title LIKE '%\\_{{{2}}}\\_%') GROUP BY `page`.page_id ORDER BY page_title ASC
Error message is:
Unknown column 'page.page_counter' in 'field list' (localhost)
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 AS sortkey, `page`.page_counter AS page_counter, GROUP_CONCAT(DISTINCT cl_gc.cl_to ORDER BY cl_gc.cl_to ASC SEPARATOR ' | ') AS cats FROM `page` LEFT OUTER JOIN `categorylinks` AS cl_gc ON (page_id=cl_gc.cl_from) WHERE 1=1 AND `page`.page_namespace IN ('0') AND (`page`.page_title LIKE '%{{{1}}}%' OR `page`.page_title LIKE '%{{{2}}}%') GROUP BY `page`.page_id ORDER BY page_title ASC
Error message is:
Unknown column 'page.page_counter' in 'field list' (localhost)
