HotPot

Thanks for the extra info Gorn. Glad to know HotPot is working again for you now. Phew!

Thanks a lot, Gordon, the plugin works now. We're using Moodle 2.4.7+, so this version was affected as well.

Gorn, thanks for telling me about that. The issue affected Moodle 2.3 and earlier. I have fixed it now. Please upgrade your HotPot module when you have time. regards, Gordon

I've updated Hotpot to the latest version today, but when I use it in a course I get the following error message:
Fatal error: Call to undefined method cm_info::get_formatted_name() in mod/hotpot/lib.php on line 509

Hello,
We are preparing to upgrade our Moodle from 2.4.1 to 2.5 and have updated all our plugins in preparation. (Working on development server). HotPot gives us this error which we can't seem to find a way around:
Higher version already installed! There is a new version 2013111688 available!
The error message is as follows:
Debug info:
Error code: cannotdowngrade
Stack trace: ◦line 658 of \lib\upgradelib.php: downgrade_exception thrown
◦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()
Any help appreciated,
Thanks,
Cori

Simon, I think you can fix your issue by downloading and installing the latest version of the HotPot module. I believe that is how Rick fixed the issue he was having.

I haven't had any problems updating the HotPot plug-in using Moodle's auto-update feature until today. There's been several hotpot updates the past few weeks and all have installed fine until today when I tried to install version 3.81 (2010080381) and got a "Oops! It did it again Moodle deployment utility had a trouble with your request. exception 'download_file_exception' with message 'Unable to download the package' in mdeploy.php:726.
Anyone else seeing this?

Current settings do not allow updates. Please check version restrictions on moodle.org. I ended up manually updating because automatic download would not do Ver. 79 or 80 from 78.

Hi everyone,
all issues with upgrading are now fixed as far as I know. You can upgrade from any version to the latest version.
Please be aware that comments posted in this comment area are not automatically forwarded to me.
Therefore, if you wish to ask questions about the HotPot module, or report an issue, the best places to do so is either on the Moodle Tracker or on the Moodle HotPot forum. You will get faster and better response that way.
* Moodle Tracker (Contrib): http://tracker.moodle.org/browse/CONTRIB
* Moodle HotPot forum: http://moodle.org/mod/forum/view.php?id=1599
best regards
Gordon

I have also tried running this command in SQL>
ALTER TABLE mdl_hotpot MODIFY COLUMN grademethod SMALLINT(4) NOT NULL DEFAULT 0 after grade
which returns #1054 - Unknown column 'grade' in 'mdl_hotpot'
Is it possible to go from 2008011200 version to 2010080341?

HotPot module /mod/hotpot Contributed 2008011200 2010080340 Moodle 2010112400 To be upgraded
Hey Gordon,
I have made the change to line 715 --> xmldb_hotpot_fix_previous_field($dbman, $table, $fields[$i]);
Which fixed the [i] error, however I am now getting this error which i think is the same as above, any ideas to what i have done wrong with the installation. I am running Moodle 2.3+.
mod_hotpot
DDL sql execution error
More information about this error
Debug info: Unknown column 'grade' in 'mdl_hotpot'
ALTER TABLE mdl_hotpot MODIFY COLUMN grademethod SMALLINT(4) NOT NULL DEFAULT 0 after grade
Error code: ddlexecuteerror
Stack trace: ◦line 413 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
◦line 722 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
◦line 88 of /lib/ddl/database_manager.php: call to mysqli_native_moodle_database->change_database_structure()
◦line 77 of /lib/ddl/database_manager.php: call to database_manager->execute_sql()
◦line 575 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
◦line 98 of /mod/hotpot/db/upgrade.php: call to database_manager->change_field_type()
◦line 627 of /lib/upgradelib.php: call to xmldb_hotpot_upgrade()
◦line 358 of /lib/upgradelib.php: call to upgrade_plugins_modules()
◦line 1524 of /lib/upgradelib.php: call to upgrade_plugins()
◦line 329 of /admin/index.php: call to upgrade_noncore()

Yikes, sorry about that error message - and thanks for reporting the problem and the fix. I have modified the upgrade.php file in the zip download. regards Gordon.

Hi, tried upgrading from v1.9.7 to 2.2.3 and got the above errors with hotpot module version 3.0.40. Fix was the same 2 lines were incorrect but at different offsets.

As mentioned above, there is a bug in the upgrade script. The fix is very simple:
Open /mod/hotpot/db/upgrade.php
Go to line 677, and edit $fields[i] to read $fields[$i]