Reengagement plugin, Error writing to database

Reengagement plugin, Error writing to database

by Robert Clements -
Number of replies: 3

Has anyone else had this error?  Every time no matter the settings on the re-engagement activity I use, it gives me this error below.  

Moodle Version     3.3.1 (Build: 20170710)

MySQL Version     10.1.25-MariaDB

PHP Version           5.6.31

We are set up with max_allowed_packet = 500M

 

Error writing to database

More information about this error 

Debug info: Column 'visibleoncoursepage' cannot be null
INSERT INTO mdl_course_modules (course,module,instance,visible,visibleoncoursepage,visibleold,idnumber,groupmode,groupingid,completion,completiongradeitemnumber,completionview,completionexpected,availability,showdescription,added) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
[array (
0 => '44',
1 => 41,
2 => 0,
3 => 0,
4 => NULL,
5 => 0,
6 => '',
7 => 0,
8 => 0,
9 => 2,
10 => NULL,
11 => 0,
12 => 0,
13 => '{"op":"&","c":[{"type":"completion","cm":2279,"e":1}],"showc":[true]}',
14 => 0,
15 => 1501808416,
)]
Error code: dmlwriteexception

Stack trace:

  • line 489 of /lib/dml/moodle_database.php: dml_write_exception thrown
  • line 1259 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
  • line 1305 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
  • line 834 of /course/lib.php: call to mysqli_native_moodle_database->insert_record()
  • line 108 of /course/modlib.php: call to add_course_module()
  • line 154 of /course/modedit.php: call to add_moduleinfo()

Attachment Reengagement.png
Average of ratings: -
In reply to Robert Clements

Re: Reengagement plugin, Error writing to database

by Robert Clements -

I also found this in the root directory error log.

[04-Aug-2017 08:08:38 America/New_York] Default exception handler: A required parameter (identifier) was missing Debug:
Error code: missingparam
* line 503 of /lib/setuplib.php: moodle_exception thrown
* line 567 of /lib/moodlelib.php: call to print_error()
* line 33 of /help.php: call to required_param()

Average of ratings: -
In reply to Robert Clements

Re: Reengagement plugin, Error writing to database

by Dan Marsden -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers Picture of Plugins guardians Picture of Testers Picture of Translators

Hi Robert, 

we had fixed this in the main github branch but hadn't updated the plugins db with the latest code - I've just done that now. If you upgrade to the latest version of the reengagement plugin codebase it should fix that issue.


thanks,

Average of ratings: -
In reply to Dan Marsden

Re: Reengagement plugin, Error writing to database

by Robert Clements -

Hi Dan,

Thank you for your help and the re-engagement plugin is working perfectly in our Self-paced, timed release content course. This plugin was just what we needed.

Thanks,


Average of ratings: -