Cannot perform logical operations
%DPL-1.6.2-ERROR: Cannot perform logical operations on the Uncategorized pages (e.g. with the 'category' parameter) because the `W_dpl_clview` view does not exist on the database! Help: have the DB admin execute this query: CREATE VIEW `W_dpl_clview` AS SELECT IFNULL(cl_from, page_id) AS cl_from, IFNULL(cl_to, ) AS cl_to, cl_sortkey FROM `W_page` LEFT OUTER JOIN `W_categorylinks` ON `W_page`.page_id=cl_from;
I am the admin, and tried to execute this query only to find that it contains a syntax error. The code I used to generate this is below.
According to the manual dpl supports nested function calls - which is what I am attempting here.
--Uncg 23:00, 18 December 2007 (CET)
I appears as though "IFNULL(cl_to, )" is the cause. I would expect it needs to be "IFNULL(cl_to, page_id)".
--Uncg 23:12, 18 December 2007 (CET)
More corrections need to be made...
--Uncg 23:14, 18 December 2007 (CET)
- Did you omit the 'W_' or did you replace it by the prefix used in your wiki installation?
- Gero 08:45, 22 December 2007 (CET)