lesson


(mysql): CREATE TABLE mdl_lesson ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', practice SMALLINT(3) unsigned NOT NULL DEFAULT 0, modattempts SMALLINT(3) unsigned NOT NULL DEFAULT 0, usepassword SMALLINT(3) unsigned NOT NULL DEFAULT 0, password VARCHAR(32) NOT NULL DEFAULT '', dependency BIGINT(10) unsigned NOT NULL DEFAULT 0, conditions TEXT NOT NULL, grade SMALLINT(3) NOT NULL DEFAULT 0, custom SMALLINT(3) unsigned NOT NULL DEFAULT 0, ongoing SMALLINT(3) unsigned NOT NULL DEFAULT 0, usemaxgrade SMALLINT(3) NOT NULL DEFAULT 0, maxanswers SMALLINT(3) unsigned NOT NULL DEFAULT 4, maxattempts SMALLINT(3) unsigned NOT NULL DEFAULT 5, review SMALLINT(3) unsigned NOT NULL DEFAULT 0, nextpagedefault SMALLINT(3) unsigned NOT NULL DEFAULT 0, feedback SMALLINT(3) unsigned NOT NULL DEFAULT 1, minquestions SMALLINT(3) unsigned NOT NULL DEFAULT 0, maxpages SMALLINT(3) unsigned NOT NULL DEFAULT 0, timed SMALLINT(3) unsigned NOT NULL DEFAULT 0, maxtime BIGINT(10) unsigned NOT NULL DEFAULT 0, retake SMALLINT(3) unsigned NOT NULL DEFAULT 1, activitylink BIGINT(10) unsigned NOT NULL DEFAULT 0, mediafile VARCHAR(255) NOT NULL DEFAULT '', mediaheight BIGINT(10) unsigned NOT NULL DEFAULT 100, mediawidth BIGINT(10) unsigned NOT NULL DEFAULT 650, mediaclose SMALLINT(3) unsigned NOT NULL DEFAULT 0, slideshow SMALLINT(3) unsigned NOT NULL DEFAULT 0, width BIGINT(10) unsigned NOT NULL DEFAULT 640, height BIGINT(10) unsigned NOT NULL DEFAULT 480, bgcolor VARCHAR(7) NOT NULL DEFAULT '#FFFFFF', displayleft SMALLINT(3) unsigned NOT NULL DEFAULT 0, displayleftif SMALLINT(3) unsigned NOT NULL DEFAULT 0, progressbar SMALLINT(3) unsigned NOT NULL DEFAULT 0, highscores SMALLINT(3) unsigned NOT NULL DEFAULT 0, maxhighscores BIGINT(10) unsigned NOT NULL DEFAULT 0, available BIGINT(10) unsigned NOT NULL DEFAULT 0, deadline BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )  
1050: Table 'mdl_lesson' already exists
            ADOConnection._Execute(CREATE TABLE mdl_lesson (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    course BIGINT(10) unsigned NOT NULL DEFAULT 0,..., false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(CREATE TABLE mdl_lesson (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    course BIGINT(10) unsigned NOT NULL DEFAULT 0,...) % line   89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_lesson (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    course BIGINT(10) unsigned NOT NULL DEFAULT 0,..., true) % line 2302, file: dmllib.php
   execute_sql_arr(Array[21]) % line  635, file: ddllib.php
install_from_xmldb_file(/home/krusutha/domains/krusutham.com/public_html/mod/lesson/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_lesson COMMENT='Defines lesson'  
Success

(mysql): CREATE TABLE mdl_lesson_pages ( id BIGINT(10) unsigned NOT NULL auto_increment, lessonid BIGINT(10) unsigned NOT NULL DEFAULT 0, prevpageid BIGINT(10) unsigned NOT NULL DEFAULT 0, nextpageid BIGINT(10) unsigned NOT NULL DEFAULT 0, qtype SMALLINT(3) unsigned NOT NULL DEFAULT 0, qoption SMALLINT(3) unsigned NOT NULL DEFAULT 0, layout SMALLINT(3) unsigned NOT NULL DEFAULT 1, display SMALLINT(3) unsigned NOT NULL DEFAULT 1, timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, title VARCHAR(255) NOT NULL DEFAULT '', contents TEXT NOT NULL, CONSTRAINT PRIMARY KEY (id) )  
1050: Table 'mdl_lesson_pages' already exists
            ADOConnection._Execute(CREATE TABLE mdl_lesson_pages (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    lessonid BIGINT(10) unsigned NOT NULL DE..., false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(CREATE TABLE mdl_lesson_pages (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    lessonid BIGINT(10) unsigned NOT NULL DE...) % line   89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_lesson_pages (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    lessonid BIGINT(10) unsigned NOT NULL DE..., true) % line 2302, file: dmllib.php
   execute_sql_arr(Array[21]) % line  635, file: ddllib.php
install_from_xmldb_file(/home/krusutha/domains/krusutham.com/public_html/mod/lesson/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_lesson_pages COMMENT='Defines lesson_pages'  
Success

(mysql): CREATE TABLE mdl_lesson_answers ( id BIGINT(10) unsigned NOT NULL auto_increment, lessonid BIGINT(10) unsigned NOT NULL DEFAULT 0, pageid BIGINT(10) unsigned NOT NULL DEFAULT 0, jumpto BIGINT(11) NOT NULL DEFAULT 0, grade SMALLINT(3) unsigned NOT NULL DEFAULT 0, score BIGINT(10) NOT NULL DEFAULT 0, flags SMALLINT(3) unsigned NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, answer TEXT, response TEXT, CONSTRAINT PRIMARY KEY (id) )  
1050: Table 'mdl_lesson_answers' already exists
            ADOConnection._Execute(CREATE TABLE mdl_lesson_answers (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    lessonid BIGINT(10) unsigned NOT NULL ..., false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(CREATE TABLE mdl_lesson_answers (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    lessonid BIGINT(10) unsigned NOT NULL ...) % line   89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_lesson_answers (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    lessonid BIGINT(10) unsigned NOT NULL ..., true) % line 2302, file: dmllib.php
   execute_sql_arr(Array[21]) % line  635, file: ddllib.php
install_from_xmldb_file(/home/krusutha/domains/krusutham.com/public_html/mod/lesson/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_lesson_answers COMMENT='Defines lesson_answers'  
Success

(mysql): CREATE TABLE mdl_lesson_attempts ( id BIGINT(10) unsigned NOT NULL auto_increment, lessonid BIGINT(10) unsigned NOT NULL DEFAULT 0, pageid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, answerid BIGINT(10) unsigned NOT NULL DEFAULT 0, retry SMALLINT(3) unsigned NOT NULL DEFAULT 0, correct BIGINT(10) unsigned NOT NULL DEFAULT 0, useranswer TEXT, timeseen BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )  
1050: Table 'mdl_lesson_attempts' already exists
            ADOConnection._Execute(CREATE TABLE mdl_lesson_attempts (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    lessonid BIGINT(10) unsigned NOT NULL..., false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(CREATE TABLE mdl_lesson_attempts (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    lessonid BIGINT(10) unsigned NOT NULL...) % line   89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_lesson_attempts (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    lessonid BIGINT(10) unsigned NOT NULL..., true) % line 2302, file: dmllib.php
   execute_sql_arr(Array[21]) % line  635, file: ddllib.php
install_from_xmldb_file(/home/krusutha/domains/krusutham.com/public_html/mod/lesson/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_lesson_attempts COMMENT='Defines lesson_attempts'  
Success

(mysql): CREATE TABLE mdl_lesson_grades ( id BIGINT(10) unsigned NOT NULL auto_increment, lessonid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, grade DOUBLE unsigned NOT NULL DEFAULT 0, late SMALLINT(3) unsigned NOT NULL DEFAULT 0, completed BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )  
1050: Table 'mdl_lesson_grades' already exists
            ADOConnection._Execute(CREATE TABLE mdl_lesson_grades (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    lessonid BIGINT(10) unsigned NOT NULL D..., false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(CREATE TABLE mdl_lesson_grades (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    lessonid BIGINT(10) unsigned NOT NULL D...) % line   89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_lesson_grades (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    lessonid BIGINT(10) unsigned NOT NULL D..., true) % line 2302, file: dmllib.php
   execute_sql_arr(Array[21]) % line  635, file: ddllib.php
install_from_xmldb_file(/home/krusutha/domains/krusutham.com/public_html/mod/lesson/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_lesson_grades COMMENT='Defines lesson_grades'  
Success

(mysql): CREATE TABLE mdl_lesson_default ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, practice SMALLINT(3) unsigned NOT NULL DEFAULT 0, modattempts SMALLINT(3) unsigned NOT NULL DEFAULT 0, usepassword SMALLINT(3) unsigned NOT NULL DEFAULT 0, password VARCHAR(32) NOT NULL DEFAULT '', conditions TEXT NOT NULL, grade SMALLINT(3) NOT NULL DEFAULT 0, custom SMALLINT(3) unsigned NOT NULL DEFAULT 0, ongoing SMALLINT(3) unsigned NOT NULL DEFAULT 0, usemaxgrade SMALLINT(3) unsigned NOT NULL DEFAULT 0, maxanswers SMALLINT(3) unsigned NOT NULL DEFAULT 4, maxattempts SMALLINT(3) unsigned NOT NULL DEFAULT 5, review SMALLINT(3) unsigned NOT NULL DEFAULT 0, nextpagedefault SMALLINT(3) unsigned NOT NULL DEFAULT 0, feedback SMALLINT(3) unsigned NOT NULL DEFAULT 1, minquestions SMALLINT(3) unsigned NOT NULL DEFAULT 0, maxpages SMALLINT(3) unsigned NOT NULL DEFAULT 0, timed SMALLINT(3) unsigned NOT NULL DEFAULT 0, maxtime BIGINT(10) unsigned NOT NULL DEFAULT 0, retake SMALLINT(3) unsigned NOT NULL DEFAULT 1, mediaheight BIGINT(10) unsigned NOT NULL DEFAULT 100, mediawidth BIGINT(10) unsigned NOT NULL DEFAULT 650, mediaclose SMALLINT(3) unsigned NOT NULL DEFAULT 0, slideshow SMALLINT(3) unsigned NOT NULL DEFAULT 0, width BIGINT(10) unsigned NOT NULL DEFAULT 640, height BIGINT(10) unsigned NOT NULL DEFAULT 480, bgcolor VARCHAR(7) DEFAULT '#FFFFFF', displayleft SMALLINT(3) unsigned NOT NULL DEFAULT 0, displayleftif SMALLINT(3) unsigned NOT NULL DEFAULT 0, progressbar SMALLINT(3) unsigned NOT NULL DEFAULT 0, highscores SMALLINT(3) unsigned NOT NULL DEFAULT 0, maxhighscores BIGINT(10) NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )  
1050: Table 'mdl_lesson_default' already exists
            ADOConnection._Execute(CREATE TABLE mdl_lesson_default (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    course BIGINT(10) unsigned NOT NULL DE..., false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(CREATE TABLE mdl_lesson_default (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    course BIGINT(10) unsigned NOT NULL DE...) % line   89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_lesson_default (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    course BIGINT(10) unsigned NOT NULL DE..., true) % line 2302, file: dmllib.php
   execute_sql_arr(Array[21]) % line  635, file: ddllib.php
install_from_xmldb_file(/home/krusutha/domains/krusutham.com/public_html/mod/lesson/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_lesson_default COMMENT='Defines lesson_default'  
Success

(mysql): CREATE TABLE mdl_lesson_timer ( id BIGINT(10) unsigned NOT NULL auto_increment, lessonid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, starttime BIGINT(10) unsigned NOT NULL DEFAULT 0, lessontime BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )  
1050: Table 'mdl_lesson_timer' already exists
            ADOConnection._Execute(CREATE TABLE mdl_lesson_timer (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    lessonid BIGINT(10) unsigned NOT NULL DE..., false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(CREATE TABLE mdl_lesson_timer (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    lessonid BIGINT(10) unsigned NOT NULL DE...) % line   89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_lesson_timer (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    lessonid BIGINT(10) unsigned NOT NULL DE..., true) % line 2302, file: dmllib.php
   execute_sql_arr(Array[21]) % line  635, file: ddllib.php
install_from_xmldb_file(/home/krusutha/domains/krusutham.com/public_html/mod/lesson/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_lesson_timer COMMENT='lesson timer for each lesson'  
Success

(mysql): CREATE TABLE mdl_lesson_branch ( id BIGINT(10) unsigned NOT NULL auto_increment, lessonid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, pageid BIGINT(10) unsigned NOT NULL DEFAULT 0, retry BIGINT(10) unsigned NOT NULL DEFAULT 0, flag SMALLINT(3) unsigned NOT NULL DEFAULT 0, timeseen BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )  
1050: Table 'mdl_lesson_branch' already exists
            ADOConnection._Execute(CREATE TABLE mdl_lesson_branch (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    lessonid BIGINT(10) unsigned NOT NULL D..., false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(CREATE TABLE mdl_lesson_branch (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    lessonid BIGINT(10) unsigned NOT NULL D...) % line   89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_lesson_branch (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    lessonid BIGINT(10) unsigned NOT NULL D..., true) % line 2302, file: dmllib.php
   execute_sql_arr(Array[21]) % line  635, file: ddllib.php
install_from_xmldb_file(/home/krusutha/domains/krusutham.com/public_html/mod/lesson/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_lesson_branch COMMENT='branches for each lesson/user'  
Success

(mysql): CREATE TABLE mdl_lesson_high_scores ( id BIGINT(10) unsigned NOT NULL auto_increment, lessonid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, gradeid BIGINT(10) unsigned NOT NULL DEFAULT 0, nickname VARCHAR(5) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )  
1050: Table 'mdl_lesson_high_scores' already exists
            ADOConnection._Execute(CREATE TABLE mdl_lesson_high_scores (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    lessonid BIGINT(10) unsigned NOT N..., false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(CREATE TABLE mdl_lesson_high_scores (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    lessonid BIGINT(10) unsigned NOT N...) % line   89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_lesson_high_scores (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    lessonid BIGINT(10) unsigned NOT N..., true) % line 2302, file: dmllib.php
   execute_sql_arr(Array[21]) % line  635, file: ddllib.php
install_from_xmldb_file(/home/krusutha/domains/krusutham.com/public_html/mod/lesson/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_lesson_high_scores COMMENT='high scores for each lesson'  
Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('lesson', 'start', 'lesson', 'name')  
1062: Duplicate entry 'lesson-start' for key 'mdl_logdisp_modact_uix'
            ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('lesson', 'start', 'lesson', 'name'), false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('lesson', 'start', 'lesson', 'name')) % line   89, file: dmllib.php
      execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('lesson', 'start', 'lesson', 'name'), true) % line 2302, file: dmllib.php
   execute_sql_arr(Array[21]) % line  635, file: ddllib.php
install_from_xmldb_file(/home/krusutha/domains/krusutham.com/public_html/mod/lesson/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('lesson', 'end', 'lesson', 'name')  
1062: Duplicate entry 'lesson-end' for key 'mdl_logdisp_modact_uix'
            ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('lesson', 'end', 'lesson', 'name'), false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('lesson', 'end', 'lesson', 'name')) % line   89, file: dmllib.php
      execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('lesson', 'end', 'lesson', 'name'), true) % line 2302, file: dmllib.php
   execute_sql_arr(Array[21]) % line  635, file: ddllib.php
install_from_xmldb_file(/home/krusutha/domains/krusutham.com/public_html/mod/lesson/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('lesson', 'view', 'lesson_pages', 'title')  
1062: Duplicate entry 'lesson-view' for key 'mdl_logdisp_modact_uix'
            ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('lesson', 'view', 'lesson_pages', 'title'), false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('lesson', 'view', 'lesson_pages', 'title')) % line   89, file: dmllib.php
      execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('lesson', 'view', 'lesson_pages', 'title'), true) % line 2302, file: dmllib.php
   execute_sql_arr(Array[21]) % line  635, file: ddllib.php
install_from_xmldb_file(/home/krusutha/domains/krusutham.com/public_html/mod/lesson/db/install.xml) % line  390, file: adminlib.php
Error

lesson tables could NOT be set up successfully!