General plugins

Davo Smith,

While installing Realtime Quiz on Moodle 1.9, following databse errors were encountered:

(mysql): CREATE TABLE mdl_realtimequiz ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', status SMALLINT(3) unsigned NOT NULL DEFAULT 0, currentquestion BIGINT(10) unsigned NOT NULL DEFAULT 0, nextendtime BIGINT(10) unsigned NOT NULL DEFAULT 0, currentsessionid BIGINT(10) unsigned NOT NULL DEFAULT 0, questiontime SMALLINT(3) unsigned NOT NULL DEFAULT 30, classresult SMALLINT(3) unsigned NOT NULL DEFAULT 0, questionresult SMALLINT(3) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )  

1050: Table 'mdl_realtimequiz' already exists

            ADOConnection._Execute(CREATE TABLE mdl_realtimequiz ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFA..., false) % line 891, file: adodb.inc.php
         ADOConnection.Execute(CREATE TABLE mdl_realtimequiz ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFA...) % line 89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_realtimequiz ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFA..., true) % line 2302, file: dmllib.php
   execute_sql_arr(Array[11]) % line 635, file: ddllib.php
install_from_xmldb_file(C:\Inetpub\wwwroot\moodle/mod/realtimequiz/db/install.xml) % line 390, file: adminlib.php

(mysql): CREATE TABLE mdl_realtimequiz_question ( id BIGINT(10) NOT NULL auto_increment, quizid BIGINT(10) unsigned NOT NULL DEFAULT 0, questionnum SMALLINT(3) unsigned NOT NULL DEFAULT 0, questiontext MEDIUMTEXT NOT NULL, questiontime MEDIUMINT(5) unsigned NOT NULL, image TEXT DEFAULT '', CONSTRAINT PRIMARY KEY (id) )  

1101: BLOB/TEXT column 'image' can't have a default value

            ADOConnection._Execute(CREATE TABLE mdl_realtimequiz_question ( id BIGINT(10) NOT NULL auto_increment, quizid BIGINT(10) unsigned NOT NULL DEFA..., false) % line 891, file: adodb.inc.php
         ADOConnection.Execute(CREATE TABLE mdl_realtimequiz_question ( id BIGINT(10) NOT NULL auto_increment, quizid BIGINT(10) unsigned NOT NULL DEFA...) % line 89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_realtimequiz_question ( id BIGINT(10) NOT NULL auto_increment, quizid BIGINT(10) unsigned NOT NULL DEFA..., true) % line 2302, file: dmllib.php
   execute_sql_arr(Array[11]) % line 635, file: ddllib.php
install_from_xmldb_file(C:\Inetpub\wwwroot\moodle/mod/realtimequiz/db/install.xml) % line 390, file: adminlib.php

(mysql): CREATE INDEX mdl_realques_quique_ix ON mdl_realtimequiz_question (quizid, questionnum)  

1072: Key column 'quizid' doesn't exist in table

            ADOConnection._Execute(CREATE INDEX mdl_realques_quique_ix ON mdl_realtimequiz_question (quizid, questionnum), false) % line 891, file: adodb.inc.php
         ADOConnection.Execute(CREATE INDEX mdl_realques_quique_ix ON mdl_realtimequiz_question (quizid, questionnum)) % line 89, file: dmllib.php
      execute_sql(CREATE INDEX mdl_realques_quique_ix ON mdl_realtimequiz_question (quizid, questionnum), true) % line 2302, file: dmllib.php
   execute_sql_arr(Array[11]) % line 635, file: ddllib.php
install_from_xmldb_file(C:\Inetpub\wwwroot\moodle/mod/realtimequiz/db/install.xml) % line 390, file: adminlib.php

(mysql): CREATE TABLE mdl_realtimequiz_answer ( id BIGINT(10) NOT NULL auto_increment, questionid BIGINT(10) unsigned NOT NULL DEFAULT 0, answertext MEDIUMTEXT NOT NULL, correct TINYINT(2) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )  

1050: Table 'mdl_realtimequiz_answer' already exists

            ADOConnection._Execute(CREATE TABLE mdl_realtimequiz_answer ( id BIGINT(10) NOT NULL auto_increment, questionid BIGINT(10) unsigned NOT NULL DE..., false) % line 891, file: adodb.inc.php
         ADOConnection.Execute(CREATE TABLE mdl_realtimequiz_answer ( id BIGINT(10) NOT NULL auto_increment, questionid BIGINT(10) unsigned NOT NULL DE...) % line 89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_realtimequiz_answer ( id BIGINT(10) NOT NULL auto_increment, questionid BIGINT(10) unsigned NOT NULL DE..., true) % line 2302, file: dmllib.php
   execute_sql_arr(Array[11]) % line 635, file: ddllib.php
install_from_xmldb_file(C:\Inetpub\wwwroot\moodle/mod/realtimequiz/db/install.xml) % line 390, file: adminlib.php

(mysql): CREATE TABLE mdl_realtimequiz_submitted ( id BIGINT(10) NOT NULL auto_increment, questionid BIGINT(10) unsigned NOT NULL DEFAULT 0, sessionid BIGINT(10) unsigned DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, answerid BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )  

1050: Table 'mdl_realtimequiz_submitted' already exists

            ADOConnection._Execute(CREATE TABLE mdl_realtimequiz_submitted ( id BIGINT(10) NOT NULL auto_increment, questionid BIGINT(10) unsigned NOT NULL..., false) % line 891, file: adodb.inc.php
         ADOConnection.Execute(CREATE TABLE mdl_realtimequiz_submitted ( id BIGINT(10) NOT NULL auto_increment, questionid BIGINT(10) unsigned NOT NULL...) % line 89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_realtimequiz_submitted ( id BIGINT(10) NOT NULL auto_increment, questionid BIGINT(10) unsigned NOT NULL..., true) % line 2302, file: dmllib.php
   execute_sql_arr(Array[11]) % line 635, file: ddllib.php
install_from_xmldb_file(C:\Inetpub\wwwroot\moodle/mod/realtimequiz/db/install.xml) % line 390, file: adminlib.php
 (mysql): CREATE TABLE mdl_realtimequiz_session ( id BIGINT(10) NOT NULL auto_increment, name VARCHAR(255) NOT NULL DEFAULT '', quizid BIGINT(10) unsigned NOT NULL DEFAULT 0, timestamp BIGINT(10) unsigned DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )  

1050: Table 'mdl_realtimequiz_session' already exists

            ADOConnection._Execute(CREATE TABLE mdl_realtimequiz_session ( id BIGINT(10) NOT NULL auto_increment, name VARCHAR(255) NOT NULL DEFAULT '', ..., false) % line 891, file: adodb.inc.php
         ADOConnection.Execute(CREATE TABLE mdl_realtimequiz_session ( id BIGINT(10) NOT NULL auto_increment, name VARCHAR(255) NOT NULL DEFAULT '', ...) % line 89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_realtimequiz_session ( id BIGINT(10) NOT NULL auto_increment, name VARCHAR(255) NOT NULL DEFAULT '', ..., true) % line 2302, file: dmllib.php
   execute_sql_arr(Array[11]) % line 635, file: ddllib.php
install_from_xmldb_file(C:\Inetpub\wwwroot\moodle/mod/realtimequiz/db/install.xml) % line 390, file: adminlib.php

Please Guide