hotpot


(mysql): CREATE TABLE mdl_hotpot ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', summary TEXT NOT NULL, timeopen BIGINT(10) unsigned NOT NULL DEFAULT 0, timeclose BIGINT(10) unsigned NOT NULL DEFAULT 0, location SMALLINT(4) unsigned NOT NULL DEFAULT 0, reference VARCHAR(255) NOT NULL DEFAULT '', outputformat SMALLINT(4) unsigned NOT NULL DEFAULT 1, navigation SMALLINT(4) unsigned NOT NULL DEFAULT 1, studentfeedback SMALLINT(4) unsigned NOT NULL DEFAULT 0, studentfeedbackurl VARCHAR(255) NOT NULL DEFAULT '', forceplugins SMALLINT(4) unsigned NOT NULL DEFAULT 0, shownextquiz SMALLINT(4) unsigned NOT NULL DEFAULT 0, review SMALLINT(4) NOT NULL DEFAULT 0, grade BIGINT(10) NOT NULL DEFAULT 0, grademethod SMALLINT(4) NOT NULL DEFAULT 1, attempts MEDIUMINT(6) NOT NULL DEFAULT 0, password VARCHAR(255) NOT NULL DEFAULT '', subnet VARCHAR(255) NOT NULL DEFAULT '', clickreporting SMALLINT(4) unsigned NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )  
1050: Table 'mdl_hotpot' already exists
            adodb_mysql._execute(CREATE TABLE mdl_hotpot (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    course BIGINT(10) unsigned NOT NULL DEFAULT 0,..., false) % line  891, file: adodb.inc.php
         adodb_mysql.execute(CREATE TABLE mdl_hotpot (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    course BIGINT(10) unsigned NOT NULL DEFAULT 0,...) % line   89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_hotpot (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    course BIGINT(10) unsigned NOT NULL DEFAULT 0,..., true) % line 2302, file: dmllib.php
   execute_sql_arr(Array[12]) % line  635, file: ddllib.php
install_from_xmldb_file(/u01/httpd/sdo.taom.ru/mod/hotpot/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_hotpot COMMENT='details about Hot Potatoes quizzes'  
Success

(mysql): CREATE TABLE mdl_hotpot_attempts ( id BIGINT(10) unsigned NOT NULL auto_increment, hotpot BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, starttime BIGINT(10) unsigned NOT NULL DEFAULT 0, endtime BIGINT(10) unsigned NOT NULL DEFAULT 0, score MEDIUMINT(6) unsigned NOT NULL DEFAULT 0, penalties MEDIUMINT(6) unsigned NOT NULL DEFAULT 0, attempt MEDIUMINT(6) unsigned NOT NULL DEFAULT 0, timestart BIGINT(10) unsigned NOT NULL DEFAULT 0, timefinish BIGINT(10) unsigned NOT NULL DEFAULT 0, status SMALLINT(4) unsigned NOT NULL DEFAULT 1, clickreportid BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )  
1050: Table 'mdl_hotpot_attempts' already exists
            adodb_mysql._execute(CREATE TABLE mdl_hotpot_attempts (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    hotpot BIGINT(10) unsigned NOT NULL D..., false) % line  891, file: adodb.inc.php
         adodb_mysql.execute(CREATE TABLE mdl_hotpot_attempts (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    hotpot BIGINT(10) unsigned NOT NULL D...) % line   89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_hotpot_attempts (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    hotpot BIGINT(10) unsigned NOT NULL D..., true) % line 2302, file: dmllib.php
   execute_sql_arr(Array[12]) % line  635, file: ddllib.php
install_from_xmldb_file(/u01/httpd/sdo.taom.ru/mod/hotpot/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_hotpot_attempts COMMENT='details about Hot Potatoes quiz attempts'  
Success

(mysql): CREATE TABLE mdl_hotpot_details ( id BIGINT(10) unsigned NOT NULL auto_increment, attempt BIGINT(10) unsigned NOT NULL DEFAULT 0, details TEXT, CONSTRAINT PRIMARY KEY (id) )  
1050: Table 'mdl_hotpot_details' already exists
            adodb_mysql._execute(CREATE TABLE mdl_hotpot_details (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    attempt BIGINT(10) unsigned NOT NULL D..., false) % line  891, file: adodb.inc.php
         adodb_mysql.execute(CREATE TABLE mdl_hotpot_details (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    attempt BIGINT(10) unsigned NOT NULL D...) % line   89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_hotpot_details (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    attempt BIGINT(10) unsigned NOT NULL D..., true) % line 2302, file: dmllib.php
   execute_sql_arr(Array[12]) % line  635, file: ddllib.php
install_from_xmldb_file(/u01/httpd/sdo.taom.ru/mod/hotpot/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_hotpot_details COMMENT='raw details (as XML) of Hot Potatoes quiz attempts'  
Success

(mysql): CREATE TABLE mdl_hotpot_questions ( id BIGINT(10) unsigned NOT NULL auto_increment, name TEXT NOT NULL, type SMALLINT(4) unsigned NOT NULL DEFAULT 0, text BIGINT(10) unsigned NOT NULL DEFAULT 0, hotpot BIGINT(10) unsigned NOT NULL DEFAULT 0, md5key VARCHAR(32) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )  
1050: Table 'mdl_hotpot_questions' already exists
            adodb_mysql._execute(CREATE TABLE mdl_hotpot_questions (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    name TEXT NOT NULL,
    type SMALLIN..., false) % line  891, file: adodb.inc.php
         adodb_mysql.execute(CREATE TABLE mdl_hotpot_questions (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    name TEXT NOT NULL,
    type SMALLIN...) % line   89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_hotpot_questions (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    name TEXT NOT NULL,
    type SMALLIN..., true) % line 2302, file: dmllib.php
   execute_sql_arr(Array[12]) % line  635, file: ddllib.php
install_from_xmldb_file(/u01/httpd/sdo.taom.ru/mod/hotpot/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_hotpot_questions COMMENT='details about questions in Hot Potatoes quiz attempts'  
Success

(mysql): CREATE TABLE mdl_hotpot_responses ( id BIGINT(10) unsigned NOT NULL auto_increment, attempt BIGINT(10) unsigned NOT NULL DEFAULT 0, question BIGINT(10) unsigned NOT NULL DEFAULT 0, score MEDIUMINT(6) NOT NULL DEFAULT 0, weighting MEDIUMINT(6) NOT NULL DEFAULT 0, correct VARCHAR(255) NOT NULL DEFAULT '', wrong VARCHAR(255) NOT NULL DEFAULT '', ignored VARCHAR(255) NOT NULL DEFAULT '', hints MEDIUMINT(6) unsigned NOT NULL DEFAULT 0, clues MEDIUMINT(6) unsigned NOT NULL DEFAULT 0, checks MEDIUMINT(6) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )  
1050: Table 'mdl_hotpot_responses' already exists
            adodb_mysql._execute(CREATE TABLE mdl_hotpot_responses (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    attempt BIGINT(10) unsigned NOT NULL..., false) % line  891, file: adodb.inc.php
         adodb_mysql.execute(CREATE TABLE mdl_hotpot_responses (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    attempt BIGINT(10) unsigned NOT NULL...) % line   89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_hotpot_responses (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    attempt BIGINT(10) unsigned NOT NULL..., true) % line 2302, file: dmllib.php
   execute_sql_arr(Array[12]) % line  635, file: ddllib.php
install_from_xmldb_file(/u01/httpd/sdo.taom.ru/mod/hotpot/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_hotpot_responses COMMENT='details about responses in Hot Potatoes quiz attempts'  
Success

(mysql): CREATE TABLE mdl_hotpot_strings ( id BIGINT(10) unsigned NOT NULL auto_increment, string TEXT NOT NULL, md5key VARCHAR(32) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )  
1050: Table 'mdl_hotpot_strings' already exists
            adodb_mysql._execute(CREATE TABLE mdl_hotpot_strings (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    string TEXT NOT NULL,
    md5key VARCH..., false) % line  891, file: adodb.inc.php
         adodb_mysql.execute(CREATE TABLE mdl_hotpot_strings (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    string TEXT NOT NULL,
    md5key VARCH...) % line   89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_hotpot_strings (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    string TEXT NOT NULL,
    md5key VARCH..., true) % line 2302, file: dmllib.php
   execute_sql_arr(Array[12]) % line  635, file: ddllib.php
install_from_xmldb_file(/u01/httpd/sdo.taom.ru/mod/hotpot/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_hotpot_strings COMMENT='strings used in Hot Potatoes questions and responses'  
Success

hotpot tables could NOT be set up successfully!