Warning: Creating default object from empty value in /home/imathasdev/dev.imathas.com/moodle/config.php on line 5
Setting up module tables

assignment module needs upgrading


(mysql): CREATE TABLE `assignment` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `description` text NOT NULL, `type` int(10) unsigned NOT NULL default '1', `maxbytes` int(10) unsigned NOT NULL default '100000', `timedue` int(10) unsigned NOT NULL default '0', `grade` int(10) NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) COMMENT='Defines assignments'  
1050: Table 'assignment' already exists
         ADOConnection._Execute(CREATE TABLE `assignment` (
          `id` int(10) unsigned NOT NULL auto_increment,
          `course` int(10) unsigned NOT NUL..., false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(CREATE TABLE `assignment` (
          `id` int(10) unsigned NOT NULL auto_increment,
          `course` int(10) unsigned NOT NUL...) % line   89, file: dmllib.php
   execute_sql(
        CREATE TABLE `assignment` (
          `id` int(10) unsigned NOT NULL auto_increment,
          `course` int(10) unsigne...) % line   29, file: mysql.php
assignment_upgrade(null, Object:stdClass) % line  327, file: adminlib.php
upgrade_activity_modules(http://dev.imathas.com/moodle/admin/index.php) % line  422, file: index.php
Error

(mysql): CREATE TABLE `assignment_submissions` ( `id` int(10) unsigned NOT NULL default '0', `assignment` int(10) unsigned NOT NULL default '0', `user` int(10) unsigned NOT NULL default '0', `timecreated` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', `numfiles` int(10) unsigned NOT NULL default '0', `grade` int(11) NOT NULL default '0', `comment` text NOT NULL, `teacher` int(10) unsigned NOT NULL default '0', `timemarked` int(10) unsigned NOT NULL default '0', `mailed` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) COMMENT='Info about submitted assignments'  
1050: Table 'assignment_submissions' already exists
         ADOConnection._Execute(CREATE TABLE `assignment_submissions` (
          `id` int(10) unsigned NOT NULL default '0',
          `assignment` int(10) uns..., false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(CREATE TABLE `assignment_submissions` (
          `id` int(10) unsigned NOT NULL default '0',
          `assignment` int(10) uns...) % line   89, file: dmllib.php
   execute_sql(
        CREATE TABLE `assignment_submissions` (
          `id` int(10) unsigned NOT NULL default '0',
          `assignment` in...) % line   46, file: mysql.php
assignment_upgrade(null, Object:stdClass) % line  327, file: adminlib.php
upgrade_activity_modules(http://dev.imathas.com/moodle/admin/index.php) % line  422, file: index.php
Error

(mysql): INSERT INTO log_display (module, action, mtable, field) VALUES ('assignment', 'view', 'assignment', 'name')  
1146: Table 'imasmoodle.log_display' doesn't exist
         ADOConnection._Execute(INSERT INTO log_display (module, action, mtable, field) VALUES ('assignment', 'view', 'assignment', 'name'), false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(INSERT INTO log_display (module, action, mtable, field) VALUES ('assignment', 'view', 'assignment', 'name')) % line   89, file: dmllib.php
   execute_sql( INSERT INTO log_display (module, action, mtable, field) VALUES ('assignment', 'view', 'assignment', 'name') ) % line   48, file: mysql.php
assignment_upgrade(null, Object:stdClass) % line  327, file: adminlib.php
upgrade_activity_modules(http://dev.imathas.com/moodle/admin/index.php) % line  422, file: index.php
Error

(mysql): INSERT INTO log_display (module, action, mtable, field) VALUES ('assignment', 'add', 'assignment', 'name')  
1146: Table 'imasmoodle.log_display' doesn't exist
         ADOConnection._Execute(INSERT INTO log_display (module, action, mtable, field) VALUES ('assignment', 'add', 'assignment', 'name'), false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(INSERT INTO log_display (module, action, mtable, field) VALUES ('assignment', 'add', 'assignment', 'name')) % line   89, file: dmllib.php
   execute_sql( INSERT INTO log_display (module, action, mtable, field) VALUES ('assignment', 'add', 'assignment', 'name') ) % line   49, file: mysql.php
assignment_upgrade(null, Object:stdClass) % line  327, file: adminlib.php
upgrade_activity_modules(http://dev.imathas.com/moodle/admin/index.php) % line  422, file: index.php
Error

(mysql): INSERT INTO log_display (module, action, mtable, field) VALUES ('assignment', 'update', 'assignment', 'name')  
1146: Table 'imasmoodle.log_display' doesn't exist
         ADOConnection._Execute(INSERT INTO log_display (module, action, mtable, field) VALUES ('assignment', 'update', 'assignment', 'name'), false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(INSERT INTO log_display (module, action, mtable, field) VALUES ('assignment', 'update', 'assignment', 'name')) % line   89, file: dmllib.php
   execute_sql( INSERT INTO log_display (module, action, mtable, field) VALUES ('assignment', 'update', 'assignment', 'name') ) % line   50, file: mysql.php
assignment_upgrade(null, Object:stdClass) % line  327, file: adminlib.php
upgrade_activity_modules(http://dev.imathas.com/moodle/admin/index.php) % line  422, file: index.php
Error

(mysql): INSERT INTO log_display (module, action, mtable, field) VALUES ('assignment', 'view submissions', 'assignment', 'name')  
1146: Table 'imasmoodle.log_display' doesn't exist
         ADOConnection._Execute(INSERT INTO log_display (module, action, mtable, field) VALUES ('assignment', 'view submissions', 'assignment', 'name'), false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(INSERT INTO log_display (module, action, mtable, field) VALUES ('assignment', 'view submissions', 'assignment', 'name')) % line   89, file: dmllib.php
   execute_sql( INSERT INTO log_display (module, action, mtable, field) VALUES ('assignment', 'view submissions', 'assignment', 'name') ) % line   51, file: mysql.php
assignment_upgrade(null, Object:stdClass) % line  327, file: adminlib.php
upgrade_activity_modules(http://dev.imathas.com/moodle/admin/index.php) % line  422, file: index.php
Error

(mysql): INSERT INTO log_display (module, action, mtable, field) VALUES ('assignment', 'upload', 'assignment', 'name')  
1146: Table 'imasmoodle.log_display' doesn't exist
         ADOConnection._Execute(INSERT INTO log_display (module, action, mtable, field) VALUES ('assignment', 'upload', 'assignment', 'name'), false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(INSERT INTO log_display (module, action, mtable, field) VALUES ('assignment', 'upload', 'assignment', 'name')) % line   89, file: dmllib.php
   execute_sql( INSERT INTO log_display (module, action, mtable, field) VALUES ('assignment', 'upload', 'assignment', 'name') ) % line   52, file: mysql.php
assignment_upgrade(null, Object:stdClass) % line  327, file: adminlib.php
upgrade_activity_modules(http://dev.imathas.com/moodle/admin/index.php) % line  422, file: index.php
Error

(mysql): ALTER TABLE `assignment_submissions` CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT  
Success
Moving location of assignment files...

(mysql): ALTER TABLE `assignment` ADD `format` TINYINT(2) UNSIGNED DEFAULT '0' NOT NULL AFTER `description`  
1060: Duplicate column name 'format'
         ADOConnection._Execute(ALTER TABLE `assignment` ADD `format` TINYINT(2) UNSIGNED DEFAULT '0' NOT NULL AFTER `description`, false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE `assignment` ADD `format` TINYINT(2) UNSIGNED DEFAULT '0' NOT NULL AFTER `description`) % line   89, file: dmllib.php
   execute_sql( ALTER TABLE `assignment` ADD `format` TINYINT(2) UNSIGNED DEFAULT '0' NOT NULL AFTER `description` ) % line   88, file: mysql.php
assignment_upgrade(null, Object:stdClass) % line  327, file: adminlib.php
upgrade_activity_modules(http://dev.imathas.com/moodle/admin/index.php) % line  422, file: index.php
Error

(mysql): UPDATE `assignment` SET `type` = '1'  
Success

(mysql): ALTER TABLE `assignment` ADD `resubmit` TINYINT(2) UNSIGNED DEFAULT '0' NOT NULL AFTER `format`  
1060: Duplicate column name 'resubmit'
         ADOConnection._Execute(ALTER TABLE `assignment` ADD `resubmit` TINYINT(2) UNSIGNED DEFAULT '0' NOT NULL AFTER `format`, false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE `assignment` ADD `resubmit` TINYINT(2) UNSIGNED DEFAULT '0' NOT NULL AFTER `format`) % line   89, file: dmllib.php
   execute_sql( ALTER TABLE `assignment` ADD `resubmit` TINYINT(2) UNSIGNED DEFAULT '0' NOT NULL AFTER `format` ) % line   94, file: mysql.php
assignment_upgrade(null, Object:stdClass) % line  327, file: adminlib.php
upgrade_activity_modules(http://dev.imathas.com/moodle/admin/index.php) % line  422, file: index.php
Error

(mysql): ALTER TABLE `assignment_submissions` CHANGE `user` `userid` INT(10) UNSIGNED DEFAULT '0' NOT NULL  
1054: Unknown column 'user' in 'assignment_submissions'
         ADOConnection._Execute(ALTER TABLE `assignment_submissions` CHANGE `user` `userid` INT(10) UNSIGNED DEFAULT '0' NOT NULL, false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE `assignment_submissions` CHANGE `user` `userid` INT(10) UNSIGNED DEFAULT '0' NOT NULL) % line   89, file: dmllib.php
   execute_sql(ALTER TABLE `assignment_submissions` CHANGE `user` `userid` INT(10) UNSIGNED DEFAULT '0' NOT NULL ) % line   97, file: mysql.php
assignment_upgrade(null, Object:stdClass) % line  327, file: adminlib.php
upgrade_activity_modules(http://dev.imathas.com/moodle/admin/index.php) % line  422, file: index.php
Error

(mysql): UPDATE mdl_log_display SET action = 'view submission' WHERE module = 'assignment' AND action = 'view submissions'  

(mysql): SELECT * FROM mdl_assignment  

(mysql): ALTER TABLE mdl_assignment ADD INDEX course (course)  
Success

(mysql): ALTER TABLE mdl_assignment_submissions ADD INDEX assignment(assignment)  
Success

(mysql): ALTER TABLE mdl_assignment_submissions ADD INDEX userid (userid)  
Success

(mysql): ALTER TABLE mdl_assignment_submissions ADD INDEX mailed (mailed)  
Success

(mysql): ALTER TABLE mdl_assignment_submissions ADD INDEX timemarked (timemarked)  
Success

(mysql): ALTER TABLE mdl_assignment ADD emailteachers INTEGER(2) unsigned DEFAULT '0' not null AFTER `resubmit`  
1060: Duplicate column name 'emailteachers'
            ADOConnection._Execute(ALTER TABLE mdl_assignment ADD emailteachers INTEGER(2) unsigned DEFAULT '0' not null AFTER `resubmit`, false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(ALTER TABLE mdl_assignment ADD emailteachers INTEGER(2) unsigned DEFAULT '0' not null AFTER `resubmit`) % line   89, file: dmllib.php
      execute_sql(ALTER TABLE mdl_assignment ADD emailteachers INTEGER(2) unsigned DEFAULT '0' not null AFTER `resubmit`) % line  131, file: ddllib.php
   table_column(assignment, , emailteachers, integer, 2, unsigned, 0, not null, resubmit) % line  122, file: mysql.php
assignment_upgrade(null, Object:stdClass) % line  327, file: adminlib.php
Error

(mysql): SELECT * FROM mdl_assignment WHERE format = '3'  

(mysql): ALTER TABLE mdl_assignment ADD timeavailable INTEGER(10) unsigned DEFAULT '0' not null AFTER `timedue`  
1060: Duplicate column name 'timeavailable'
            ADOConnection._Execute(ALTER TABLE mdl_assignment ADD timeavailable INTEGER(10) unsigned DEFAULT '0' not null AFTER `timedue`, false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(ALTER TABLE mdl_assignment ADD timeavailable INTEGER(10) unsigned DEFAULT '0' not null AFTER `timedue`) % line   89, file: dmllib.php
      execute_sql(ALTER TABLE mdl_assignment ADD timeavailable INTEGER(10) unsigned DEFAULT '0' not null AFTER `timedue`) % line  131, file: ddllib.php
   table_column(assignment, , timeavailable, integer, 10, unsigned, 0, not null, timedue) % line  132, file: mysql.php
assignment_upgrade(null, Object:stdClass) % line  327, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_assignment ADD assignmenttype VARCHAR(50) DEFAULT '' not null AFTER `format`  
1060: Duplicate column name 'assignmenttype'
            ADOConnection._Execute(ALTER TABLE mdl_assignment ADD assignmenttype VARCHAR(50)  DEFAULT '' not null AFTER `format`, false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(ALTER TABLE mdl_assignment ADD assignmenttype VARCHAR(50)  DEFAULT '' not null AFTER `format`) % line   89, file: dmllib.php
      execute_sql(ALTER TABLE mdl_assignment ADD assignmenttype VARCHAR(50)  DEFAULT '' not null AFTER `format`) % line  131, file: ddllib.php
   table_column(assignment, , assignmenttype, varchar, 50, , , not null, format) % line  133, file: mysql.php
assignment_upgrade(null, Object:stdClass) % line  327, file: adminlib.php
Error

(mysql): UPDATE mdl_assignment SET assignmenttype = 'offline' WHERE type = '0'  
1054: Unknown column 'type' in 'where clause'
         ADOConnection._Execute(UPDATE mdl_assignment SET assignmenttype = 'offline' WHERE type = '0', false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(UPDATE mdl_assignment SET assignmenttype = 'offline' WHERE type = '0') % line   89, file: dmllib.php
   execute_sql(UPDATE mdl_assignment SET assignmenttype = 'offline' WHERE type = '0';) % line  134, file: mysql.php
assignment_upgrade(null, Object:stdClass) % line  327, file: adminlib.php
upgrade_activity_modules(http://dev.imathas.com/moodle/admin/index.php) % line  422, file: index.php
Error

(mysql): UPDATE mdl_assignment SET assignmenttype = 'uploadsingle' WHERE type = '1'  
1054: Unknown column 'type' in 'where clause'
         ADOConnection._Execute(UPDATE mdl_assignment SET assignmenttype = 'uploadsingle' WHERE type = '1', false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(UPDATE mdl_assignment SET assignmenttype = 'uploadsingle' WHERE type = '1') % line   89, file: dmllib.php
   execute_sql(UPDATE mdl_assignment SET assignmenttype = 'uploadsingle' WHERE type = '1';) % line  135, file: mysql.php
assignment_upgrade(null, Object:stdClass) % line  327, file: adminlib.php
upgrade_activity_modules(http://dev.imathas.com/moodle/admin/index.php) % line  422, file: index.php
Error

(mysql): ALTER TABLE mdl_assignment DROP type  
1091: Can't DROP 'type'; check that column/key exists
         ADOConnection._Execute(ALTER TABLE mdl_assignment DROP type, false) % line  891, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_assignment DROP type) % line   89, file: dmllib.php
   execute_sql(ALTER TABLE mdl_assignment DROP type;) % line  136, file: mysql.php
assignment_upgrade(null, Object:stdClass) % line  327, file: adminlib.php
upgrade_activity_modules(http://dev.imathas.com/moodle/admin/index.php) % line  422, file: index.php
Error

(mysql): ALTER TABLE mdl_assignment_submissions ADD data2 MEDIUMTEXT DEFAULT '' not null AFTER `numfiles`  
1060: Duplicate column name 'data2'
            ADOConnection._Execute(ALTER TABLE mdl_assignment_submissions ADD data2 MEDIUMTEXT  DEFAULT '' not null AFTER `numfiles`, false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(ALTER TABLE mdl_assignment_submissions ADD data2 MEDIUMTEXT  DEFAULT '' not null AFTER `numfiles`) % line   89, file: dmllib.php
      execute_sql(ALTER TABLE mdl_assignment_submissions ADD data2 MEDIUMTEXT  DEFAULT '' not null AFTER `numfiles`) % line  131, file: ddllib.php
   table_column(assignment_submissions, , data2, MEDIUMTEXT, , , , not null, numfiles) % line  141, file: mysql.php
assignment_upgrade(null, Object:stdClass) % line  327, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_assignment_submissions ADD data1 MEDIUMTEXT DEFAULT '' not null AFTER `numfiles`  
1060: Duplicate column name 'data1'
            ADOConnection._Execute(ALTER TABLE mdl_assignment_submissions ADD data1 MEDIUMTEXT  DEFAULT '' not null AFTER `numfiles`, false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(ALTER TABLE mdl_assignment_submissions ADD data1 MEDIUMTEXT  DEFAULT '' not null AFTER `numfiles`) % line   89, file: dmllib.php
      execute_sql(ALTER TABLE mdl_assignment_submissions ADD data1 MEDIUMTEXT  DEFAULT '' not null AFTER `numfiles`) % line  131, file: ddllib.php
   table_column(assignment_submissions, , data1, MEDIUMTEXT, , , , not null, numfiles) % line  142, file: mysql.php
assignment_upgrade(null, Object:stdClass) % line  327, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_assignment ADD var5 INTEGER(10) DEFAULT '0' null AFTER `emailteachers`  
1060: Duplicate column name 'var5'
            ADOConnection._Execute(ALTER TABLE mdl_assignment ADD var5 INTEGER(10)  DEFAULT '0' null AFTER `emailteachers`, false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(ALTER TABLE mdl_assignment ADD var5 INTEGER(10)  DEFAULT '0' null AFTER `emailteachers`) % line   89, file: dmllib.php
      execute_sql(ALTER TABLE mdl_assignment ADD var5 INTEGER(10)  DEFAULT '0' null AFTER `emailteachers`) % line  131, file: ddllib.php
   table_column(assignment, , var5, integer, 10, , 0, null, emailteachers) % line  147, file: mysql.php
assignment_upgrade(null, Object:stdClass) % line  327, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_assignment ADD var4 INTEGER(10) DEFAULT '0' null AFTER `emailteachers`  
1060: Duplicate column name 'var4'
            ADOConnection._Execute(ALTER TABLE mdl_assignment ADD var4 INTEGER(10)  DEFAULT '0' null AFTER `emailteachers`, false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(ALTER TABLE mdl_assignment ADD var4 INTEGER(10)  DEFAULT '0' null AFTER `emailteachers`) % line   89, file: dmllib.php
      execute_sql(ALTER TABLE mdl_assignment ADD var4 INTEGER(10)  DEFAULT '0' null AFTER `emailteachers`) % line  131, file: ddllib.php
   table_column(assignment, , var4, integer, 10, , 0, null, emailteachers) % line  148, file: mysql.php
assignment_upgrade(null, Object:stdClass) % line  327, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_assignment ADD var3 INTEGER(10) DEFAULT '0' null AFTER `emailteachers`  
1060: Duplicate column name 'var3'
            ADOConnection._Execute(ALTER TABLE mdl_assignment ADD var3 INTEGER(10)  DEFAULT '0' null AFTER `emailteachers`, false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(ALTER TABLE mdl_assignment ADD var3 INTEGER(10)  DEFAULT '0' null AFTER `emailteachers`) % line   89, file: dmllib.php
      execute_sql(ALTER TABLE mdl_assignment ADD var3 INTEGER(10)  DEFAULT '0' null AFTER `emailteachers`) % line  131, file: ddllib.php
   table_column(assignment, , var3, integer, 10, , 0, null, emailteachers) % line  149, file: mysql.php
assignment_upgrade(null, Object:stdClass) % line  327, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_assignment ADD var2 INTEGER(10) DEFAULT '0' null AFTER `emailteachers`  
1060: Duplicate column name 'var2'
            ADOConnection._Execute(ALTER TABLE mdl_assignment ADD var2 INTEGER(10)  DEFAULT '0' null AFTER `emailteachers`, false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(ALTER TABLE mdl_assignment ADD var2 INTEGER(10)  DEFAULT '0' null AFTER `emailteachers`) % line   89, file: dmllib.php
      execute_sql(ALTER TABLE mdl_assignment ADD var2 INTEGER(10)  DEFAULT '0' null AFTER `emailteachers`) % line  131, file: ddllib.php
   table_column(assignment, , var2, integer, 10, , 0, null, emailteachers) % line  150, file: mysql.php
assignment_upgrade(null, Object:stdClass) % line  327, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_assignment ADD var1 INTEGER(10) DEFAULT '0' null AFTER `emailteachers`  
1060: Duplicate column name 'var1'
            ADOConnection._Execute(ALTER TABLE mdl_assignment ADD var1 INTEGER(10)  DEFAULT '0' null AFTER `emailteachers`, false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(ALTER TABLE mdl_assignment ADD var1 INTEGER(10)  DEFAULT '0' null AFTER `emailteachers`) % line   89, file: dmllib.php
      execute_sql(ALTER TABLE mdl_assignment ADD var1 INTEGER(10)  DEFAULT '0' null AFTER `emailteachers`) % line  131, file: ddllib.php
   table_column(assignment, , var1, integer, 10, , 0, null, emailteachers) % line  151, file: mysql.php
assignment_upgrade(null, Object:stdClass) % line  327, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_assignment_submissions ADD format INTEGER(4) unsigned DEFAULT '0' not null AFTER `comment`  
1054: Unknown column 'comment' in 'mdl_assignment_submissions'
            ADOConnection._Execute(ALTER TABLE mdl_assignment_submissions ADD format INTEGER(4) unsigned DEFAULT '0' not null AFTER `comment`, false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(ALTER TABLE mdl_assignment_submissions ADD format INTEGER(4) unsigned DEFAULT '0' not null AFTER `comment`) % line   89, file: dmllib.php
      execute_sql(ALTER TABLE mdl_assignment_submissions ADD format INTEGER(4) unsigned DEFAULT '0' not null AFTER `comment`) % line  131, file: ddllib.php
   table_column(assignment_submissions, , format, integer, 4, unsigned, 0, not null, comment) % line  155, file: mysql.php
assignment_upgrade(null, Object:stdClass) % line  327, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_assignment ADD preventlate INTEGER(2) unsigned DEFAULT '0' not null AFTER `resubmit`  
1060: Duplicate column name 'preventlate'
            ADOConnection._Execute(ALTER TABLE mdl_assignment ADD preventlate INTEGER(2) unsigned DEFAULT '0' not null AFTER `resubmit`, false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(ALTER TABLE mdl_assignment ADD preventlate INTEGER(2) unsigned DEFAULT '0' not null AFTER `resubmit`) % line   89, file: dmllib.php
      execute_sql(ALTER TABLE mdl_assignment ADD preventlate INTEGER(2) unsigned DEFAULT '0' not null AFTER `resubmit`) % line  131, file: ddllib.php
   table_column(assignment, , preventlate, integer, 2, unsigned, 0, not null, resubmit) % line  159, file: mysql.php
assignment_upgrade(null, Object:stdClass) % line  327, file: adminlib.php
Error

(mysql): SELECT * FROM mdl_assignment  

(mysql): ALTER TABLE mdl_assignment_submissions CHANGE comment submissioncomment TEXT DEFAULT '' not null  
1054: Unknown column 'comment' in 'mdl_assignment_submissions'
            ADOConnection._Execute(ALTER TABLE mdl_assignment_submissions CHANGE comment submissioncomment TEXT  DEFAULT '' not null, false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(ALTER TABLE mdl_assignment_submissions CHANGE comment submissioncomment TEXT  DEFAULT '' not null) % line   89, file: dmllib.php
      execute_sql(ALTER TABLE mdl_assignment_submissions CHANGE comment submissioncomment TEXT  DEFAULT '' not null ) % line  131, file: ddllib.php
   table_column(assignment_submissions, comment, submissioncomment, text, , , ) % line  168, file: mysql.php
assignment_upgrade(null, Object:stdClass) % line  327, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_assignment_submissions MODIFY COLUMN data1 TEXT NULL after numfiles  
Success

(mysql): ALTER TABLE mdl_assignment_submissions MODIFY COLUMN data2 TEXT NULL after data1  
Success

(mysql): UPDATE mdl_assignment SET var4=1 WHERE assignmenttype='upload'  
Success
Processing assignment grades, this may take a while if there are many assignments...
assignment tables have been set up correctly


Could not update assignment capabilities!