Game

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()

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.

Christopher Molnar: The version 2017062002 fixes the above problem.

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()

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.

Thanks a lot.

Thanks a lot. I think we really apreciate you work.

I am working on Moodle 3.3 and Moodle 3.4. In the next 15 days will be available. If you like the Game activity module please consider donating at http://bdaloukas.gr/donate/moodlegame/ to help me have more time to continue working on this project. This module is and will remain free, but your donation allows me to continue the development, and any amount is greatly appreciated.

Do you know when the update for 3.2 will be ready ? Thanks

I have installed this on Moodle 3.2 and, although I have only tested it very quickly, it appears to work. The one confusing thing is that the games no longer appear blocked together under "Games" on the Activity menu. Instead, they are merged into all of the other Activity menu items in alphabetical order.

May i know how to solve the question repeating problem?

Dear developer,
I am dying for an update for Moodle 3.2. Is a new version in the making? Thanks

Hello, just wondering when this is going to be updated for 3.2? Thanks.

Please provide upgrade for version 3.2

I have logged a bug https://tracker.moodle.org/browse/CONTRIB-6604 regarding pictures not being shown in Crossword.