hotpot module needs upgrading


(postgres7): BEGIN  
Success


(postgres7): ALTER TABLE mdl_hotpot_questions ADD COLUMN "temporary_md5key_1157089978" VARCHAR(32)  
Success


(postgres7): UPDATE mdl_hotpot_questions SET "temporary_md5key_1157089978" = ''  
Success


(postgres7): ALTER TABLE mdl_hotpot_questions ALTER COLUMN "temporary_md5key_1157089978" SET DEFAULT ''  
Success


(postgres7): UPDATE pg_attribute SET attnotnull=TRUE WHERE attname = "temporary_md5key_1157089978" AND attrelid = (SELECT oid FROM pg_class WHERE relname = 'mdl_hotpot_questions')  

Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: column "temporary_md5key_1157089978" does not exist in /Users/vyshane/Sites/moodledev/lib/adodb/drivers/adodb-postgres64.inc.php on line 770
-1: ERROR: column "temporary_md5key_1157089978" does not exist
               ADODB_postgres7._Execute(
                    UPDATE pg_attribute SET attnotnull=TRUE 
                    WHERE attname = "temporary_md5key_1157089978"
..., false) % line  882, file: adodb.inc.php
            ADODB_postgres7.Execute(
                    UPDATE pg_attribute SET attnotnull=TRUE 
                    WHERE attname = "temporary_md5key_1157089978"
...) % line   69, file: dmllib.php
         execute_sql(
                    UPDATE pg_attribute SET attnotnull=TRUE 
                    WHERE attname = "temporary_md5key_1157089978"
...) % line 1284, file: update_to_v2.php
      hotpot_db_update_field_type(hotpot_questions, , md5key, VARCHAR, 32, , NOT NULL, , name) % line   18, file: update_to_v2.php
   hotpot_update_to_v2_2() % line   50, file: postgres7.php
Error


(postgres7): ALTER TABLE mdl_hotpot_questions RENAME COLUMN "temporary_md5key_1157089978" TO "md5key"  

Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /Users/vyshane/Sites/moodledev/lib/adodb/drivers/adodb-postgres64.inc.php on line 770
-1: ERROR: current transaction is aborted, commands ignored until end of transaction block
               ADODB_postgres7._Execute(ALTER TABLE mdl_hotpot_questions RENAME COLUMN "temporary_md5key_1157089978" TO "md5key", false) % line  882, file: adodb.inc.php
            ADODB_postgres7.Execute(ALTER TABLE mdl_hotpot_questions RENAME COLUMN "temporary_md5key_1157089978" TO "md5key") % line   69, file: dmllib.php
         execute_sql(ALTER TABLE mdl_hotpot_questions RENAME COLUMN "temporary_md5key_1157089978" TO "md5key") % line 1292, file: update_to_v2.php
      hotpot_db_update_field_type(hotpot_questions, , md5key, VARCHAR, 32, , NOT NULL, , name) % line   18, file: update_to_v2.php
   hotpot_update_to_v2_2() % line   50, file: postgres7.php
Error


(postgres7): COMMIT  
Success


(postgres7): CREATE INDEX mdl_hotpot_questions_md5key_idx ON mdl_hotpot_questions (md5key)  

Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: column "md5key" does not exist in /Users/vyshane/Sites/moodledev/lib/adodb/drivers/adodb-postgres64.inc.php on line 770
-1: ERROR: column "md5key" does not exist
            ADODB_postgres7._Execute(CREATE INDEX mdl_hotpot_questions_md5key_idx ON mdl_hotpot_questions (md5key), false) % line  882, file: adodb.inc.php
         ADODB_postgres7.Execute(CREATE INDEX mdl_hotpot_questions_md5key_idx ON mdl_hotpot_questions (md5key)) % line 1026, file: update_to_v2.php
      hotpot_db_add_index(hotpot_questions, md5key) % line   19, file: update_to_v2.php
   hotpot_update_to_v2_2() % line   50, file: postgres7.php
hotpot_upgrade(2006080900, Object:stdClass) % line  275, file: adminlib.php

(postgres7): SELECT * FROM mdl_hotpot_questions  

(postgres7): SELECT * FROM mdl_hotpot_strings  
Upgrading hotpot from 2006080900 to 2006083101 FAILED!