Open koenr opened 1 year ago
I added in db a default value of 0 for the field mdl_cardbox_statistics.numberofcards and got the following error.
Foutopsporingsinformatie: Field 'duration' doesn't have a default value INSERT INTO mdl_cardbox_statistics (userid,cardboxid,timeofpractice,percentcorrect) VALUES(?,?,?,?) [array ( 0 => '528', 1 => 7, 2 => 1664705420, 3 => '67', )] Error code: dmlwriteexception
So I also added a default value of 0 for the field mdl_cardbox_statistics.duration.
Now the restore seems to work. I don't know if choosing a 0 as default value is a good choice, but it works for now
I'm trying to restore a course with a large cardbox activity to another site with the cardbox installed. Error message is
I looked at https://docs.moodle.org/400/en/error/moodle/dmlwriteexception#dmlwriteexception_error_when_restoring_a_course and the database tables are Barracuda.
I also added
to my mysql configuration.
I'm mentioning the problem here, because of Field 'numberofcards' doesn't have a default value seems to be a problem in the cardbox db configuration.
I can't look any further into it right now, but 'll try to provide some more info in a few days if necessary