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