Calc/Done
Articles that previously appeared in the Calc/To-Dos section about things that have been tackled with.
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, 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 'Apache_OpenOffice_Wiki' WHEN 5 THEN 'Apache_OpenOffice_Wiki_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 274 THEN 'Widget' WHEN 275 THEN 'Widget_talk' WHEN 2300 THEN 'Gadget' WHEN 2301 THEN 'Gadget_talk' WHEN 2302 THEN 'Gadget_definition' WHEN 2303 THEN 'Gadget_definition_talk' END, ':')), `page`.page_title), '_', ' ') AS sortkey, rev_user, rev_user_text, rev_comment, rev_timestamp FROM `revision` AS rev, `page` INNER JOIN `categorylinks` AS cl0 ON `page`.page_id=cl0.cl_from AND (cl0.cl_to='Calc') INNER JOIN `categorylinks` AS cl1 ON `page`.page_id=cl1.cl_from AND (cl1.cl_to='Done') LEFT OUTER JOIN `categorylinks` AS cl2 ON `page`.page_id=cl2.cl_from AND cl2.cl_to='Performance' WHERE 1=1 AND cl2.cl_to IS NULL AND `page`.page_is_redirect=0 AND `page`.page_id=rev.rev_page AND rev.rev_timestamp=( SELECT MAX(rev_aux.rev_timestamp) FROM `revision` AS rev_aux WHERE rev_aux.rev_page=rev.rev_page ) ORDER BY rev_timestamp, sortkey ASC LIMIT 500 OFFSET 0
Error message is:
Unknown column 'rev_user' in 'field list' (127.0.0.1)
