assignment


(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 2300, file: dmllib.php
   execute_sql_arr(Array[9]) % line  635, file: ddllib.php
install_from_xmldb_file(/home/elearn/public_html/moodle/mod/assignment/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_assignment COMMENT='Defines assignments'  
Success

(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 2300, file: dmllib.php
   execute_sql_arr(Array[9]) % line  635, file: ddllib.php
install_from_xmldb_file(/home/elearn/public_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): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('assignment', 'view', 'assignment', 'name')  
1062: Duplicate entry 'assignment-view' for key 'mdl_logdisp_modact_uix'
            ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('assignment', 'view', 'assignment', 'name'), false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('assignment', 'view', 'assignment', 'name')) % line   89, file: dmllib.php
      execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('assignment', 'view', 'assignment', 'name'), true) % line 2300, file: dmllib.php
   execute_sql_arr(Array[9]) % line  635, file: ddllib.php
install_from_xmldb_file(/home/elearn/public_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', 'add', 'assignment', 'name')  
1062: Duplicate entry 'assignment-add' for key 'mdl_logdisp_modact_uix'
            ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('assignment', 'add', 'assignment', 'name'), false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('assignment', 'add', 'assignment', 'name')) % line   89, file: dmllib.php
      execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('assignment', 'add', 'assignment', 'name'), true) % line 2300, file: dmllib.php
   execute_sql_arr(Array[9]) % line  635, file: ddllib.php
install_from_xmldb_file(/home/elearn/public_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', 'update', 'assignment', 'name')  
1062: Duplicate entry 'assignment-update' for key 'mdl_logdisp_modact_uix'
            ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('assignment', 'update', 'assignment', 'name'), false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('assignment', 'update', 'assignment', 'name')) % line   89, file: dmllib.php
      execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('assignment', 'update', 'assignment', 'name'), true) % line 2300, file: dmllib.php
   execute_sql_arr(Array[9]) % line  635, file: ddllib.php
install_from_xmldb_file(/home/elearn/public_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 submission', 'assignment', 'name')  
1062: Duplicate entry 'assignment-view submission' for key 'mdl_logdisp_modact_uix'
            ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('assignment', 'view submission', 'assignment', 'name'), false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('assignment', 'view submission', 'assignment', 'name')) % line   89, file: dmllib.php
      execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('assignment', 'view submission', 'assignment', 'name'), true) % line 2300, file: dmllib.php
   execute_sql_arr(Array[9]) % line  635, file: ddllib.php
install_from_xmldb_file(/home/elearn/public_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', 'upload', 'assignment', 'name')  
1062: Duplicate entry 'assignment-upload' for key 'mdl_logdisp_modact_uix'
            ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('assignment', 'upload', 'assignment', 'name'), false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('assignment', 'upload', 'assignment', 'name')) % line   89, file: dmllib.php
      execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('assignment', 'upload', 'assignment', 'name'), true) % line 2300, file: dmllib.php
   execute_sql_arr(Array[9]) % line  635, file: ddllib.php
install_from_xmldb_file(/home/elearn/public_html/moodle/mod/assignment/db/install.xml) % line  390, file: adminlib.php
Error

assignment tables could NOT be set up successfully!