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!
Setting up module tables
Moodle Docs for this page