Difference between revisions of "User:Cowiki"
From Counting Opinions (SQUIRE)
(Blanked the page) |
|||
| Line 1: | Line 1: | ||
| − | + | {{#dpl: | |
| + | |categoryregexp=.+ Case Study | ||
| + | |namespace=Studies | ||
| + | |headingmode=h4 | ||
| + | |mode=unordered | ||
| + | }} | ||
Revision as of 14:15, 11 March 2013
The DPL extension (version 2.01) 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 FROM `page` INNER JOIN `categorylinks` AS cl0 ON `page`.page_id=cl0.cl_from AND (cl0.cl_to REGEXP '.+_Case_Study') WHERE 1=1 AND `page`.page_namespace IN ('112') AND `page`.page_is_redirect=0 ORDER BY page_title ASC LIMIT 0, 500
Error message is:
Character set 'utf8_bin' cannot be used in conjunction with 'binary' in call to regexp_like. (10.39.23.66)