Running Moodle 3.5.2 (Build: 20180910) on Linux.
Have had an issue crop up for some faculty setting up Assignment activities and getting "Error writing to database" error. I had trouble replicating the problem, but heard from a faculty member tonight that it occurs when she unselects the 'remind to grade by' date.
I've now replicated this. When I set up an Assignment and leave the 'remind me to grade by' date enabled as default, the Assignment activity is created with no problems. If I unselect that option when setting up the Assignment, I reliably get the 'error writing to database' error.
Has this been reported before? I did some basic searching in this forum and on the Moodle Tracker, but wasn't able to pull up any related posts or reported issues.
Any suggestions as to what might be going on? Or how we can address this issue on our server?
purchase college suny
Also, if I set up an Assignment with the 'remind to grade' date enabled, save it, and edit the settings later, I can uncheck the option and successfully save the updated Assignment without generating the error.
So unchecking that date option only seems to cause a database error when initially setting up the activity.
Can you give any other details of the assignment setup process you are using. So far I have tested on two Moodle 3.5.2+ (Build: 20180927) sites and I am NOT able to duplicate the error.
I have tried it by adding an assignment name and description, removing the Remind me to grade by checkmark, and then clicking Save and display. I have also tried it by clicking Save and return to course. Both worked as expected, without generating any error.
Hi AL - Thanks for checking. I've been swamped with conferences and other travel so haven't had chance to work on this for a bit. I'll need to get more info on the server configuration from our server admins (we do "front end" admin of the Moodle app and help faculty, but have separate server admins in campus tech services who manage the server architecture and upgrades). Will let you know what I hear.
Very frustrating though. I'm basically selecting to add an Assignment activity, entering the required title, and unselecting the 'remind to grade by' option, nothing else, and I get the error whether I choose to save and return to course or save and display. So there's not a lot of options to troubleshoot from the front end.
Any recommendations as to what I should ask our server admin to look for? I guess I can have him take a look at this on our Moodle dev server with verbose logging turned on, to see if that provides any clues.