Event Reminders

Hi. Many thanks for sharing this very useful plugin with the community. We've been using it without issue up until late last week, when the following error started showing up in our cron output (the error effectively prevents the cron from completing):
Warning: Missing argument 6 for get_logs(), called in /var/www/moodle/local/reminders/lib.php on line 70 and defined in /var/www/moodle/lib/datalib.php on line 1945
[Local Reminder] This is the first cron cycle
[Local Reminder] Time window: Saturday, 21 September 2013, 5:19 PM to Monday, 23 September 2013, 5:19 PM
[Local Reminder] Found 17 upcoming events. Continuing...
[Local Reminder] Processing event#2405 [Type: due, inaheadof=1 days]...
[Local Reminder] Finding out users for event#2405...
[Local Reminders] host [ moodle.solihull.ac.uk ]
[Local Reminder] Starting sending reminders for 2405 [type: due]
[Local Reminder] All reminders was sent successfully for event#2405 !
[Local Reminder] Processing event#2436 [Type: due, inaheadof=7 days]...
[Local Reminder] No reminder is due in ahead of 7 for eventtype due [event#2436 is ignored!]...
[Local Reminder] Processing event#2461 [Type: due, inaheadof=1 days]...
[Local Reminder] Finding out users for event#2461...
[Local Reminders] host [ moodle.solihull.ac.uk ]
[Local Reminder] Starting sending reminders for 2461 [type: due]
[Local Reminder] All reminders was sent successfully for event#2461 !
!!! Error reading from database !!!
!! You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{} m ON m.id = cm.instance
WHERE m.id = '105' A' at line 4
SELECT cm.*, m.name, md.name AS modname
FROM mdl_course_modules cm
JOIN mdl_modules md ON md.id = cm.module
JOIN {} m ON m.id = cm.instance
WHERE m.id = ? AND md.name = ?
[array (
0 => '105',
1 => '',
)]
Error code: dmlreadexception !!
!! Stack trace: * line 426 of /lib/dml/moodle_database.php: dml_read_exception thrown
* line 1023 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
* line 1382 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
* line 1551 of /lib/datalib.php: call to moodle_database->get_record_sql()
* line 2016 of /calendar/lib.php: call to get_coursemodule_from_instance()
* line 1940 of /calendar/lib.php: call to calendar_event->calculate_context()
* line 123 of /local/reminders/lib.php: call to calendar_event->__construct()
* line 532 of /lib/cronlib.php: call to local_reminders_cron()
* line 428 of /lib/cronlib.php: call to cron_execute_plugin_type()
* line 88 of /admin/cron.php: call to cron_run()
!!
For now, I've had to disable Reminders to ensure the cron completes successfully; however, I'd really like to restore its functionality if possible. If you have any ideas how I can resolve the above I'd be very grateful for your help.
Thanks.

Hi Isuru,
We are using 'reminders' wihtout problems.
However my 'customers' are asking me if there is any way to send remeinders only to selected roles. I.e. send to students but not to teachers?
Regards,
José Miguel

Hello!
This great plugin doesn't work at moodle 2.5.
I have created an issue here https://tracker.moodle.org/browse/MDL-41139.
Thanks

i guess the next question is When will the update be available for 2.5? in anticipation and thanks

Hi,
We are using Event Reminders in our 2.4 Moodle installation. It works oK.
When event is related with a quiz, reminder reports quiz name and status (first line)
(i.e. THM - MODELO - TRM Nº 2 (Cuestionario cerrado)) = quiz closed.
However with assignments, reminders reports only "assignment name" but not "Allow submissions from" or "Due date" that would be very useful for the student.
Is there any way to send these dates in the reminders?
Regards,
José Miguel

Hi,
Event Reminders works in our 2.3 installations, but it has one flaw. If assignment reminders are enabled, it will send reminders containing the description (with questions links etc) of assignments where the description is hidden until the opening date and time. Thus the students can receive the questions ahead of time even if that was not supposed to happen.

I can't install this on 2.3.4. I get the following error when trying to install:
Event Reminders
/local/reminders
Contributed
Version: 2013042000
Needs: Moodle 2012120300
To be installed
My Moodle version is Moodle 2.3.4 (Build: 20130114)
Any suggestions?

Hi Isuru,
Thank you for your prompt answer. Unfortunatelly, the new version of reminder plugin is not working with my current version of Moodle - v2.3.2.+ and, for the moment, a platform upgrade is excluded. Some advice? Or you will teach me what corrections are nedded for my current version of Reminder?
Thank you again for your help!

Hi Florea,
Identified the issue associated with plugin. I fixed it and released a version for Moodle 2.4.

Hello,
I'm not sure that somebody could help me with some advices related with installing the reminders on moodle v2.3.2+, but leat I'm trying . So, I have successfully installed the reminder on my moodle platform but is not working, meaning that the emails were not sent to the students. After running cron the following php error is generated:
Processing customized cron scripts ...Processing cron function for local_reminders...
PHP Warning: Missing argument 6 for get_logs(), called in /home/moodle/wwwroot/local/reminders/lib.php on line 70 and defined in /home/moodle/wwwroot/lib/datalib.php on line 1837
[Local Reminder] Time window: vineri, 5 aprilie 2013, 11:09 to vineri, 5 aprilie 2013, 11:19
[Local Reminder] Found 1 upcoming events. Continuing...
[Local Reminder] Processing event#101 [Type: group, inaheadof=1 days]...
[Local Reminder] Finding out users for event#101...
PHP Notice: Undefined variable: DB in /home/moodle/wwwroot/local/reminders/contents/group_reminder.class.php on line 86
PHP Fatal error: Call to a member function get_record() on a non-object in /home/moodle/wwwroot/local/reminders/contents/group_reminder.class.php on line 86
You have new mail in /var/spool/mail/root
[moodle@vmxxx admin]$
Thank you

it's a really nice plugin! very useful. but don't work in moodle 2.4 any idea when this plugin will be a release for moodle 2.4?

Hi Jurg,
I will work on that. Thanks for reporting.

I created a issue on the tracker CONTRIB-4217 for moodle 2.4

Hi, Rob.
Could you create an issue on tracker.moodle.org. It should be assigned to Isuru automatically if this component is selected. That will allow us to work on it.

We would really like this upgraded so it works on 2.4. It does not at the moment.