Difference between revisions of "Cannot perform logical operations"
From FollowTheScore
(New page: <pre><nowiki> %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 data...) |
|||
| (3 intermediate revisions by one other user not shown) | |||
| Line 3: | Line 3: | ||
</nowiki></pre> | </nowiki></pre> | ||
| − | I am the admin, and tried to execute this query only to find that it contains a syntax error. | + | 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. | According to the manual dpl supports nested function calls - which is what I am attempting here. | ||
| Line 10: | Line 10: | ||
{{#dpl:category={{#dpl:category={Servers}:Admin1}}|include={Person}:Name|notnamespace=Template|format=,-,}} | {{#dpl:category={{#dpl:category={Servers}:Admin1}}|include={Person}:Name|notnamespace=Template|format=,-,}} | ||
</nowiki></pre> | </nowiki></pre> | ||
| + | |||
| + | --[[User:Uncg|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)". | ||
| + | |||
| + | --[[User:Uncg|Uncg]] 23:12, 18 December 2007 (CET) | ||
| + | |||
| + | More corrections need to be made... | ||
| + | |||
| + | --[[User:Uncg|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? | ||
| + | :[[User:Gero|Gero]] 08:45, 22 December 2007 (CET) | ||
Latest revision as of 09:45, 22 December 2007
%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)
