Cant write to Database error

Cant write to Database error

by Richard Johnson -
Number of replies: 1
Using moodle 2.3.2 Cant create quiz. Get the screen to selecgt options but when i save the quiz i get an error cant write to database. I have turned on debugging and this is the result: Debug info: Field 'previous_link' doesn't have a default value INSERT INTO mdl_quiz (name,timeopen,timeclose,timelimit,overduehandling,graceperiod,grade,attempts,grademethod,shufflequestions,questionsperpage,navmethod,shuffleanswers,preferredbehaviour,attemptonlast,showuserpicture,decimalpoints,questiondecimalpoints,showblocks,subnet,delay1,delay2,browsersecurity,course,intro,introformat,questions,timemodified,password,reviewattempt,reviewcorrectness,reviewmarks,reviewspecificfeedback,reviewgeneralfeedback,reviewrightanswer,reviewoverallfeedback) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [array ( 0 => 'uvufufvuf', 1 => 0, 2 => 0, 3 => 0, 4 => 'autosubmit', 5 => 0, 6 => 100, 7 => '0', 8 => '1', 9 => '1', 10 => '1', 11 => 'free', 12 => '1', 13 => 'deferredfeedback', 14 => '0', 15 => '0', 16 => '2', 17 => '-1', 18 => '0', 19 => '', 20 => 0, 21 => 0, 22 => '-', 23 => '4', 24 => '', 25 => '1', 26 => '', 27 => 1352074280, 28 => '', 29 => 69904, 30 => 4368, 31 => 4368, 32 => 4368, 33 => 4368, 34 => 4368, 35 => 4368, )] Error code: dmlwriteexception Stack trace: line 410 of /lib/dml/moodle_database.php: dml_write_exception thrown line 1050 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end() line 1092 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw() line 91 of /mod/quiz/lib.php: call to mysqli_native_moodle_database->insert_record() line 447 of /course/modedit.php: call to quiz_add_instance() Hope someone knows how to help smile
Average of ratings: -
In reply to Richard Johnson

Re: Cant write to Database error

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
The field mdl_quiz.previous_link should not exist. At least, it has never existed in a Moodle release. Someone may gave added it to your Moodle as a customisation. If so, you will have to sort that out yourself.