Is anyone else getting an error that the scheduled task is failing?

Execute scheduled task: Clear all unfinished tasks from last weeks schedule and put them into the planning storage again. Clear all tasks that are not associated to any course (course has been deleted). (block_exacomp\task\clear_exacomp_weekly_schedule)
... started 12:37:01. Current memory use 24.8 MB.
Debugging increased temporarily due to faildelay of 86400
Exabis Competence Grid: clear_exacomp_weekly_schedule task is running:
... used 1 dbqueries
... used 0.0056509971618652 seconds
Scheduled task failed: Clear all unfinished tasks from last weeks schedule and put them into the planning storage again. Clear all tasks that are not associated to any course (course has been deleted). (block_exacomp\task\clear_exacomp_weekly_schedule),Error writing to database
Debug info:
You can't specify target table 'schedule' for update in FROM clause
UPDATE mdl_block_exacompschedule schedule
JOIN mdl_block_exacompexamples ex ON ex.id = schedule.exampleid
SET schedule.start = null, schedule.endtime = null
WHERE schedule.start > ?
AND schedule.start < ?
AND ex.blocking_event = 0
AND schedule.id NOT IN (SELECT sched.id FROM mdl_block_exacompschedule sched
JOIN mdl_block_exacompitem_mm item_mm ON sched.exampleid = item_mm.exacomp_record_id
JOIN mdl_block_exaportitem item ON item_mm.itemid = item.id
WHERE sched.start > ?
AND sched.start < ?)
[array (
0 => 1696160221,
1 => 1696765021,
2 => 1696160221,
3 => 1696765021,
)]
Backtrace:
* line 293 of /lib/dml/moodle_read_slave_trait.php: call to moodle_database->query_end()
* line 1176 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->query_end()
* line 14722 of /blocks/exacomp/lib/lib.php: call to mysqli_native_moodle_database->execute()
* line 36 of /blocks/exacomp/classes/task/clear_exacomp_weekly_schedule.php: call to block_exacomp_clear_exacomp_weekly_schedule()
* line 263 of /lib/cronlib.php: call to block_exacomp\task\clear_exacomp_weekly_schedule->execute()
* line 120 of /lib/cronlib.php: call to cron_run_inner_scheduled_task()
* line 73 of /lib/cronlib.php: call to cron_run_scheduled_tasks()
* line 178 of /admin/cli/cron.php: call to cron_run()

@Graham Wilmott,

In our Instances the cronjob works without any errors.
Please let us know what Mysql-Version you are currently using.

@pro-web

I am using Moodle 4.1.5 (will upgrade to 4.1.6 soon), with PHP7.4 and MySQL 5.7.43

@Andreas Riepl,

I have been working with Moodle internal competency framework hence having a hard time to understand the following:
1. What is the main difference between Moodle CBE (Competency-Based Education) compare to Exabis Competence Gird.
2. What is the Pros & Cons choosing one over another.
3. Is Exabis Competence Grid more focus on teachers-student usages only instead an organization setup the their own competency framework that to be use through out any curriculum inside their LMS.

Hello Talha! The difference would be that exabis works with competence grids (like language-grids from level A1-C2). By doing this it is possible to define the level of a learner and the goal - this is what our software developments relate to. We have built a script that synchronizes from between Moodle-competences and our block. A block is not part of the core of Moodle, so we have to work it this way. We import data to our block from the free tool comet.edustandards.org where competence grids can be developed. These can have both organisational perspectives as well as curricula for any subject. Regards, Andreas

@Andreas Riepl,

Thank you so much. It does help me understand the difference between Moodle (CBE) & Exabis Competence Grid. I would highly appreciated if you can point me to some Webinar / Tutorials / Help documents that can get me started. Again highly appreciated.

Hello Talha, we will get back to you on this shortly!

Hello @Talha! Regarding your question about documentation and learning materials on Exabis Competencies, you will find the documentation under this link: https://www.exabis.at/en/competence-grids/pedagogical-concept/competence-grids-dakora
The documentation is in the right panel (docs).
I have also messaged you privately regarding live sessions and webinars. I hope this will help! Regards, Paula

Hello,
we have the the PHP Warning: Declaration of block_exacomp\common\SimpleXMLElement::addChild(block_exacomp\common\mixed $name, ?string $value = NULL, ?string $namespace = NULL): ?SimpleXMLElement should be compatible with SimpleXMLElement::addChild($name, $value = NULL, $ns = NULL) in /var/www/html-moodle.stud/blocks/exacomp/lib/common.php on line 140

Is this due to an outdated PHP version?

best regards

Dear Thomas Siermann,

Please let us know what PHP version you are using, seems like PHP 7.x?
you can try to find this line in the code:
public function addChild(mixed $name ...
and try to remove the "mixed" keyword, like so:
public function addChild($name ...

best regards

Hello @pro-web,
our moodle is hosting with php 7.4.33.
If editing the code dosen't help, Would upgrading php help?

best regards

Just created an issue for M4.4 / PHP 8.1 /MariaDB - CRON task failure : https://github.com/gtn/exacomp/issues/30

Is there a bug in the `block_exacomp` plugin. I see the following error in the logs. I'm on Moodle 4.5:
Debug info:
You can't specify target table 'mdlnv_block_exacompschedule' for update in FROM clause
UPDATE mdlnv_block_exacompschedule
SET start = null, endtime = null, is_overdue = 1
WHERE id IN (
SELECT schedule.id
FROM mdlnv_block_exacompschedule schedule
JOIN mdlnv_block_exacompexamples ex ON ex.id = schedule.exampleid
WHERE schedule.start > ?
AND schedule.start < ?
AND ex.blocking_event = 0
AND schedule.id NOT IN (
SELECT sched.id
-- select table inside a subquery, because else we get a
-- 'You can't specify target table 'schedule' for update in FROM clause'
-- error
FROM (SELECT id, exampleid, start FROM mdlnv_block_exacompschedule) AS sched
JOIN mdlnv_block_exacompitem_mm item_mm ON sched.exampleid = item_mm.exacomp_record_id
JOIN mdlnv_block_exaportitem item ON item_mm.itemid = item.id
WHERE sched.start > ?
AND sched.start < ?
)
)
[array (
0 => 1728002740,
1 => 1728607540,
2 => 1728002740,
3 => 1728607540,
)]
Backtrace:
* line 293 of /lib/dml/moodle_read_slave_trait.php: call to moodle_database->query_end()
* line 1258 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->query_end()
* line 14785 of /blocks/exacomp/lib/lib.php: call to mysqli_native_moodle_database->execute()
* line 36 of /blocks/exacomp/classes/task/clear_exacomp_weekly_schedule.php: call to block_exacomp_clear_exacomp_weekly_schedule()
* line 410 of /lib/classes/cron.php: call to block_exacomp\task\clear_exacomp_weekly_schedule->execute()
* line 208 of /lib/classes/cron.php: call to core\cron::run_inner_scheduled_task()
* line 125 of /lib/classes/cron.php: call to core\cron::run_scheduled_tasks()
* line 186 of /admin/cli/cron.php: call to core\cron::run_main_process()

Hello, we are working on it and will update shortly, thanks, Andreas

Hello,
the bug in the clear_exacomp_weekly_schedule has been fixed in the experimental branch and will be solved with the next update.
Thanks
kind regards
Richard