Millionaire Error reading from database

Millionaire Error reading from database

by Francisco Gómez -
Number of replies: 1

Error reading from database

More information about this error:

If I activate debugging then it appears:

: Unknown column 'qs.questionid' in 'where clause'
SELECT COUNT(*) FROM mdl_quiz_slots qs,mdl_question q, mdl_qtype_multichoice_options qmo WHERE qtype='multichoice' AND qs.quizid='59' AND qmo.questionid=q.id AND qs.questionid=q.id
[array (
)]
Error code: dmlreadexception×Descartar esta notificación
Trazado de la pila (stack):
line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 291 of /lib/dml/moodle_read_slave_trait.php: call to moodle_database->query_end()
line 1273 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->query_end()
line 1671 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
line 1744 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
line 361 of /mod/game/locallib.php: call to moodle_database->get_field_sql()
line 427 of /mod/game/millionaire/play.php: call to game_question_selectrandom()
line 327 of /mod/game/millionaire/play.php: call to game_millionaire_selectquestion()
line 113 of /mod/game/millionaire/play.php: call to game_millionaire_shownextquestion()
line 47 of /mod/game/millionaire/play.php: call to game_millionaire_play()
line 233 of /mod/game/attempt.php: call to game_millionaire_continue()
line 201 of /mod/game/attempt.php: call to game_create()
line 40 of /mod/game/attempt.php: call to game_do_attempt()


Occurs in MOODLE Moodle 3.11.9 (Build: 20220822) WITH PHP PHP Version 7.3.33

Also occurs in my installation with Moodle Version 4.0.4+ (Build: 20221011) both with PHP Version 7.4.30 and PHP Version 8.0.19

What can I do?

I would appreciate any help? 




Attachment millonario.jpg
Average of ratings: -
In reply to Francisco Gómez

Re: Millionaire Error reading from database

by Francisco Gómez -
The author of the GAME module has made some adjustments and now it works quite well. Only if there is any audio in the questionnaire, you can't hear it.
The latest version of GAME is at:
https://github.com/bdaloukas/moodle-mod_game
https://github.com/bdaloukas/moodle-mod_game/archive/refs/heads/MOODLE_20_STABLE.zip

I hope it will be soon in the general plugin repository.