Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

microlearning cron failure #1971

Open
Malcolm-GetAHead opened this issue Apr 22, 2024 · 0 comments
Open

microlearning cron failure #1971

Malcolm-GetAHead opened this issue Apr 22, 2024 · 0 comments

Comments

@Malcolm-GetAHead
Copy link

Malcolm-GetAHead commented Apr 22, 2024

I'm receiving the following error in the cron output. This is a newly deployed instance of tag IOMAD_403_3:

Execute scheduled task: IOMAD microlearning cron (block_iomad_microlearning\task\cron_task)
... started 18:33:57. Current memory use 41.7 MB.
Debugging increased temporarily due to faildelay of 60
starting block_microlearning cron at 1713807237
getting list of users who have a new nugget
... used 2 dbqueries
... used 0.0093162059783936 seconds
Scheduled task failed: IOMAD microlearning cron (block_iomad_microlearning\task\cron_task),Error reading from database
Debug info:
ERROR:  operator does not exist: bytea = integer
LINE 3: ...           ON (mtu.threadid = mt.id AND mt.send_message = 1)
                                                                   ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
SELECT mtu.*, mt.companyid FROM mdl_microlearning_thread_user mtu
                                                   JOIN mdl_microlearning_thread mt
                                                   ON (mtu.threadid = mt.id AND mt.send_message = 1)
                                                   AND mtu.message_delivered = 0
                                                   WHERE mtu.timecompleted IS NULL
                                                   AND mtu.schedule_date < $1
[array (
  0 => 1713807237,
)]
Backtrace:
* line 293 of /lib/dml/moodle_read_slave_trait.php: call to moodle_database->query_end()
* line 358 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->read_slave_query_end()
* line 1044 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
* line 977 of /blocks/iomad_microlearning/lib.php: call to pgsql_native_moodle_database->get_records_sql()
* line 46 of /blocks/iomad_microlearning/classes/task/cron_task.php: call to microlearning::cron()
* line 405 of /lib/classes/cron.php: call to block_iomad_microlearning\task\cron_task->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()
*
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant