Cannot perform logical operations

From FollowTheScore
Jump to: navigation, search
%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.

{{#dpl:category={{#dpl:category={Servers}:Admin1}}|include={Person}:Name|notnamespace=Template|format=,-,}}

--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)