Comments

• 

  Vasilis Daloukas

  Tue, 20 June 2017, 8:34 PM

  The new version of module Game (compatible with Moodle 3.4 and without warnings and errors at code prechecks) is availabe.
  If you like this module please consider donating at https://www.paypal.me/moodlegame to help me have more time to continue working on this project.
  It's a project that is active for 10 years and is the number 10 on downloads 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.
• 

  Christopher Molnar

  Tue, 20 June 2017, 9:44 PM

  With Moodle 3.1.3 to 3.3+ upgrade and latest mod_games (2016091701 to new 2017061901):
  
  Debug info: ERROR: column "usedcols" is of type smallint but expression is of type character varying
  LINE 1: UPDATE pcilms_game_cross SET usedcols=cols
  ^
  HINT: You will need to rewrite or cast the expression.
  UPDATE pcilms_game_cross SET usedcols=cols
  [array (
  )]
  Error code: dmlwriteexception
  
  
  Stack trace:
  
  line 489 of /lib/dml/moodle_database.php: dml_write_exception thrown
  line 242 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
  line 700 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
  line 1569 of /mod/game/db/upgrade.php: call to pgsql_native_moodle_database->execute()
  line 738 of /lib/upgradelib.php: call to xmldb_game_upgrade()
  line 444 of /lib/upgradelib.php: call to upgrade_plugins_modules()
  line 1754 of /lib/upgradelib.php: call to upgrade_plugins()
  line 699 of /admin/index.php: call to upgrade_noncore()
• 

  Vasilis Daloukas

  Tue, 20 June 2017, 11:05 PM

  Christopher Molnar: The version 2017062002 fixes the above problem.
• 

  maude vuille

  Tue, 27 June 2017, 4:27 AM

  Hi, thank you so much for the update. The Cryptex word box has disappeared though, whether activities have been upgraded or newly created - only the questions are visible. I've tried on both Moodle 3.2 and 3.3 with version 2017062002.
• 

  Joshua Todd Cowper

  Tue, 27 June 2017, 9:31 AM

  Hi Vasilis,
  
  I seem to get the following error when upgrading to Moodle 3.3+ and MariaDB 10.2, using plugin version 2017062002
  
  mod_game
  Error reading from database
  
  More information about this error
  
  ×Debug info: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows,usedrows FROM mdl_game_cross' at line 1
  SELECT id,rows,usedrows FROM mdl_game_cross
  [array (
  )]
  Error code: dmlreadexception
  ×Stack trace:
  line 486 of \lib\dml\moodle_database.php: dml_read_exception thrown
  line 1175 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->query_end()
  line 56 of \mod\game\db\upgrade.php: call to mysqli_native_moodle_database->get_records_sql()
  line 1593 of \mod\game\db\upgrade.php: call to mpgame_db_copy_string_to_int()
  line 738 of \lib\upgradelib.php: call to xmldb_game_upgrade()
  line 444 of \lib\upgradelib.php: call to upgrade_plugins_modules()
  line 1754 of \lib\upgradelib.php: call to upgrade_plugins()
  line 699 of \admin\index.php: call to upgrade_noncore()
• 

  Vasilis Daloukas

  Tue, 27 June 2017, 4:09 PM

  Maude vuille, Joshua Todd Cowper: The problem is fixed in version 2017062702
• 

  Joshua Todd Cowper

  Wed, 28 June 2017, 5:51 AM

  Thanks so much for all your work on this plugin Vasilis, looks like there's similar but slightly different error now when I try to upgrade to 2017062702:
  
  mod_game
  DDL sql execution error
  
  More information about this error
  
  ×Debug info: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows' at line 1
  ALTER TABLE mdl_game_cross DROP COLUMN rows
  Error code: ddlexecuteerror
  ×Stack trace:
  line 492 of \lib\dml\moodle_database.php: ddl_change_structure_exception thrown
  line 1000 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->query_end()
  line 77 of \lib\ddl\database_manager.php: call to mysqli_native_moodle_database->change_database_structure()
  line 570 of \lib\ddl\database_manager.php: call to database_manager->execute_sql_arr()
  line 1594 of \mod\game\db\upgrade.php: call to database_manager->drop_field()
  line 738 of \lib\upgradelib.php: call to xmldb_game_upgrade()
  line 444 of \lib\upgradelib.php: call to upgrade_plugins_modules()
  line 1754 of \lib\upgradelib.php: call to upgrade_plugins()
  line 699 of \admin\index.php: call to upgrade_noncore()
• 

  Vasilis Daloukas

  Wed, 28 June 2017, 6:39 AM

  Joshua Todd Cowper: Version 2017062801 fixes the above problem by simply don't drop the column.
• 

  Аида Маркосян

  Wed, 28 June 2017, 6:59 PM

  Hi! I have problems in many games: Crossword does not see the glossary and its categories, Millionaire does not see the questions, Can you help mee?
• 

  Vasilis Daloukas

  Wed, 28 June 2017, 7:58 PM

  Аида Маркосян: Goto settings of game, select the correct glossary and press save. If the problem continues please goto at https://moodle.org/mod/forum/view.php?id=7220, open a discussion and send a printscreen of settings to understand the problem.
• 

  Vasilis Daloukas

  Tue, 4 July 2017, 1:12 AM

  New: version 2017070301 auto detects for common problems e.g. words with spaces and not allowing spaces in the game, multichoice without only only one correct anwer, words containing letters that not contained in the used language.
• 

  Vasilis Daloukas

  Sat, 12 Aug 2017, 1:20 AM

  Added high scores in each game (version 2017081104)
• 

  Ashley Long

  Tue, 21 Nov 2017, 10:56 PM

  The game module in Moodle 3.1 in the Snakes and ladders game, has the snakes head below the tail. Also, it doesn't properly move up the ladder or down the tail? Has anyone else experienced this?
• 

  Matthew Wilson

  Sat, 9 Dec 2017, 12:31 AM

  I'm using Moodle 3.3. When I add a Hangman to the course, I select "Source of Questions" to be "Questions." This makes the question categories available to be selected in the dropdown box. However, the question categories all have a (0) out to the right of them, indicating there are no questions in any category. But, when I go to the question bank in the course, nearly all of the categories (sometimes sub-categories) have questions in them. I can provide screenshots if necessary.
• 

  marisol castro

  Tue, 12 Dec 2017, 4:04 AM

  I am also using Moodle 3.3 and am experiencing the same issues as Matthew Willson. I am also getting DB errors when I choose any of the game activity options. Is there something we are missing in the setup?