book

(mysql): CREATE TABLE mdl_book ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', summary MEDIUMTEXT NOT NULL, numbering SMALLINT(4) unsigned NOT NULL DEFAULT 0, disableprinting TINYINT(2) unsigned NOT NULL DEFAULT 2, customtitles TINYINT(2) 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) )

Success

(mysql): ALTER TABLE mdl_book COMMENT='Defines book'

Success

(mysql): CREATE TABLE mdl_book_chapters ( id BIGINT(10) NOT NULL auto_increment, bookid BIGINT(10) unsigned NOT NULL DEFAULT 0, pagenum BIGINT(10) unsigned NOT NULL DEFAULT 0, subchapter BIGINT(10) unsigned NOT NULL DEFAULT 0, title VARCHAR(255) NOT NULL DEFAULT '', content LONGTEXT NOT NULL, hidden TINYINT(2) unsigned NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, importsrc BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_book_chapters COMMENT='Defines book_chapters'

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('book', 'update', 'book', 'name')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('book', 'view', 'book', 'name')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('book', 'view all', 'book', 'name')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('book', 'print', 'book', 'name')

Success

book tables have been set up correctly

exercise

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_exercise ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', nelements SMALLINT(3) unsigned NOT NULL DEFAULT 1, phase SMALLINT(3) unsigned NOT NULL DEFAULT 0, gradingstrategy SMALLINT(3) unsigned NOT NULL DEFAULT 1, usemaximum SMALLINT(3) unsigned NOT NULL DEFAULT 0, assessmentcomps SMALLINT(3) unsigned NOT NULL DEFAULT 2, anonymous SMALLINT(3) unsigned NOT NULL DEFAULT 1, maxbytes BIGINT(10) unsigned NOT NULL DEFAULT 100000, deadline BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, grade SMALLINT(3) NOT NULL DEFAULT 0, gradinggrade SMALLINT(3) NOT NULL DEFAULT 0, showleaguetable SMALLINT(3) unsigned NOT NULL DEFAULT 0, usepassword SMALLINT(3) unsigned NOT NULL DEFAULT 0, password VARCHAR(32) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_exercise COMMENT='Defines exercise'

Success

(mysql): CREATE INDEX mdl_exer_cou_ix ON mdl_exercise (course)

Success

(mysql): CREATE TABLE mdl_exercise_submissions ( id BIGINT(10) unsigned NOT NULL auto_increment, exerciseid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, title VARCHAR(100) NOT NULL DEFAULT '', timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, resubmit SMALLINT(3) unsigned NOT NULL DEFAULT 0, mailed SMALLINT(3) unsigned NOT NULL DEFAULT 0, isexercise SMALLINT(3) unsigned NOT NULL DEFAULT 0, late SMALLINT(3) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_exercise_submissions COMMENT='Info about submitted work from teacher and students'

Success

(mysql): CREATE INDEX mdl_exersubm_use_ix ON mdl_exercise_submissions (userid)

Success

(mysql): CREATE INDEX mdl_exersubm_exe_ix ON mdl_exercise_submissions (exerciseid)

Success

(mysql): CREATE TABLE mdl_exercise_assessments ( id BIGINT(10) unsigned NOT NULL auto_increment, exerciseid BIGINT(10) unsigned NOT NULL DEFAULT 0, submissionid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, timegraded BIGINT(10) unsigned NOT NULL DEFAULT 0, grade DOUBLE NOT NULL DEFAULT 0, gradinggrade SMALLINT(3) NOT NULL DEFAULT 0, mailed TINYINT(2) unsigned NOT NULL DEFAULT 0, generalcomment TEXT NOT NULL, teachercomment TEXT NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_exercise_assessments COMMENT='Info about assessments by teacher and students'

Success

(mysql): CREATE INDEX mdl_exerasse_use_ix ON mdl_exercise_assessments (userid)

Success

(mysql): CREATE INDEX mdl_exerasse_exe_ix ON mdl_exercise_assessments (exerciseid)

Success

(mysql): CREATE INDEX mdl_exerasse_sub_ix ON mdl_exercise_assessments (submissionid)

Success

(mysql): CREATE TABLE mdl_exercise_elements ( id BIGINT(10) unsigned NOT NULL auto_increment, exerciseid BIGINT(10) unsigned NOT NULL DEFAULT 0, elementno SMALLINT(3) unsigned NOT NULL DEFAULT 0, description TEXT NOT NULL, scale SMALLINT(3) unsigned NOT NULL DEFAULT 0, maxscore SMALLINT(3) unsigned NOT NULL DEFAULT 1, weight SMALLINT(3) unsigned NOT NULL DEFAULT 11, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_exercise_elements COMMENT='Info about marking scheme of assignment'

Success

(mysql): CREATE INDEX mdl_exerelem_exe_ix ON mdl_exercise_elements (exerciseid)

Success

(mysql): CREATE TABLE mdl_exercise_rubrics ( id BIGINT(10) unsigned NOT NULL auto_increment, exerciseid BIGINT(10) unsigned NOT NULL DEFAULT 0, elementno BIGINT(10) unsigned NOT NULL DEFAULT 0, rubricno SMALLINT(3) unsigned NOT NULL DEFAULT 0, description TEXT NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_exercise_rubrics COMMENT='Info about the rubrics marking scheme'

Success

(mysql): CREATE INDEX mdl_exerrubr_exe_ix ON mdl_exercise_rubrics (exerciseid)

Success

(mysql): CREATE TABLE mdl_exercise_grades ( id BIGINT(10) unsigned NOT NULL auto_increment, exerciseid BIGINT(10) unsigned NOT NULL DEFAULT 0, assessmentid BIGINT(10) unsigned NOT NULL DEFAULT 0, elementno BIGINT(10) unsigned NOT NULL DEFAULT 0, feedback TEXT NOT NULL, grade SMALLINT(3) NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_exercise_grades COMMENT='Info about individual grades given to each element'

Success

(mysql): CREATE INDEX mdl_exergrad_exe_ix ON mdl_exercise_grades (exerciseid)

Success

(mysql): CREATE INDEX mdl_exergrad_ass_ix ON mdl_exercise_grades (assessmentid)

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('exercise', 'close', 'exercise', 'name')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('exercise', 'open', 'exercise', 'name')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('exercise', 'submit', 'exercise', 'name')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('exercise', 'view', 'exercise', 'name')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('exercise', 'update', 'exercise', 'name')

Success

exercise tables have been set up correctly

flashvideo

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_flashvideo ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', intro MEDIUMTEXT, introformat SMALLINT(4) unsigned NOT NULL DEFAULT 0, flvtype TINYINT(2) unsigned NOT NULL DEFAULT 0, mediafile MEDIUMTEXT, autoplay TINYINT(2) unsigned NOT NULL DEFAULT 0, playloop TINYINT(2) unsigned NOT NULL DEFAULT 0, videowidth SMALLINT(4) unsigned NOT NULL DEFAULT 400, videoheight SMALLINT(4) unsigned NOT NULL DEFAULT 400, initscale TINYINT(2) unsigned NOT NULL DEFAULT 0, streamingserver MEDIUMTEXT, streamingflvname MEDIUMTEXT, bufferlength SMALLINT(4) unsigned NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, teachernote LONGTEXT, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_flashvideo COMMENT='Default comment for flashvideo, please edit me'

Success

(mysql): CREATE INDEX mdl_flas_cou_ix ON mdl_flashvideo (course)

Success

(mysql): CREATE TABLE mdl_flashvideo_mynote ( id BIGINT(10) NOT NULL auto_increment, fid BIGINT(10) unsigned NOT NULL, userid BIGINT(10) unsigned NOT NULL, mynote LONGTEXT, timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_flashvideo_mynote COMMENT='Student\'s personal notes'

Success

(mysql): CREATE INDEX mdl_flasmyno_fid_ix ON mdl_flashvideo_mynote (fid)

Success

(mysql): CREATE INDEX mdl_flasmyno_use_ix ON mdl_flashvideo_mynote (userid)

Success

(mysql): CREATE UNIQUE INDEX mdl_flasmyno_fiduse_uix ON mdl_flashvideo_mynote (fid, userid)

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('flashvideo', 'add', 'flashvideo', 'name')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('flashvideo', 'update', 'flashvideo', 'name')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('flashvideo', 'view', 'flashvideo', 'name')

Success

flashvideo tables have been set up correctly

hotpot

(mysql): SHOW TABLES

(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) )

Success

(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) )

Success

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

Success

(mysql): CREATE INDEX mdl_hotpatte_use_ix ON mdl_hotpot_attempts (userid)

Success

(mysql): CREATE INDEX mdl_hotpatte_hot_ix ON mdl_hotpot_attempts (hotpot)

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) )

Success

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

Success

(mysql): CREATE INDEX mdl_hotpdeta_att_ix ON mdl_hotpot_details (attempt)

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) )

Success

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

Success

(mysql): CREATE INDEX mdl_hotpques_md5_ix ON mdl_hotpot_questions (md5key)

Success

(mysql): CREATE INDEX mdl_hotpques_hot_ix ON mdl_hotpot_questions (hotpot)

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) )

Success

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

Success

(mysql): CREATE INDEX mdl_hotpresp_att_ix ON mdl_hotpot_responses (attempt)

Success

(mysql): CREATE INDEX mdl_hotpresp_que_ix ON mdl_hotpot_responses (question)

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) )

Success

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

Success

(mysql): CREATE INDEX mdl_hotpstri_md5_ix ON mdl_hotpot_strings (md5key)

Success

hotpot tables have been set up correctly

journal

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_journal ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', intro TEXT NOT NULL, introformat TINYINT(2) NOT NULL DEFAULT 0, days MEDIUMINT(5) unsigned NOT NULL DEFAULT 7, assessed BIGINT(10) NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_journal COMMENT='data for each journal'

Success

(mysql): CREATE INDEX mdl_jour_cou_ix ON mdl_journal (course)

Success

(mysql): CREATE TABLE mdl_journal_entries ( id BIGINT(10) unsigned NOT NULL auto_increment, journal BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, modified BIGINT(10) unsigned NOT NULL DEFAULT 0, text TEXT NOT NULL, format TINYINT(2) NOT NULL DEFAULT 0, rating BIGINT(10) DEFAULT 0, entrycomment TEXT, teacher BIGINT(10) unsigned NOT NULL DEFAULT 0, timemarked BIGINT(10) unsigned NOT NULL DEFAULT 0, mailed TINYINT(1) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_journal_entries COMMENT='All the journal entries of all people'

Success

(mysql): CREATE INDEX mdl_jourentr_use_ix ON mdl_journal_entries (userid)

Success

(mysql): CREATE INDEX mdl_jourentr_jou_ix ON mdl_journal_entries (journal)

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('journal', 'view', 'journal', 'name')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('journal', 'add entry', 'journal', 'name')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('journal', 'update entry', 'journal', 'name')

Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('journal', 'view responses', 'journal', 'name')

Success

journal tables have been set up correctly

lams

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_lams ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', introduction TEXT NOT NULL, learning_session_id BIGINT(20) DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_lams COMMENT='LAMS activity'

Success

(mysql): CREATE INDEX mdl_lams_cou_ix ON mdl_lams (course)

Success

lams tables have been set up correctly

questionnaire

(mysql): CREATE TABLE `mdl_questionnaire` ( `id` int(11) NOT NULL auto_increment, `course` int(11) NOT NULL default '0', `name` varchar(255) NOT NULL default '', `summary` text NOT NULL, `qtype` INT( 10 ) NOT NULL default 0, `respondenttype` enum('fullname','anonymous') NOT NULL DEFAULT 'fullname', `resp_eligible` enum( 'all', 'students', 'teachers' ) NOT NULL DEFAULT 'all', `resp_view` INT( 2 ) NOT NULL default 0, `opendate` INT( 10 ) NOT NULL, `closedate` INT( 10 ) NOT NULL, `resume` INT( 2 ) NOT NULL default '0', `navigate` INT( 2 ) NOT NULL default '0', `sid` int(11) NOT NULL default '0', `timemodified` int(10) NOT NULL default '0', PRIMARY KEY (`id`), KEY `sid` (`sid`)) TYPE=MyISAM

1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1

         ADOConnection._Execute(CREATE TABLE `mdl_questionnaire` (  `id` int(11) NOT NULL auto_increment,  `course` int(11) NOT NULL default '0',  `name` varcha..., false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(CREATE TABLE `mdl_questionnaire` (  `id` int(11) NOT NULL auto_increment,  `course` int(11) NOT NULL default '0',  `name` varcha...) % line   89, file: dmllib.php
   execute_sql(CREATE TABLE `mdl_questionnaire` (  `id` int(11) NOT NULL auto_increment,  `course` int(11) NOT NULL default '0',  `name` varcha...) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

(mysql): CREATE TABLE `mdl_questionnaire_attempts` ( `id` int(11) NOT NULL auto_increment, `qid` int(11) NOT NULL default '0', `userid` int(11) NOT NULL default '0', `rid` int(10) unsigned NOT NULL default '0', `timemodified` int(10) NOT NULL default '0', PRIMARY KEY (`id`)) TYPE=MyISAM

1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1

         ADOConnection._Execute(CREATE TABLE `mdl_questionnaire_attempts` (  `id` int(11) NOT NULL auto_increment,  `qid` int(11) NOT NULL default '0',  `userid..., false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(CREATE TABLE `mdl_questionnaire_attempts` (  `id` int(11) NOT NULL auto_increment,  `qid` int(11) NOT NULL default '0',  `userid...) % line   89, file: dmllib.php
   execute_sql(CREATE TABLE `mdl_questionnaire_attempts` (  `id` int(11) NOT NULL auto_increment,  `qid` int(11) NOT NULL default '0',  `userid...) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

(mysql): CREATE TABLE mdl_questionnaire_survey ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, name CHAR(64) NOT NULL, owner CHAR(16) NOT NULL, realm CHAR(64) NOT NULL, public ENUM('Y','N') NOT NULL DEFAULT 'Y', status INT UNSIGNED NOT NULL DEFAULT '0', title CHAR(255) NOT NULL, email CHAR(64), subtitle TEXT, info TEXT, theme CHAR(64), thanks_page CHAR(255), thank_head CHAR(255), thank_body TEXT, changed TIMESTAMP(14) NOT NULL, PRIMARY KEY (id), KEY `name` (`name`), KEY `owner` (`owner`))

1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, PRIMARY KEY (id), KEY `name` (`name`), KEY `owner` (`own' at line 1

         ADOConnection._Execute(CREATE TABLE mdl_questionnaire_survey (    id			INT UNSIGNED NOT NULL AUTO_INCREMENT,    name		CHAR(64) NOT NULL,    owner		CHAR..., false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(CREATE TABLE mdl_questionnaire_survey (    id			INT UNSIGNED NOT NULL AUTO_INCREMENT,    name		CHAR(64) NOT NULL,    owner		CHAR...) % line   89, file: dmllib.php
   execute_sql(CREATE TABLE mdl_questionnaire_survey (    id			INT UNSIGNED NOT NULL AUTO_INCREMENT,    name		CHAR(64) NOT NULL,    owner		CHAR...) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

(mysql): CREATE TABLE mdl_questionnaire_question_type ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, type CHAR(32) NOT NULL, has_choices ENUM('Y','N') NOT NULL, response_table CHAR(32) NOT NULL, PRIMARY KEY (id))

Success

(mysql): CREATE TABLE mdl_questionnaire_question ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, survey_id INT UNSIGNED NOT NULL, name CHAR(30) NOT NULL, type_id INT UNSIGNED NOT NULL, result_id INT UNSIGNED, length INT NOT NULL DEFAULT 0, precise INT NOT NULL DEFAULT 0, position INT UNSIGNED NOT NULL, content TEXT NOT NULL, required ENUM('Y','N') NOT NULL DEFAULT 'N', deleted ENUM('Y','N') NOT NULL DEFAULT 'N', public ENUM('Y','N') NOT NULL DEFAULT 'Y', PRIMARY KEY (id))

Success

(mysql): CREATE TABLE mdl_questionnaire_question_choice ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, question_id INT UNSIGNED NOT NULL, content TEXT NOT NULL, value TEXT, PRIMARY KEY (id))

Success

(mysql): CREATE TABLE mdl_questionnaire_response ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, survey_id INT UNSIGNED NOT NULL, submitted INT(10) UNSIGNED NOT NULL DEFAULT 0, complete ENUM('Y','N') NOT NULL DEFAULT 'N', username CHAR(64), PRIMARY KEY (id))

Success

(mysql): CREATE TABLE mdl_questionnaire_response_bool ( `id` int(11) NOT NULL auto_increment, response_id INT UNSIGNED NOT NULL, question_id INT UNSIGNED NOT NULL, choice_id ENUM('Y','N') NOT NULL, PRIMARY KEY (id), KEY response_question (response_id,question_id))

Success

(mysql): CREATE TABLE mdl_questionnaire_response_single ( `id` int(11) NOT NULL auto_increment, response_id INT UNSIGNED NOT NULL, question_id INT UNSIGNED NOT NULL, choice_id INT UNSIGNED NOT NULL, PRIMARY KEY (id), KEY response_question (response_id,question_id))

Success

(mysql): CREATE TABLE mdl_questionnaire_response_multiple ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, response_id INT UNSIGNED NOT NULL, question_id INT UNSIGNED NOT NULL, choice_id INT UNSIGNED NOT NULL, PRIMARY KEY(id))

Success

(mysql): CREATE TABLE mdl_questionnaire_response_rank ( `id` int(11) NOT NULL auto_increment, response_id INT UNSIGNED NOT NULL, question_id INT UNSIGNED NOT NULL, choice_id INT UNSIGNED NOT NULL, rank INT NOT NULL, PRIMARY KEY (id), KEY response_question (response_id,question_id,choice_id))

Success

(mysql): CREATE TABLE mdl_questionnaire_response_text ( `id` int(11) NOT NULL auto_increment, response_id INT UNSIGNED NOT NULL, question_id INT UNSIGNED NOT NULL, response TEXT, PRIMARY KEY (id), KEY response_question (response_id,question_id))

Success

(mysql): CREATE TABLE mdl_questionnaire_response_other ( `id` int(11) NOT NULL auto_increment, response_id INT UNSIGNED NOT NULL, question_id INT UNSIGNED NOT NULL, choice_id INT UNSIGNED NOT NULL, response TEXT, PRIMARY KEY (id), KEY response_question (response_id,question_id,choice_id))

Success

(mysql): CREATE TABLE mdl_questionnaire_response_date ( `id` int(11) NOT NULL auto_increment, response_id INT UNSIGNED NOT NULL, question_id INT UNSIGNED NOT NULL, response DATE, PRIMARY KEY (id), KEY response_question (response_id,question_id))

Success

(mysql): INSERT INTO mdl_questionnaire_question_type VALUES ('1','Yes/No','N','response_bool')

Success

(mysql): INSERT INTO mdl_questionnaire_question_type VALUES ('2','Text Box','N','response_text')

Success

(mysql): INSERT INTO mdl_questionnaire_question_type VALUES ('3','Essay Box','N','response_text')

Success

(mysql): INSERT INTO mdl_questionnaire_question_type VALUES ('4','Radio Buttons','Y','response_single')

Success

(mysql): INSERT INTO mdl_questionnaire_question_type VALUES ('5','Check Boxes','Y','response_multiple')

Success

(mysql): INSERT INTO mdl_questionnaire_question_type VALUES ('6','Dropdown Box','Y','response_single')

Success

(mysql): INSERT INTO mdl_questionnaire_question_type VALUES ('8','Rate (scale 1..5)','Y','response_rank')

Success

(mysql): INSERT INTO mdl_questionnaire_question_type VALUES ('9','Date','N','response_date')

Success

(mysql): INSERT INTO mdl_questionnaire_question_type VALUES ('10','Numeric','N','response_text')

Success

(mysql): INSERT INTO mdl_questionnaire_question_type VALUES ('99','Page Break','N','')

Success

(mysql): INSERT INTO mdl_questionnaire_question_type VALUES ('100','Section Text','N','')

Success

questionnaire tables could NOT be set up successfully!

questionnaire

1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1

         ADOConnection._Execute(CREATE TABLE `mdl_questionnaire` (  `id` int(11) NOT NULL auto_increment,  `course` int(11) NOT NULL default '0',  `name` varcha..., false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(CREATE TABLE `mdl_questionnaire` (  `id` int(11) NOT NULL auto_increment,  `course` int(11) NOT NULL default '0',  `name` varcha...) % line   89, file: dmllib.php
   execute_sql(CREATE TABLE `mdl_questionnaire` (  `id` int(11) NOT NULL auto_increment,  `course` int(11) NOT NULL default '0',  `name` varcha...) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1

         ADOConnection._Execute(CREATE TABLE `mdl_questionnaire_attempts` (  `id` int(11) NOT NULL auto_increment,  `qid` int(11) NOT NULL default '0',  `userid..., false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(CREATE TABLE `mdl_questionnaire_attempts` (  `id` int(11) NOT NULL auto_increment,  `qid` int(11) NOT NULL default '0',  `userid...) % line   89, file: dmllib.php
   execute_sql(CREATE TABLE `mdl_questionnaire_attempts` (  `id` int(11) NOT NULL auto_increment,  `qid` int(11) NOT NULL default '0',  `userid...) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

         ADOConnection._Execute(CREATE TABLE mdl_questionnaire_survey (    id			INT UNSIGNED NOT NULL AUTO_INCREMENT,    name		CHAR(64) NOT NULL,    owner		CHAR..., false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(CREATE TABLE mdl_questionnaire_survey (    id			INT UNSIGNED NOT NULL AUTO_INCREMENT,    name		CHAR(64) NOT NULL,    owner		CHAR...) % line   89, file: dmllib.php
   execute_sql(CREATE TABLE mdl_questionnaire_survey (    id			INT UNSIGNED NOT NULL AUTO_INCREMENT,    name		CHAR(64) NOT NULL,    owner		CHAR...) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

1050: Table 'mdl_questionnaire_question_type' already exists

         ADOConnection._Execute(CREATE TABLE mdl_questionnaire_question_type (    id				INT UNSIGNED NOT NULL AUTO_INCREMENT,    type			CHAR(32) NOT NULL,    ha..., false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(CREATE TABLE mdl_questionnaire_question_type (    id				INT UNSIGNED NOT NULL AUTO_INCREMENT,    type			CHAR(32) NOT NULL,    ha...) % line   89, file: dmllib.php
   execute_sql(CREATE TABLE mdl_questionnaire_question_type (    id				INT UNSIGNED NOT NULL AUTO_INCREMENT,    type			CHAR(32) NOT NULL,    ha...) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

1050: Table 'mdl_questionnaire_question' already exists

         ADOConnection._Execute(CREATE TABLE mdl_questionnaire_question (    id			INT UNSIGNED NOT NULL AUTO_INCREMENT,    survey_id	INT UNSIGNED NOT NULL,    n..., false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(CREATE TABLE mdl_questionnaire_question (    id			INT UNSIGNED NOT NULL AUTO_INCREMENT,    survey_id	INT UNSIGNED NOT NULL,    n...) % line   89, file: dmllib.php
   execute_sql(CREATE TABLE mdl_questionnaire_question (    id			INT UNSIGNED NOT NULL AUTO_INCREMENT,    survey_id	INT UNSIGNED NOT NULL,    n...) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

(mysql): CREATE TABLE mdl_questionnaire_question_choice ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, question_id INT UNSIGNED NOT NULL, content TEXT NOT NULL, value TEXT, PRIMARY KEY (id))

1050: Table 'mdl_questionnaire_question_choice' already exists

         ADOConnection._Execute(CREATE TABLE mdl_questionnaire_question_choice (    id			INT UNSIGNED NOT NULL AUTO_INCREMENT,    question_id	INT UNSIGNED NOT N..., false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(CREATE TABLE mdl_questionnaire_question_choice (    id			INT UNSIGNED NOT NULL AUTO_INCREMENT,    question_id	INT UNSIGNED NOT N...) % line   89, file: dmllib.php
   execute_sql(CREATE TABLE mdl_questionnaire_question_choice (    id			INT UNSIGNED NOT NULL AUTO_INCREMENT,    question_id	INT UNSIGNED NOT N...) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

1050: Table 'mdl_questionnaire_response' already exists

         ADOConnection._Execute(CREATE TABLE mdl_questionnaire_response (    id			INT UNSIGNED NOT NULL AUTO_INCREMENT,    survey_id	INT UNSIGNED NOT NULL,    s..., false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(CREATE TABLE mdl_questionnaire_response (    id			INT UNSIGNED NOT NULL AUTO_INCREMENT,    survey_id	INT UNSIGNED NOT NULL,    s...) % line   89, file: dmllib.php
   execute_sql(CREATE TABLE mdl_questionnaire_response (    id			INT UNSIGNED NOT NULL AUTO_INCREMENT,    survey_id	INT UNSIGNED NOT NULL,    s...) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

1050: Table 'mdl_questionnaire_response_bool' already exists

         ADOConnection._Execute(CREATE TABLE mdl_questionnaire_response_bool (    `id` int(11) NOT NULL auto_increment,    response_id	INT UNSIGNED NOT NULL,   ..., false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(CREATE TABLE mdl_questionnaire_response_bool (    `id` int(11) NOT NULL auto_increment,    response_id	INT UNSIGNED NOT NULL,   ...) % line   89, file: dmllib.php
   execute_sql(CREATE TABLE mdl_questionnaire_response_bool (    `id` int(11) NOT NULL auto_increment,    response_id	INT UNSIGNED NOT NULL,   ...) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

1050: Table 'mdl_questionnaire_response_single' already exists

         ADOConnection._Execute(CREATE TABLE mdl_questionnaire_response_single (    `id` int(11) NOT NULL auto_increment,    response_id	INT UNSIGNED NOT NULL, ..., false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(CREATE TABLE mdl_questionnaire_response_single (    `id` int(11) NOT NULL auto_increment,    response_id	INT UNSIGNED NOT NULL, ...) % line   89, file: dmllib.php
   execute_sql(CREATE TABLE mdl_questionnaire_response_single (    `id` int(11) NOT NULL auto_increment,    response_id	INT UNSIGNED NOT NULL, ...) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

1050: Table 'mdl_questionnaire_response_multiple' already exists

         ADOConnection._Execute(CREATE TABLE mdl_questionnaire_response_multiple (    id			INT UNSIGNED NOT NULL AUTO_INCREMENT,    response_id	INT UNSIGNED NOT..., false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(CREATE TABLE mdl_questionnaire_response_multiple (    id			INT UNSIGNED NOT NULL AUTO_INCREMENT,    response_id	INT UNSIGNED NOT...) % line   89, file: dmllib.php
   execute_sql(CREATE TABLE mdl_questionnaire_response_multiple (    id			INT UNSIGNED NOT NULL AUTO_INCREMENT,    response_id	INT UNSIGNED NOT...) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

1050: Table 'mdl_questionnaire_response_rank' already exists

         ADOConnection._Execute(CREATE TABLE mdl_questionnaire_response_rank (    `id` int(11) NOT NULL auto_increment,    response_id	INT UNSIGNED NOT NULL,   ..., false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(CREATE TABLE mdl_questionnaire_response_rank (    `id` int(11) NOT NULL auto_increment,    response_id	INT UNSIGNED NOT NULL,   ...) % line   89, file: dmllib.php
   execute_sql(CREATE TABLE mdl_questionnaire_response_rank (    `id` int(11) NOT NULL auto_increment,    response_id	INT UNSIGNED NOT NULL,   ...) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

1050: Table 'mdl_questionnaire_response_text' already exists

         ADOConnection._Execute(CREATE TABLE mdl_questionnaire_response_text (    `id` int(11) NOT NULL auto_increment,    response_id	INT UNSIGNED NOT NULL,   ..., false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(CREATE TABLE mdl_questionnaire_response_text (    `id` int(11) NOT NULL auto_increment,    response_id	INT UNSIGNED NOT NULL,   ...) % line   89, file: dmllib.php
   execute_sql(CREATE TABLE mdl_questionnaire_response_text (    `id` int(11) NOT NULL auto_increment,    response_id	INT UNSIGNED NOT NULL,   ...) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

1050: Table 'mdl_questionnaire_response_other' already exists

         ADOConnection._Execute(CREATE TABLE mdl_questionnaire_response_other (    `id` int(11) NOT NULL auto_increment,    response_id	INT UNSIGNED NOT NULL,  ..., false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(CREATE TABLE mdl_questionnaire_response_other (    `id` int(11) NOT NULL auto_increment,    response_id	INT UNSIGNED NOT NULL,  ...) % line   89, file: dmllib.php
   execute_sql(CREATE TABLE mdl_questionnaire_response_other (    `id` int(11) NOT NULL auto_increment,    response_id	INT UNSIGNED NOT NULL,  ...) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

1050: Table 'mdl_questionnaire_response_date' already exists

         ADOConnection._Execute(CREATE TABLE mdl_questionnaire_response_date (    `id` int(11) NOT NULL auto_increment,    response_id	INT UNSIGNED NOT NULL,   ..., false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(CREATE TABLE mdl_questionnaire_response_date (    `id` int(11) NOT NULL auto_increment,    response_id	INT UNSIGNED NOT NULL,   ...) % line   89, file: dmllib.php
   execute_sql(CREATE TABLE mdl_questionnaire_response_date (    `id` int(11) NOT NULL auto_increment,    response_id	INT UNSIGNED NOT NULL,   ...) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

(mysql): INSERT INTO mdl_questionnaire_question_type VALUES ('1','Yes/No','N','response_bool')

1062: Duplicate entry '1' for key 'PRIMARY'

         ADOConnection._Execute(INSERT INTO mdl_questionnaire_question_type VALUES ('1','Yes/No','N','response_bool'), false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(INSERT INTO mdl_questionnaire_question_type VALUES ('1','Yes/No','N','response_bool')) % line   89, file: dmllib.php
   execute_sql(INSERT INTO mdl_questionnaire_question_type VALUES ('1','Yes/No','N','response_bool')) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

(mysql): INSERT INTO mdl_questionnaire_question_type VALUES ('2','Text Box','N','response_text')

1062: Duplicate entry '2' for key 'PRIMARY'

         ADOConnection._Execute(INSERT INTO mdl_questionnaire_question_type VALUES ('2','Text Box','N','response_text'), false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(INSERT INTO mdl_questionnaire_question_type VALUES ('2','Text Box','N','response_text')) % line   89, file: dmllib.php
   execute_sql(INSERT INTO mdl_questionnaire_question_type VALUES ('2','Text Box','N','response_text')) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

(mysql): INSERT INTO mdl_questionnaire_question_type VALUES ('3','Essay Box','N','response_text')

1062: Duplicate entry '3' for key 'PRIMARY'

         ADOConnection._Execute(INSERT INTO mdl_questionnaire_question_type VALUES ('3','Essay Box','N','response_text'), false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(INSERT INTO mdl_questionnaire_question_type VALUES ('3','Essay Box','N','response_text')) % line   89, file: dmllib.php
   execute_sql(INSERT INTO mdl_questionnaire_question_type VALUES ('3','Essay Box','N','response_text')) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

(mysql): INSERT INTO mdl_questionnaire_question_type VALUES ('4','Radio Buttons','Y','response_single')

1062: Duplicate entry '4' for key 'PRIMARY'

         ADOConnection._Execute(INSERT INTO mdl_questionnaire_question_type VALUES ('4','Radio Buttons','Y','response_single'), false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(INSERT INTO mdl_questionnaire_question_type VALUES ('4','Radio Buttons','Y','response_single')) % line   89, file: dmllib.php
   execute_sql(INSERT INTO mdl_questionnaire_question_type VALUES ('4','Radio Buttons','Y','response_single')) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

(mysql): INSERT INTO mdl_questionnaire_question_type VALUES ('5','Check Boxes','Y','response_multiple')

1062: Duplicate entry '5' for key 'PRIMARY'

         ADOConnection._Execute(INSERT INTO mdl_questionnaire_question_type VALUES ('5','Check Boxes','Y','response_multiple'), false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(INSERT INTO mdl_questionnaire_question_type VALUES ('5','Check Boxes','Y','response_multiple')) % line   89, file: dmllib.php
   execute_sql(INSERT INTO mdl_questionnaire_question_type VALUES ('5','Check Boxes','Y','response_multiple')) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

(mysql): INSERT INTO mdl_questionnaire_question_type VALUES ('6','Dropdown Box','Y','response_single')

1062: Duplicate entry '6' for key 'PRIMARY'

         ADOConnection._Execute(INSERT INTO mdl_questionnaire_question_type VALUES ('6','Dropdown Box','Y','response_single'), false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(INSERT INTO mdl_questionnaire_question_type VALUES ('6','Dropdown Box','Y','response_single')) % line   89, file: dmllib.php
   execute_sql(INSERT INTO mdl_questionnaire_question_type VALUES ('6','Dropdown Box','Y','response_single')) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

(mysql): INSERT INTO mdl_questionnaire_question_type VALUES ('8','Rate (scale 1..5)','Y','response_rank')

1062: Duplicate entry '8' for key 'PRIMARY'

         ADOConnection._Execute(INSERT INTO mdl_questionnaire_question_type VALUES ('8','Rate (scale 1..5)','Y','response_rank'), false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(INSERT INTO mdl_questionnaire_question_type VALUES ('8','Rate (scale 1..5)','Y','response_rank')) % line   89, file: dmllib.php
   execute_sql(INSERT INTO mdl_questionnaire_question_type VALUES ('8','Rate (scale 1..5)','Y','response_rank')) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

(mysql): INSERT INTO mdl_questionnaire_question_type VALUES ('9','Date','N','response_date')

1062: Duplicate entry '9' for key 'PRIMARY'

         ADOConnection._Execute(INSERT INTO mdl_questionnaire_question_type VALUES ('9','Date','N','response_date'), false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(INSERT INTO mdl_questionnaire_question_type VALUES ('9','Date','N','response_date')) % line   89, file: dmllib.php
   execute_sql(INSERT INTO mdl_questionnaire_question_type VALUES ('9','Date','N','response_date')) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

(mysql): INSERT INTO mdl_questionnaire_question_type VALUES ('10','Numeric','N','response_text')

1062: Duplicate entry '10' for key 'PRIMARY'

         ADOConnection._Execute(INSERT INTO mdl_questionnaire_question_type VALUES ('10','Numeric','N','response_text'), false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(INSERT INTO mdl_questionnaire_question_type VALUES ('10','Numeric','N','response_text')) % line   89, file: dmllib.php
   execute_sql(INSERT INTO mdl_questionnaire_question_type VALUES ('10','Numeric','N','response_text')) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

(mysql): INSERT INTO mdl_questionnaire_question_type VALUES ('99','Page Break','N','')

1062: Duplicate entry '99' for key 'PRIMARY'

         ADOConnection._Execute(INSERT INTO mdl_questionnaire_question_type VALUES ('99','Page Break','N',''), false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(INSERT INTO mdl_questionnaire_question_type VALUES ('99','Page Break','N','')) % line   89, file: dmllib.php
   execute_sql(INSERT INTO mdl_questionnaire_question_type VALUES ('99','Page Break','N','')) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

(mysql): INSERT INTO mdl_questionnaire_question_type VALUES ('100','Section Text','N','')

1062: Duplicate entry '100' for key 'PRIMARY'

         ADOConnection._Execute(INSERT INTO mdl_questionnaire_question_type VALUES ('100','Section Text','N',''), false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(INSERT INTO mdl_questionnaire_question_type VALUES ('100','Section Text','N','')) % line   89, file: dmllib.php
   execute_sql(INSERT INTO mdl_questionnaire_question_type VALUES ('100','Section Text','N','')) % line  235, file: dmllib.php
modify_database(/var/www/html/ems/mod/questionnaire/db/mysql.sql) % line  392, file: adminlib.php
upgrade_activity_modules(http://www.brokenshire.edu.ph/ems/admin/index.php) % line  433, file: index.php

Error

questionnaire tables could NOT be set up successfully!