Moodle plugins directory: Game | Moodle.org
Game
Activities ::: mod_game
Maintained by Vasilis Daloukas
Part of set Gamification.
The game activity module makes use of questions, quizzes and glossaries to create offer a variety of interactive games.
Latest release:
8614 sites
2k downloads
307 fans
Current versions available: 1
This module gets input from quiz, glossary or questions and plays some games. The games are:
* hangman
* crossword
* cryptex
* millionaire
* sudoku
* Snakes and Ladders
* The hidden picture
* Book with questions
If you like this module please consider donating via PayPal at
to help me continue working on this project. When you donate you can ask for new facilities e.g. support for new languages, new games, new statistics, more documentation on some forms or extra support.It's a project that has been active since 2007 and is the number 7 on downloads in the last 12 months according to https://moodle.org/plugins/stats.php?plugin_category=1.
This module is and will remain free, but your donation allows me to continue the development, and any amount is greatly appreciated.
Now is GDPR compliant.
Publications (Google Scholar profile):
Contributors
Vasilis Daloukas (Lead maintainer)
Please login to view contributors details and/or to contact them
I encountered the following errors when I attempted to update mod_game on my Moodle 2.9+ installation to the current version:
mod_game
DDL sql execution error
More information about this error
Debug info: ERROR: column "createscore" contains null values
BEGIN ISOLATION LEVEL SERIALIZABLE;
ALTER TABLE mdl_game_cross ALTER COLUMN createscore TYPE DOUBLE PRECISION
;
ALTER TABLE mdl_game_cross ALTER COLUMN createscore SET DEFAULT 0
;
ALTER TABLE mdl_game_cross ALTER COLUMN createscore SET NOT NULL
; COMMIT
Error code: ddlexecuteerror
Stack trace:
line 449 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
line 244 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
line 671 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
line 76 of /lib/ddl/database_manager.php: call to pgsql_native_moodle_database->change_database_structure()
line 583 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
line 1553 of /mod/game/db/upgrade.php: call to database_manager->change_field_type()
line 706 of /lib/upgradelib.php: call to xmldb_game_upgrade()
line 424 of /lib/upgradelib.php: call to upgrade_plugins_modules()
line 1630 of /lib/upgradelib.php: call to upgrade_plugins()
line 433 of /admin/index.php: call to upgrade_noncore()
Any workaround on this?
Thanks.
mod_game
Fehler: DDL sql execution
Weitere Informationen über diesen Fehler
×Debug info: ERROR: column "createscore" contains null values
BEGIN ISOLATION LEVEL SERIALIZABLE;
ALTER TABLE mdl_game_cross ALTER COLUMN createscore TYPE DOUBLE PRECISION
;
ALTER TABLE mdl_game_cross ALTER COLUMN createscore SET DEFAULT 0
;
ALTER TABLE mdl_game_cross ALTER COLUMN createscore SET NOT NULL
; COMMIT
Error code: ddlexecuteerror
×Stack trace:
• line 480 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
• line 244 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
• line 680 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
• line 77 of /lib/ddl/database_manager.php: call to pgsql_native_moodle_database->change_database_structure()
• line 595 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
• line 1553 of /mod/game/db/upgrade.php: call to database_manager->change_field_type()
• line 726 of /lib/upgradelib.php: call to xmldb_game_upgrade()
• line 432 of /lib/upgradelib.php: call to upgrade_plugins_modules()
• line 1742 of /lib/upgradelib.php: call to upgrade_plugins()
• line 683 of /admin/index.php: call to upgrade_noncore()
Can I help you?
Thanks. Jürg
UPDATE mdl_game_cross SET createscore=0 WHERE createscore isnull
before applying the mod_game update.
after copy plugin in /mod/game
Debug info: Errors found in XMLDB file: Problem loading table game, Some FIELDS previous/next values are incorrect
Error code: ddlxmlfileerror
Stack trace:
line 349 of /lib/ddl/database_manager.php: ddl_exception thrown
line 365 of /lib/ddl/database_manager.php: call to database_manager->load_xmldb_file()
line 596 of /lib/upgradelib.php: call to database_manager->install_from_xmldb_file()
line 360 of /lib/upgradelib.php: call to upgrade_plugins_modules()
line 1544 of /lib/upgradelib.php: call to upgrade_plugins()
line 349 of /admin/index.php: call to upgrade_noncore()
thanks for fix the bug with the umlauts (game 'millioniare': instead of 'A, Ä, B, C' now 'A, B, C, D').
Unfortunately, there is another problem in the game 'millioniare': If the question is answered incorrectly, it is not the right answer which will displayed with 'color: DarkOrange' but always the previous response proposal. Is there a connection between the umlauts and this display?
I changed the line 251 in the file millioniare/play.php:
instead of : if ($state == 15 and $i + 1 == $query->correct) {
now: if ($state == 15 and $i == $query->correct) {
Can you verify this?
Thank you very much.
Michael
I am dying for an update for Moodle 3.2. Is a new version in the making? Thanks