Calc/Done

From Apache OpenOffice Wiki
Jump to: navigation, search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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)


Personal tools