Difference between revisions of "EvaluationResAtt"
| Line 20: | Line 20: | ||
,CONCAT('{{schedule-TaskAbbrev{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'}}')=Service | ,CONCAT('{{schedule-TaskAbbrev{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'}}')=Service | ||
,CONCAT('{{evaluationResAtt-attending{{#urldecode:%7C}}',scheduleRFA.StaffAbbrev,'{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRFA.Date,'{{#urldecode:%7C}}',scheduleRFA.UID,'}}')=Attending | ,CONCAT('{{evaluationResAtt-attending{{#urldecode:%7C}}',scheduleRFA.StaffAbbrev,'{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRFA.Date,'{{#urldecode:%7C}}',scheduleRFA.UID,'}}')=Attending | ||
| − | |where=YEAR(scheduleRFA.Date)={{#time: Y|{{Timezone}}}} AND scheduleRFA.ResAbbrev='CFH' AND WEEKDAY(scheduleRFA.Date)=0 AND evaluationResAtt._pageName IS NULL AND WEEK(scheduleRFA.Date) <= '{{#time: W}}' | + | |where=YEAR(scheduleRFA.Date)={{#time: Y|{{Timezone}}}} AND scheduleRFA.ResAbbrev='CFH' AND WEEKDAY(scheduleRFA.Date)=0 AND evaluationResAtt._pageName IS NULL AND WEEK(scheduleRFA.Date) <= ''{{#expr: {{#time: W|{{Timezone}}}} - 1 }}'' |
|order by=scheduleRFA.Date ASC | |order by=scheduleRFA.Date ASC | ||
|rows per page=50 | |rows per page=50 | ||
Revision as of 11:56, July 22, 2020
|
|
|
|
|
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleRFA`.`Date` AS `Week Of`,CONCAT('{{schedule-TaskAbbrev|',`cargo__scheduleRFA`.`TaskAbbrev`,'}}') AS `Service`,CONCAT('{{evaluationResAtt-attending|',`cargo__scheduleRFA`.`StaffAbbrev`,'|',`cargo__scheduleRFA`.`TaskAbbrev`,'|',`cargo__scheduleRFA`.`Date`,'|',`cargo__scheduleRFA`.`UID`,'}}') AS `Attending`,`cargo__scheduleRFA`.`Date__precision` AS `Week Of__precision` FROM `cargo__scheduleRFA` LEFT OUTER JOIN `cargo__evaluationResAtt` ON ((`cargo__scheduleRFA`.`UID`=`cargo__evaluationResAtt`.`UID`)) WHERE YEAR(`cargo__scheduleRFA`.`Date`)=2025 AND `cargo__scheduleRFA`.`ResAbbrev`='CFH' AND WEEKDAY(`cargo__scheduleRFA`.`Date`)=0 AND `cargo__evaluationResAtt`.`_pageName` IS NULL AND WEEK(`cargo__scheduleRFA`.`Date`) <= 3 ORDER BY `cargo__scheduleRFA`.`Date` LIMIT 100000 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '3 ORDER BY `cargo__scheduleRFA`.`Date` LIMIT 100000' at line 1 (172.27.81.126:30004) |
|
