thank you very much for sending me the access information. I have modified your Moodle database, so that it is back to how it should be in order for the install of the HotPot module for Moodle 1.6 to work.
Please now do the following:
- download the HotPot module for Moodle 1.6 from here:
good luck!
Gordon
For reference, here are the MySQL commands I used to reset the HotPot tables and settings in your Moodle database:
## remove "md5key" field and index from "hotpot_questions" table
ALTER TABLE `mdl_hotpot_questions` DROP INDEX `hotpot_questions_md5key_idx`;
ALTER TABLE `mdl_hotpot_questions` DROP `md5key`;
## remove "md5key" field and index from "hotpot_strings" table
ALTER TABLE `mdl_hotpot_strings` DROP INDEX `hotpot_strings_md5key_idx`;
ALTER TABLE `mdl_hotpot_strings` DROP `md5key`;
## adjust version number for HotPot module
UPDATE `mdl_modules` SET `version` = '2006080700' WHERE `name` = 'hotpot';
ALTER TABLE `mdl_hotpot_questions` DROP INDEX `hotpot_questions_md5key_idx`;
ALTER TABLE `mdl_hotpot_questions` DROP `md5key`;
## remove "md5key" field and index from "hotpot_strings" table
ALTER TABLE `mdl_hotpot_strings` DROP INDEX `hotpot_strings_md5key_idx`;
ALTER TABLE `mdl_hotpot_strings` DROP `md5key`;
## adjust version number for HotPot module
UPDATE `mdl_modules` SET `version` = '2006080700' WHERE `name` = 'hotpot';