Difference between revisions of "Template:SeealsoDPL"
| Line 14: | Line 14: | ||
=At the beginning of the Title= | =At the beginning of the Title= | ||
| − | "'''{{{1}}}'''"{{#if:{{{2}}}|, "'''{{{2}}}'''"}}{{#if:{{{3}}}|, "'''{{{3}}}'''"}}{{#if:{{{4}}}|, "'''{{{4}}}'''"}}{{#if:{{{5}}}|, "'''{{{5}}}'''"}}{{#if:{{{6}}}|, "'''{{{6}}}'''"}} at the beginning of the Title | + | "'''{{{1}}}'''"{{#if:{{{2|}}}|, "'''{{{2|}}}'''"}}{{#if:{{{3|}}}|, "'''{{{3|}}}'''"}}{{#if:{{{4|}}}|, "'''{{{4|}}}'''"}}{{#if:{{{5|}}}|, "'''{{{5|}}}'''"}}{{#if:{{{6|}}}|, "'''{{{6|}}}'''"}} at the beginning of the Title |
{{#dpl: | {{#dpl: | ||
| Line 26: | Line 26: | ||
=As separate word somewhere in the Title= | =As separate word somewhere in the Title= | ||
| − | "'''{{{1}}}'''"{{#if:{{{2}}}|, "'''{{{2}}}'''"}}{{#if:{{{3}}}|, "'''{{{3}}}'''"}}{{#if:{{{4}}}|, "'''{{{4}}}'''"}}{{#if:{{{5}}}|, "'''{{{5}}}'''"}}{{#if:{{{6}}}|, "'''{{{6}}}'''"}} as separate word somewhere in the Title | + | "'''{{{1}}}'''"{{#if:{{{2|}}}|, "'''{{{2|}}}'''"}}{{#if:{{{3|}}}|, "'''{{{3|}}}'''"}}{{#if:{{{4|}}}|, "'''{{{4|}}}'''"}}{{#if:{{{5|}}}|, "'''{{{5|}}}'''"}}{{#if:{{{6|}}}|, "'''{{{6|}}}'''"}} as separate word somewhere in the Title |
{{#dpl: | {{#dpl: | ||
|redirects = include | |redirects = include | ||
| Line 37: | Line 37: | ||
=Anywhere in the Title= | =Anywhere in the Title= | ||
| − | "'''{{{1}}}'''"{{#if:{{{2}}}|, "'''{{{2}}}'''"}}{{#if:{{{3}}}|, "'''{{{3}}}'''"}}{{#if:{{{4}}}|, "'''{{{4}}}'''"}}{{#if:{{{5}}}|, "'''{{{5}}}'''"}}{{#if:{{{6}}}|, "'''{{{6}}}'''"}} anywhere in the Title | + | "'''{{{1}}}'''"{{#if:{{{2|}}}|, "'''{{{2|}}}'''"}}{{#if:{{{3|}}}|, "'''{{{3|}}}'''"}}{{#if:{{{4|}}}|, "'''{{{4|}}}'''"}}{{#if:{{{5|}}}|, "'''{{{5|}}}'''"}}{{#if:{{{6|}}}|, "'''{{{6|}}}'''"}} anywhere in the Title |
{{#dpl: | {{#dpl: | ||
Revision as of 08:47, 29 November 2015
Contents
- As separate word at the beginning of the Title
- At the beginning of the Title
- As separate word somewhere in the Title
- Anywhere in the Title
"{{{1}}}" as separate word 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 ) GROUP BY `page`.page_id ORDER BY page_title ASC
Error message is:
Unknown column 'page.page_counter' in 'field list' (localhost)
"{{{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 ) GROUP BY `page`.page_id ORDER BY page_title ASC
Error message is:
Unknown column 'page.page_counter' in 'field list' (localhost)
"{{{1}}}" as separate word somewhere 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 ) 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 ) GROUP BY `page`.page_id ORDER BY page_title ASC
Error message is:
Unknown column 'page.page_counter' in 'field list' (localhost)
