Articles by alphabetic order
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
 Ā Ī Ñ Ś Ū Ö Ō
1 2 3 4 5 6 7 8 9 0


Difference between revisions of "Template:SeealsoDPL"

From Tibetan Buddhist Encyclopedia
Jump to navigation Jump to search
 
Line 6: Line 6:
 
|redirects = include
 
|redirects = include
 
|noresultsheader=There is no results at the moment 
 
|noresultsheader=There is no results at the moment 
|resultsheader = \n===There are %PAGES% articles including redirects===\n
+
|resultsheader = \n====There are %PAGES% articles including redirects====\n
 
|namespace=
 
|namespace=
 
|titlematch={{{1}}}%¦{{{2}}}%¦{{{3}}}%¦{{{4}}}%¦{{{5}}}%¦{{{6}}}%¦{{{7}}}%¦{{{8}}}%¦{{{9}}}%¦{{{10}}}%
 
|titlematch={{{1}}}%¦{{{2}}}%¦{{{3}}}%¦{{{4}}}%¦{{{5}}}%¦{{{6}}}%¦{{{7}}}%¦{{{8}}}%¦{{{9}}}%¦{{{10}}}%
Line 21: Line 21:
 
|redirects = include
 
|redirects = include
 
|noresultsheader=There is no results at the moment 
 
|noresultsheader=There is no results at the moment 
 +
|resultsheader = \n====There are %PAGES% articles including redirects====\n
 
|namespace=
 
|namespace=
 
|titlematch=%{{{1}}}%¦%{{{2}}}%¦%{{{3}}}%¦%{{{4}}}%¦%{{{5}}}%¦%{{{6}}}%¦%{{{7}}}%¦%{{{8}}}%¦%{{{9}}}%¦%{{{10}}}%
 
|titlematch=%{{{1}}}%¦%{{{2}}}%¦%{{{3}}}%¦%{{{4}}}%¦%{{{5}}}%¦%{{{6}}}%¦%{{{7}}}%¦%{{{8}}}%¦%{{{9}}}%¦%{{{10}}}%

Latest revision as of 17:14, 29 November 2015

[edit]

"{{{1}}}" at the beginning of 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_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}}}%' OR `page`.page_title LIKE '{{{3}}}%' OR `page`.page_title LIKE '{{{4}}}%' OR `page`.page_title LIKE '{{{5}}}%' OR `page`.page_title LIKE '{{{6}}}%' OR `page`.page_title LIKE '{{{7}}}%' OR `page`.page_title LIKE '{{{8}}}%' OR `page`.page_title LIKE '{{{9}}}%' OR `page`.page_title LIKE '{{{10}}}%') GROUP BY `page`.page_id ORDER BY page_title ASC

Error message is:
Unknown column 'page.page_counter' in 'field list' (localhost)



"{{{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_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}}}%' OR `page`.page_title LIKE '%{{{3}}}%' OR `page`.page_title LIKE '%{{{4}}}%' OR `page`.page_title LIKE '%{{{5}}}%' OR `page`.page_title LIKE '%{{{6}}}%' OR `page`.page_title LIKE '%{{{7}}}%' OR `page`.page_title LIKE '%{{{8}}}%' OR `page`.page_title LIKE '%{{{9}}}%' OR `page`.page_title LIKE '%{{{10}}}%') GROUP BY `page`.page_id ORDER BY page_title ASC

Error message is:
Unknown column 'page.page_counter' in 'field list' (localhost)