I'm using moodle 1.8.2+
upgrade from 1.7.11022007
standaard version
My backup was ok, but after restoring ....
Klaarmaken van de tabellen van de module
Je bent hier
· DAB
· / ► Klaarmaken van de tabellen van de module
This script generated 14 warnings - Scroll to the first warning
backupscorm
(mysql): CREATE TABLE mdl_scorm ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', reference VARCHAR(255) NOT NULL DEFAULT '', summary TEXT NOT NULL, version VARCHAR(9) NOT NULL DEFAULT '', maxgrade DOUBLE NOT NULL DEFAULT 0, grademethod TINYINT(2) NOT NULL DEFAULT 0, maxattempt BIGINT(10) NOT NULL DEFAULT 1, updatefreq TINYINT(1) unsigned NOT NULL DEFAULT 0, md5hash VARCHAR(32) NOT NULL DEFAULT '', launch BIGINT(10) unsigned NOT NULL DEFAULT 0, skipview TINYINT(1) unsigned NOT NULL DEFAULT 1, hidebrowse TINYINT(1) NOT NULL DEFAULT 0, hidetoc TINYINT(1) NOT NULL DEFAULT 0, hidenav TINYINT(1) NOT NULL DEFAULT 0, auto TINYINT(1) unsigned NOT NULL DEFAULT 0, popup TINYINT(1) unsigned NOT NULL DEFAULT 0, options VARCHAR(255) NOT NULL DEFAULT '', width BIGINT(10) unsigned NOT NULL DEFAULT 100, height BIGINT(10) unsigned NOT NULL DEFAULT 600, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )
1050: Table 'mdl_scorm' already exists
ADOConnection._Execute(CREATE TABLE mdl_scorm ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, ..., false) % line 889, file:
adodb.inc.php ADOConnection.Execute(CREATE TABLE mdl_scorm ( 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_scorm ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, ..., true) % line 1911, file:
dmllib.php execute_sql_arr(Array[24]) % line 548, file:
ddllib.php install_from_xmldb_file(/home/admin/domains/debergopweb.nl/public_html/moodle/mod/backupscorm/db/install.
xml) % line 328, file:
adminlib.php
Fout Scroll to next warning
(mysql): ALTER TABLE mdl_scorm COMMENT='each table is one SCORM module and its configuration'
Succes
(mysql): CREATE TABLE mdl_scorm_scoes ( id BIGINT(10) unsigned NOT NULL auto_increment, scorm BIGINT(10) unsigned NOT NULL DEFAULT 0, manifest VARCHAR(255) NOT NULL DEFAULT '', organization VARCHAR(255) NOT NULL DEFAULT '', parent VARCHAR(255) NOT NULL DEFAULT '', identifier VARCHAR(255) NOT NULL DEFAULT '', launch VARCHAR(255) NOT NULL DEFAULT '', scormtype VARCHAR(5) NOT NULL DEFAULT '', title VARCHAR(255) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )
1050: Table 'mdl_scorm_scoes' already exists
ADOConnection._Execute(CREATE TABLE mdl_scorm_scoes ( id BIGINT(10) unsigned NOT NULL auto_increment, scorm BIGINT(10) unsigned NOT NULL DEFAUL..., false) % line 889, file:
adodb.inc.php ADOConnection.Execute(CREATE TABLE mdl_scorm_scoes ( id BIGINT(10) unsigned NOT NULL auto_increment, scorm BIGINT(10) unsigned NOT NULL DEFAUL...) % line 89, file:
dmllib.php execute_sql(CREATE TABLE mdl_scorm_scoes ( id BIGINT(10) unsigned NOT NULL auto_increment, scorm BIGINT(10) unsigned NOT NULL DEFAUL..., true) % line 1911, file:
dmllib.php execute_sql_arr(Array[24]) % line 548, file:
ddllib.php install_from_xmldb_file(/home/admin/domains/debergopweb.nl/public_html/moodle/mod/backupscorm/db/install.xml) % line 328, file:
adminlib.php
Scroll to previous warning Fout Scroll to next warning
(mysql): ALTER TABLE mdl_scorm_scoes COMMENT='each SCO part of the SCORM module'
Succes
(mysql): CREATE TABLE mdl_scorm_scoes_data ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', value TEXT NOT NULL, CONSTRAINT PRIMARY KEY (id) )
1050: Table 'mdl_scorm_scoes_data' already exists
ADOConnection._Execute(CREATE TABLE mdl_scorm_scoes_data ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NULL D..., false) % line 889, file:
adodb.inc.php ADOConnection.Execute(CREATE TABLE mdl_scorm_scoes_data ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NULL D...) % line 89, file:
dmllib.php execute_sql(CREATE TABLE mdl_scorm_scoes_data ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NULL D..., true) % line 1911, file:
dmllib.php execute_sql_arr(Array[24]) % line 548, file:
ddllib.php install_from_xmldb_file(/home/admin/domains/debergopweb.nl/public_html/moodle/mod/backupscorm/db/install.xml) % line 328, file:
adminlib.php
Scroll to previous warning Fout Scroll to next warning
(mysql): ALTER TABLE mdl_scorm_scoes_data COMMENT='Contains variable data get from packages'
Succes
(mysql): CREATE TABLE mdl_scorm_scoes_track ( id BIGINT(10) unsigned NOT NULL auto_increment, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, scormid BIGINT(10) NOT NULL DEFAULT 0, scoid BIGINT(10) unsigned NOT NULL DEFAULT 0, attempt BIGINT(10) unsigned NOT NULL DEFAULT 1, element VARCHAR(255) NOT NULL DEFAULT '', value LONGTEXT NOT NULL, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )
1050: Table 'mdl_scorm_scoes_track' already exists
ADOConnection._Execute(CREATE TABLE mdl_scorm_scoes_track ( id BIGINT(10) unsigned NOT NULL auto_increment, userid BIGINT(10) unsigned NOT NULL..., false) % line 889, file:
adodb.inc.php ADOConnection.Execute(CREATE TABLE mdl_scorm_scoes_track ( id BIGINT(10) unsigned NOT NULL auto_increment, userid BIGINT(10) unsigned NOT NULL...) % line 89, file:
dmllib.php execute_sql(CREATE TABLE mdl_scorm_scoes_track ( id BIGINT(10) unsigned NOT NULL auto_increment, userid BIGINT(10) unsigned NOT NULL..., true) % line 1911, file:
dmllib.php execute_sql_arr(Array[24]) % line 548, file:
ddllib.php install_from_xmldb_file(/home/admin/domains/debergopweb.nl/public_html/moodle/mod/backupscorm/db/install.xml) % line 328, file:
adminlib.php
Scroll to previous warning Fout Scroll to next warning
(mysql): ALTER TABLE mdl_scorm_scoes_track COMMENT='to track SCOes'
Succes
(mysql): CREATE TABLE mdl_scorm_seq_objective ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NULL DEFAULT 0, primaryobj TINYINT(1) NOT NULL DEFAULT 0, objectiveid BIGINT(10) unsigned NOT NULL DEFAULT 0, satisfiedbymeasure TINYINT(1) NOT NULL DEFAULT 1, minnormalizedmeasure FLOAT(11,4) unsigned NOT NULL DEFAULT 0.0000, CONSTRAINT PRIMARY KEY (id) )
1050: Table 'mdl_scorm_seq_objective' already exists
ADOConnection._Execute(CREATE TABLE mdl_scorm_seq_objective ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NUL..., false) % line 889, file:
adodb.inc.php ADOConnection.Execute(CREATE TABLE mdl_scorm_seq_objective ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NUL...) % line 89, file:
dmllib.php execute_sql(CREATE TABLE mdl_scorm_seq_objective ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NUL..., true) % line 1911, file:
dmllib.php execute_sql_arr(Array[24]) % line 548, file:
ddllib.php install_from_xmldb_file(/home/admin/domains/debergopweb.nl/public_html/moodle/mod/backupscorm/db/install.xml) % line 328, file:
adminlib.php
Scroll to previous warning Fout Scroll to next warning
(mysql): ALTER TABLE mdl_scorm_seq_objective COMMENT='SCORM2004 objective description'
Succes
(mysql): CREATE TABLE mdl_scorm_seq_mapinfo ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NULL DEFAULT 0, objectiveid BIGINT(10) unsigned NOT NULL DEFAULT 0, targetobjectiveid BIGINT(10) unsigned NOT NULL DEFAULT 0, readsatisfiedstatus TINYINT(1) NOT NULL DEFAULT 1, readnormalizedmeasure TINYINT(1) NOT NULL DEFAULT 1, writesatisfiedstatus TINYINT(1) NOT NULL DEFAULT 0, writenormalizedmeasure TINYINT(1) NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )
1050: Table 'mdl_scorm_seq_mapinfo' already exists
ADOConnection._Execute(CREATE TABLE mdl_scorm_seq_mapinfo ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NULL ..., false) % line 889, file:
adodb.inc.php ADOConnection.Execute(CREATE TABLE mdl_scorm_seq_mapinfo ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NULL ...) % line 89, file:
dmllib.php execute_sql(CREATE TABLE mdl_scorm_seq_mapinfo ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NULL ..., true) % line 1911, file:
dmllib.php execute_sql_arr(Array[24]) % line 548, file:
ddllib.php install_from_xmldb_file(/home/admin/domains/debergopweb.nl/public_html/moodle/mod/backupscorm/db/install.xml) % line 328, file:
adminlib.php
Scroll to previous warning Fout Scroll to next warning
(mysql): ALTER TABLE mdl_scorm_seq_mapinfo COMMENT='SCORM2004 objective mapinfo description'
Succes
(mysql): CREATE TABLE mdl_scorm_seq_ruleconds ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NULL DEFAULT 0, conditioncombination VARCHAR(3) NOT NULL DEFAULT 'all', ruletype TINYINT(2) unsigned NOT NULL DEFAULT 0, action VARCHAR(25) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )
1050: Table 'mdl_scorm_seq_ruleconds' already exists
ADOConnection._Execute(CREATE TABLE mdl_scorm_seq_ruleconds ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NUL..., false) % line 889, file:
adodb.inc.php ADOConnection.Execute(CREATE TABLE mdl_scorm_seq_ruleconds ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NUL...) % line 89, file:
dmllib.php execute_sql(CREATE TABLE mdl_scorm_seq_ruleconds ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NUL..., true) % line 1911, file:
dmllib.php execute_sql_arr(Array[24]) % line 548, file:
ddllib.php install_from_xmldb_file(/home/admin/domains/debergopweb.nl/public_html/moodle/mod/backupscorm/db/install.xml) % line 328, file:
adminlib.php
Scroll to previous warning Fout Scroll to next warning
(mysql): ALTER TABLE mdl_scorm_seq_ruleconds COMMENT='SCORM2004 rule conditions'
Succes
(mysql): CREATE TABLE mdl_scorm_seq_rulecond ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NULL DEFAULT 0, ruleconditionsid BIGINT(10) unsigned NOT NULL DEFAULT 0, refrencedobjective VARCHAR(255) NOT NULL DEFAULT '', measurethreshold FLOAT(11,4) NOT NULL DEFAULT 0.0000, operator VARCHAR(5) NOT NULL DEFAULT 'noOp', cond VARCHAR(30) NOT NULL DEFAULT 'always', CONSTRAINT PRIMARY KEY (id) )
1050: Table 'mdl_scorm_seq_rulecond' already exists
ADOConnection._Execute(CREATE TABLE mdl_scorm_seq_rulecond ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NULL..., false) % line 889, file:
adodb.inc.php ADOConnection.Execute(CREATE TABLE mdl_scorm_seq_rulecond ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NULL...) % line 89, file:
dmllib.php execute_sql(CREATE TABLE mdl_scorm_seq_rulecond ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NULL..., true) % line 1911, file:
dmllib.php execute_sql_arr(Array[24]) % line 548, file:
ddllib.php install_from_xmldb_file(/home/admin/domains/debergopweb.nl/public_html/moodle/mod/backupscorm/db/install.xml) % line 328, file:
adminlib.php
Scroll to previous warning Fout Scroll to next warning
(mysql): ALTER TABLE mdl_scorm_seq_rulecond COMMENT='SCORM2004 rule condition'
Succes
(mysql): CREATE TABLE mdl_scorm_seq_rolluprule ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NULL DEFAULT 0, childactivityset VARCHAR(15) NOT NULL DEFAULT '', minimumcount BIGINT(10) unsigned NOT NULL DEFAULT 0, minimumpercent FLOAT(11,4) unsigned NOT NULL DEFAULT 0.0000, conditioncombination VARCHAR(3) NOT NULL DEFAULT 'all', action VARCHAR(15) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )
1050: Table 'mdl_scorm_seq_rolluprule' already exists
ADOConnection._Execute(CREATE TABLE mdl_scorm_seq_rolluprule ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NU..., false) % line 889, file:
adodb.inc.php ADOConnection.Execute(CREATE TABLE mdl_scorm_seq_rolluprule ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NU...) % line 89, file:
dmllib.php execute_sql(CREATE TABLE mdl_scorm_seq_rolluprule ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NU..., true) % line 1911, file:
dmllib.php execute_sql_arr(Array[24]) % line 548, file:
ddllib.php install_from_xmldb_file(/home/admin/domains/debergopweb.nl/public_html/moodle/mod/backupscorm/db/install.xml) % line 328, file:
adminlib.php
Scroll to previous warning Fout Scroll to next warning
(mysql): ALTER TABLE mdl_scorm_seq_rolluprule COMMENT='SCORM2004 sequencing rule'
Succes
(mysql): CREATE TABLE mdl_scorm_seq_rolluprulecond ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NOT NULL DEFAULT 0, rollupruleid BIGINT(10) unsigned NOT NULL DEFAULT 0, operator VARCHAR(5) NOT NULL DEFAULT 'noOp', cond VARCHAR(25) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )
1050: Table 'mdl_scorm_seq_rolluprulecond' already exists
ADOConnection._Execute(CREATE TABLE mdl_scorm_seq_rolluprulecond ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NO..., false) % line 889, file:
adodb.inc.php ADOConnection.Execute(CREATE TABLE mdl_scorm_seq_rolluprulecond ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NO...) % line 89, file:
dmllib.php execute_sql(CREATE TABLE mdl_scorm_seq_rolluprulecond ( id BIGINT(10) unsigned NOT NULL auto_increment, scoid BIGINT(10) unsigned NO..., true) % line 1911, file:
dmllib.php execute_sql_arr(Array[24]) % line 548, file:
ddllib.php install_from_xmldb_file(/home/admin/domains/debergopweb.nl/public_html/moodle/mod/backupscorm/db/install.xml) % line 328, file:
adminlib.php
Scroll to previous warning Fout Scroll to next warning
(mysql): ALTER TABLE mdl_scorm_seq_rolluprulecond COMMENT='SCORM2004 sequencing rule'
Succes
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('scorm', 'view', 'scorm', 'name')
1062: Duplicate entry 'scorm-view' for key 2
ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('scorm', 'view', 'scorm', 'name'), false) % line 889, file:
adodb.inc.php ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('scorm', 'view', 'scorm', 'name')) % line 89, file:
dmllib.php execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('scorm', 'view', 'scorm', 'name'), true) % line 1911, file:
dmllib.php execute_sql_arr(Array[24]) % line 548, file:
ddllib.php install_from_xmldb_file(/home/admin/domains/debergopweb.nl/public_html/moodle/mod/backupscorm/db/install.xml) % line 328, file:
adminlib.php
Scroll to previous warning Fout Scroll to next warning
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('scorm', 'review', 'scorm', 'name')
1062: Duplicate entry 'scorm-review' for key 2
ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('scorm', 'review', 'scorm', 'name'), false) % line 889, file:
adodb.inc.php ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('scorm', 'review', 'scorm', 'name')) % line 89, file:
dmllib.php execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('scorm', 'review', 'scorm', 'name'), true) % line 1911, file:
dmllib.php execute_sql_arr(Array[24]) % line 548, file:
ddllib.php install_from_xmldb_file(/home/admin/domains/debergopweb.nl/public_html/moodle/mod/backupscorm/db/install.xml) % line 328, file:
adminlib.php
Scroll to previous warning Fout Scroll to next warning
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('scorm', 'update', 'scorm', 'name')
1062: Duplicate entry 'scorm-update' for key 2
ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('scorm', 'update', 'scorm', 'name'), false) % line 889, file:
adodb.inc.php ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('scorm', 'update', 'scorm', 'name')) % line 89, file:
dmllib.php execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('scorm', 'update', 'scorm', 'name'), true) % line 1911, file:
dmllib.php execute_sql_arr(Array[24]) % line 548, file:
ddllib.php install_from_xmldb_file(/home/admin/domains/debergopweb.nl/public_html/moodle/mod/backupscorm/db/install.xml) % line 328, file:
adminlib.php
Scroll to previous warning Fout Scroll to next warning
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('scorm', 'add', 'scorm', 'name')
1062: Duplicate entry 'scorm-add' for key 2
ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('scorm', 'add', 'scorm', 'name'), false) % line 889, file:
adodb.inc.php ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('scorm', 'add', 'scorm', 'name')) % line 89, file:
dmllib.php execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('scorm', 'add', 'scorm', 'name'), true) % line 1911, file:
dmllib.php execute_sql_arr(Array[24]) % line 548, file:
ddllib.php install_from_xmldb_file(/home/admin/domains/debergopweb.nl/public_html/moodle/mod/backupscorm/db/install.xml) % line 328, file:
adminlib.php
Scroll to previous warning Fout Scroll to continue button
backupscorm tables could NOT be set up successfully!