Template:SeealsoDPL

[edit]

• "{{{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_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 (LOWER(CAST(`page`.page_title AS char)) LIKE '{{{1}}}' OR LOWER(CAST(`page`.page_title AS char)) LIKE ',\\_' OR LOWER(CAST(`page`.page_title AS char)) LIKE 'x' OR LOWER(CAST(`page`.page_title AS char)) LIKE 'x\\_%' OR LOWER(CAST(`page`.page_title AS char)) LIKE OR LOWER(CAST(`page`.page_title AS char)) LIKE ) 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 (LOWER(CAST(`page`.page_title AS char)) LIKE '{{{1}}}%') 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 (LOWER(CAST(`page`.page_title AS char)) LIKE '%\\_{{{1}}}\\_%') 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 (LOWER(CAST(`page`.page_title AS char)) LIKE '%{{{1}}}%') GROUP BY `page`.page_id ORDER BY page_title ASC

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