assignment
(mysql): SHOW TABLES
(mysql): SHOW INDEX FROM mdl_assignment
(mysql): SHOW TABLES
(mysql): SHOW INDEX FROM mdl_assignment_submissions
(mysql): SHOW TABLES
(mysql): SHOW INDEX FROM mdl_assignment_submissions
(mysql): SHOW TABLES
(mysql): SHOW INDEX FROM mdl_assignment_submissions
(mysql): SHOW TABLES
(mysql): SHOW INDEX FROM mdl_assignment_submissions
(mysql): CREATE TABLE mdl_assignment ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', description TEXT NOT NULL, format SMALLINT(4) unsigned NOT NULL DEFAULT 0, assignmenttype VARCHAR(50) NOT NULL DEFAULT '', resubmit TINYINT(2) unsigned NOT NULL DEFAULT 0, preventlate TINYINT(2) unsigned NOT NULL DEFAULT 0, emailteachers TINYINT(2) unsigned NOT NULL DEFAULT 0, var1 BIGINT(10) DEFAULT 0, var2 BIGINT(10) DEFAULT 0, var3 BIGINT(10) DEFAULT 0, var4 BIGINT(10) DEFAULT 0, var5 BIGINT(10) DEFAULT 0, maxbytes BIGINT(10) unsigned NOT NULL DEFAULT 100000, timedue BIGINT(10) unsigned NOT NULL DEFAULT 0, timeavailable BIGINT(10) unsigned NOT NULL DEFAULT 0, grade BIGINT(10) NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )
1050: Table 'mdl_assignment' already exists
ADOConnection._Execute(CREATE TABLE mdl_assignment (
id BIGINT(10) unsigned NOT NULL auto_increment,
course BIGINT(10) unsigned NOT NULL DEFAUL..., false) % line 891, file: adodb.inc.php
ADOConnection.Execute(CREATE TABLE mdl_assignment (
id BIGINT(10) unsigned NOT NULL auto_increment,
course BIGINT(10) unsigned NOT NULL DEFAUL...) % line 89, file: dmllib.php
execute_sql(CREATE TABLE mdl_assignment (
id BIGINT(10) unsigned NOT NULL auto_increment,
course BIGINT(10) unsigned NOT NULL DEFAUL..., true) % line 2277, file: dmllib.php
execute_sql_arr(Array[14]) % line 635, file: ddllib.php
install_from_xmldb_file(/var/www/web99/html/moodle/mod/assignment/db/install.xml) % line 390, file: adminlib.php
Error
(mysql): ALTER TABLE mdl_assignment COMMENT='Defines assignments'
Success
(mysql): CREATE INDEX mdl_assi_cou_ix ON mdl_assignment (course)
1142: INDEX command denied to user 'web99'@'localhost' for table 'mdl_assignment'
ADOConnection._Execute(CREATE INDEX mdl_assi_cou_ix ON mdl_assignment (course), false) % line 891, file: adodb.inc.php ADOConnection.Execute(CREATE INDEX mdl_assi_cou_ix ON mdl_assignment (course)) % line 89, file: dmllib.php execute_sql(CREATE INDEX mdl_assi_cou_ix ON mdl_assignment (course), true) % line 2277, file: dmllib.php execute_sql_arr(Array[14]) % line 635, file: ddllib.php install_from_xmldb_file(/var/www/web99/html/moodle/mod/assignment/db/install.xml) % line 390, file: adminlib.php
Error
(mysql): CREATE TABLE mdl_assignment_submissions ( id BIGINT(10) unsigned NOT NULL auto_increment, assignment BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, numfiles BIGINT(10) unsigned NOT NULL DEFAULT 0, data1 TEXT, data2 TEXT, grade BIGINT(11) NOT NULL DEFAULT 0, submissioncomment TEXT NOT NULL, format SMALLINT(4) unsigned NOT NULL DEFAULT 0, teacher BIGINT(10) unsigned NOT NULL DEFAULT 0, timemarked BIGINT(10) unsigned NOT NULL DEFAULT 0, mailed TINYINT(1) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )
1050: Table 'mdl_assignment_submissions' already exists
ADOConnection._Execute(CREATE TABLE mdl_assignment_submissions (
id BIGINT(10) unsigned NOT NULL auto_increment,
assignment BIGINT(10) unsigned..., false) % line 891, file: adodb.inc.php
ADOConnection.Execute(CREATE TABLE mdl_assignment_submissions (
id BIGINT(10) unsigned NOT NULL auto_increment,
assignment BIGINT(10) unsigned...) % line 89, file: dmllib.php
execute_sql(CREATE TABLE mdl_assignment_submissions (
id BIGINT(10) unsigned NOT NULL auto_increment,
assignment BIGINT(10) unsigned..., true) % line 2277, file: dmllib.php
execute_sql_arr(Array[14]) % line 635, file: ddllib.php
install_from_xmldb_file(/var/www/web99/html/moodle/mod/assignment/db/install.xml) % line 390, file: adminlib.php
Error
(mysql): ALTER TABLE mdl_assignment_submissions COMMENT='Info about submitted assignments'
Success
(mysql): CREATE INDEX mdl_assisubm_use_ix ON mdl_assignment_submissions (userid)
1142: INDEX command denied to user 'web99'@'localhost' for table 'mdl_assignment_submissions'
ADOConnection._Execute(CREATE INDEX mdl_assisubm_use_ix ON mdl_assignment_submissions (userid), false) % line 891, file: adodb.inc.php ADOConnection.Execute(CREATE INDEX mdl_assisubm_use_ix ON mdl_assignment_submissions (userid)) % line 89, file: dmllib.php execute_sql(CREATE INDEX mdl_assisubm_use_ix ON mdl_assignment_submissions (userid), true) % line 2277, file: dmllib.php execute_sql_arr(Array[14]) % line 635, file: ddllib.php install_from_xmldb_file(/var/www/web99/html/moodle/mod/assignment/db/install.xml) % line 390, file: adminlib.php
Error
(mysql): CREATE INDEX mdl_assisubm_mai_ix ON mdl_assignment_submissions (mailed)
1142: INDEX command denied to user 'web99'@'localhost' for table 'mdl_assignment_submissions'
ADOConnection._Execute(CREATE INDEX mdl_assisubm_mai_ix ON mdl_assignment_submissions (mailed), false) % line 891, file: adodb.inc.php ADOConnection.Execute(CREATE INDEX mdl_assisubm_mai_ix ON mdl_assignment_submissions (mailed)) % line 89, file: dmllib.php execute_sql(CREATE INDEX mdl_assisubm_mai_ix ON mdl_assignment_submissions (mailed), true) % line 2277, file: dmllib.php execute_sql_arr(Array[14]) % line 635, file: ddllib.php install_from_xmldb_file(/var/www/web99/html/moodle/mod/assignment/db/install.xml) % line 390, file: adminlib.php
Error
(mysql): CREATE INDEX mdl_assisubm_tim_ix ON mdl_assignment_submissions (timemarked)
1142: INDEX command denied to user 'web99'@'localhost' for table 'mdl_assignment_submissions'
ADOConnection._Execute(CREATE INDEX mdl_assisubm_tim_ix ON mdl_assignment_submissions (timemarked), false) % line 891, file: adodb.inc.php ADOConnection.Execute(CREATE INDEX mdl_assisubm_tim_ix ON mdl_assignment_submissions (timemarked)) % line 89, file: dmllib.php execute_sql(CREATE INDEX mdl_assisubm_tim_ix ON mdl_assignment_submissions (timemarked), true) % line 2277, file: dmllib.php execute_sql_arr(Array[14]) % line 635, file: ddllib.php install_from_xmldb_file(/var/www/web99/html/moodle/mod/assignment/db/install.xml) % line 390, file: adminlib.php
Error
(mysql): CREATE INDEX mdl_assisubm_ass_ix ON mdl_assignment_submissions (assignment)
1142: INDEX command denied to user 'web99'@'localhost' for table 'mdl_assignment_submissions'
ADOConnection._Execute(CREATE INDEX mdl_assisubm_ass_ix ON mdl_assignment_submissions (assignment), false) % line 891, file: adodb.inc.php ADOConnection.Execute(CREATE INDEX mdl_assisubm_ass_ix ON mdl_assignment_submissions (assignment)) % line 89, file: dmllib.php execute_sql(CREATE INDEX mdl_assisubm_ass_ix ON mdl_assignment_submissions (assignment), true) % line 2277, file: dmllib.php execute_sql_arr(Array[14]) % line 635, file: ddllib.php install_from_xmldb_file(/var/www/web99/html/moodle/mod/assignment/db/install.xml) % line 390, file: adminlib.php
Error
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('assignment', 'view', 'assignment', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('assignment', 'add', 'assignment', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('assignment', 'update', 'assignment', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('assignment', 'view submission', 'assignment', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('assignment', 'upload', 'assignment', 'name')
Success
assignment tables could NOT be set up successfully!