Hi Ali,
if you got that far, then it looks like the other HotPot tables are in place. The "hotpot_details" table should have been added during installation (or upgrade from Moodle 1.5 -> 1.6). but for some reason it seems that didn't happen on your site.
The simplest solution at this stage is to add the missing table yourself.Start up your favorite database admin control program (e.g. phpMyAdmin) and execute the following SQL command:
-
CREATE TABLE
mdl_hotpot_details (
id int(10) unsigned NOT NULL auto_increment,
attempt int(10) unsigned NOT NULL default '0',
details text default '',
PRIMARY KEY (id),
KEY hotpot_details_attempt_idx (attempt)
) TYPE=MyISAM COMMENT='raw details (as
XML) of Hot Potatoes quiz attempts';
If the prefix for your db tables is something other than "mdl_", you wil need to change replace "mdl_" in the above command.
regards
Gordon