Case Studies

From Counting Opinions (SQUIRE)
Jump to: navigation, search

Case Studies

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 cl_head.cl_to, `page`.page_namespace AS page_namespace,`page`.page_title AS page_title,`page`.page_id AS page_id, REPLACE(CONCAT( IF(`page`.page_namespace=0, , CONCAT(CASE `page`.page_namespace WHEN 1 THEN 'Talk' WHEN 2 THEN 'User' WHEN 3 THEN 'User_talk' WHEN 4 THEN 'Counting_Opinions' WHEN 5 THEN 'Counting_Opinions_talk' WHEN 6 THEN 'File' WHEN 7 THEN 'File_talk' WHEN 8 THEN 'MediaWiki' WHEN 9 THEN 'MediaWiki_talk' WHEN 10 THEN 'Template' WHEN 11 THEN 'Template_talk' WHEN 12 THEN 'Help' WHEN 13 THEN 'Help_talk' WHEN 14 THEN 'Category' WHEN 15 THEN 'Category_talk' WHEN 100 THEN 'LibSatLibrary Customer Satisfaction Management Service' WHEN 101 THEN 'LibSatLibrary Customer Satisfaction Management Service_talk' WHEN 102 THEN 'LibPASLibrary Performance Assessment Service' WHEN 103 THEN 'LibPASLibrary Performance Assessment Service_talk' WHEN 104 THEN 'InformsUsForm, Survey and App Builder Service, also Web Form Builder+' WHEN 105 THEN 'InformsUsForm, Survey and App Builder Service, also Web Form Builder+_talk' WHEN 106 THEN 'News' WHEN 107 THEN 'News_talk' WHEN 108 THEN 'Staff' WHEN 109 THEN 'Staff_talk' WHEN 110 THEN 'Services' WHEN 111 THEN 'Services_talk' WHEN 112 THEN 'Studies' WHEN 113 THEN 'Studies_talk' WHEN 114 THEN 'Support' WHEN 115 THEN 'Support_talk' WHEN 116 THEN 'Minutes' WHEN 117 THEN 'Minutes_talk' WHEN 118 THEN 'CSS' WHEN 119 THEN 'CSS_talk' WHEN 200 THEN 'IPEDSIntegrated Post-Secondary Education Data System' WHEN 201 THEN 'IPEDSIntegrated Post-Secondary Education Data System_talk' WHEN 274 THEN 'Widget' WHEN 275 THEN 'Widget_talk' WHEN 302 THEN 'Property' WHEN 303 THEN 'Property_talk' WHEN 306 THEN 'Form' WHEN 307 THEN 'Form_talk' WHEN 308 THEN 'Concept' WHEN 309 THEN 'Concept_talk' END, ':')), `page`.page_title), '_', ' ') as sortkey FROM `page` LEFT OUTER JOIN `categorylinks` AS cl_head ON (page_id=cl_head.cl_from) INNER JOIN `categorylinks` AS cl0 ON `page`.page_id=cl0.cl_from AND (cl0.cl_to REGEXP '.+tud.+') WHERE 1=1 AND `page`.page_namespace IN ('112') AND `page`.page_is_redirect=0 ORDER BY cl_head.cl_to, sortkey 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)