jhoopes / moodle-mod_activequiz

Update to the realtimequiz module, but renamed as a totally new module
6 stars 15 forks source link

You have an error in your SQL syntax #53

Open xiaoqiangch opened 6 years ago

xiaoqiangch commented 6 years ago

Hello, guys,

I have got an issue like this:

FIY, the environment is:

Thank you very much!

Debug info: 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 'grouping = NULL,reviewoptions = '{\"after\":{\"attempt\":\"1\",\"correctness\":\' at line 1 UPDATE mdl_activequiz SET course = ?,name = ?,intro = ?,introformat = ?,graded = ?,scale = ?,grademethod = ?,workedingroups = ?,groupattendance = ?,grouping = ?,reviewoptions = ?,timecreated = ?,timemodified = ?,defaultquestiontime = ?,waitforquestiontime = ?,questionorder = ? WHERE id=? [array ( 0 => '2', 1 => '谁发的发斯蒂芬', 2 => '

啥辅导费

', 3 => '1', 4 => '1', 5 => '10', 6 => '1', 7 => '0', 8 => '0', 9 => NULL, 10 => '{"after":{"attempt":"1","correctness":"1","marks":"1","specificfeedback":"1","generalfeedback":"1","rightanswer":"1","manualcomment":"1"}}', 11 => '1541543013', 12 => '1541543013', 13 => '30', 14 => '5', 15 => 1, 16 => '1', )] Error code: dmlwriteexception ×Stack trace: line 489 of /lib/dml/moodle_database.php: dml_write_exception thrown line 1557 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end() line 1589 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->update_record_raw() line 166 of /mod/activequiz/classes/activequiz.php: call to mysqli_native_moodle_database->update_record() line 445 of /mod/activequiz/classes/questionmanager.php: call to mod_activequiz\activequiz->saveRTQ() line 473 of /mod/activequiz/classes/questionmanager.php: call to mod_activequiz\questionmanager->set_question_order() line 154 of /mod/activequiz/classes/questionmanager.php: call to mod_activequiz\questionmanager->update_questionorder() line 185 of /mod/activequiz/classes/controllers/edit.php: call to mod_activequiz\questionmanager->add_question() line 39 of /mod/activequiz/edit.php: call to mod_activequiz\controllers\edit->handle_action()

SanatSharma commented 2 years ago

get the same issue. @xiaoqiangch were you able to fix this?