certificate


(mysql): CREATE TABLE mdl_certificate ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', intro TEXT, emailteachers TINYINT(2) unsigned NOT NULL DEFAULT 0, emailothers TEXT, savecert TINYINT(2) unsigned NOT NULL DEFAULT 0, reportcert TINYINT(2) unsigned NOT NULL DEFAULT 0, delivery SMALLINT(3) unsigned NOT NULL DEFAULT 0, certificatetype VARCHAR(50) NOT NULL DEFAULT '', borderstyle VARCHAR(30) NOT NULL DEFAULT '0', bordercolor VARCHAR(30) NOT NULL DEFAULT '0', printwmark VARCHAR(30) NOT NULL DEFAULT '0', printdate BIGINT(10) unsigned NOT NULL DEFAULT 0, datefmt BIGINT(10) unsigned NOT NULL DEFAULT 0, printnumber BIGINT(10) unsigned NOT NULL DEFAULT 0, printgrade BIGINT(10) unsigned NOT NULL DEFAULT 0, gradefmt BIGINT(10) unsigned NOT NULL DEFAULT 0, printoutcome BIGINT(10) unsigned NOT NULL DEFAULT 0, printhours TEXT, lockgrade BIGINT(10) unsigned NOT NULL DEFAULT 0, requiredgrade SMALLINT(4) unsigned NOT NULL DEFAULT 0, printteacher BIGINT(10) unsigned NOT NULL DEFAULT 0, customtext TEXT, printsignature VARCHAR(30) NOT NULL DEFAULT '0', printseal VARCHAR(30) NOT NULL DEFAULT '0', timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )  
1050: Table 'mdl_certificate' already exists
            ADOConnection._Execute(CREATE TABLE mdl_certificate (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    course BIGINT(10) unsigned NOT NULL DEFAU..., false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(CREATE TABLE mdl_certificate (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    course BIGINT(10) unsigned NOT NULL DEFAU...) % line   89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_certificate (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    course BIGINT(10) unsigned NOT NULL DEFAU..., true) % line 2364, file: dmllib.php
   execute_sql_arr(Array[11]) % line  635, file: ddllib.php
install_from_xmldb_file(C:\inetpub\vhosts\lifesaverswales/mod/certificate/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_certificate COMMENT='Defines certificates'  
Success

(mysql): CREATE TABLE mdl_certificate_issues ( id BIGINT(10) unsigned NOT NULL auto_increment, certificateid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, studentname VARCHAR(40) NOT NULL DEFAULT '', code VARCHAR(40) DEFAULT NULL, classname VARCHAR(254) NOT NULL DEFAULT '', certdate BIGINT(10) unsigned DEFAULT 0, reportgrade VARCHAR(10) DEFAULT NULL, mailed TINYINT(1) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )  
1050: Table 'mdl_certificate_issues' already exists
            ADOConnection._Execute(CREATE TABLE mdl_certificate_issues (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    certificateid BIGINT(10) unsigned ..., false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(CREATE TABLE mdl_certificate_issues (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    certificateid BIGINT(10) unsigned ...) % line   89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_certificate_issues (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    certificateid BIGINT(10) unsigned ..., true) % line 2364, file: dmllib.php
   execute_sql_arr(Array[11]) % line  635, file: ddllib.php
install_from_xmldb_file(C:\inetpub\vhosts\lifesaverswales/mod/certificate/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_certificate_issues COMMENT='Info about issued certificates'  
Success

(mysql): CREATE TABLE mdl_certificate_linked_modules ( id BIGINT(10) unsigned NOT NULL auto_increment, certificate_id BIGINT(10) unsigned NOT NULL DEFAULT 0, linkid BIGINT(10) NOT NULL DEFAULT 0, linkgrade BIGINT(10) NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )  
1050: Table 'mdl_certificate_linked_modules' already exists
            ADOConnection._Execute(CREATE TABLE mdl_certificate_linked_modules (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    certificate_id BIGINT(10) ..., false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(CREATE TABLE mdl_certificate_linked_modules (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    certificate_id BIGINT(10) ...) % line   89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_certificate_linked_modules (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    certificate_id BIGINT(10) ..., true) % line 2364, file: dmllib.php
   execute_sql_arr(Array[11]) % line  635, file: ddllib.php
install_from_xmldb_file(C:\inetpub\vhosts\lifesaverswales/mod/certificate/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): ALTER TABLE mdl_certificate_linked_modules COMMENT='Defines certificate dependencies'  
Success

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('certificate', 'view', 'certificate', 'name')  
1062: Duplicate entry 'certificate-view' for key 'mdl_logdisp_modact_uix'
            ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('certificate', 'view', 'certificate', 'name'), false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('certificate', 'view', 'certificate', 'name')) % line   89, file: dmllib.php
      execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('certificate', 'view', 'certificate', 'name'), true) % line 2364, file: dmllib.php
   execute_sql_arr(Array[11]) % line  635, file: ddllib.php
install_from_xmldb_file(C:\inetpub\vhosts\lifesaverswales/mod/certificate/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('certificate', 'add', 'certificate', 'name')  
1062: Duplicate entry 'certificate-add' for key 'mdl_logdisp_modact_uix'
            ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('certificate', 'add', 'certificate', 'name'), false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('certificate', 'add', 'certificate', 'name')) % line   89, file: dmllib.php
      execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('certificate', 'add', 'certificate', 'name'), true) % line 2364, file: dmllib.php
   execute_sql_arr(Array[11]) % line  635, file: ddllib.php
install_from_xmldb_file(C:\inetpub\vhosts\lifesaverswales/mod/certificate/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('certificate', 'update', 'certificate', 'name')  
1062: Duplicate entry 'certificate-update' for key 'mdl_logdisp_modact_uix'
            ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('certificate', 'update', 'certificate', 'name'), false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('certificate', 'update', 'certificate', 'name')) % line   89, file: dmllib.php
      execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('certificate', 'update', 'certificate', 'name'), true) % line 2364, file: dmllib.php
   execute_sql_arr(Array[11]) % line  635, file: ddllib.php
install_from_xmldb_file(C:\inetpub\vhosts\lifesaverswales/mod/certificate/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('certificate', 'report', 'certificate', 'name')  
1062: Duplicate entry 'certificate-report' for key 'mdl_logdisp_modact_uix'
            ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('certificate', 'report', 'certificate', 'name'), false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('certificate', 'report', 'certificate', 'name')) % line   89, file: dmllib.php
      execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('certificate', 'report', 'certificate', 'name'), true) % line 2364, file: dmllib.php
   execute_sql_arr(Array[11]) % line  635, file: ddllib.php
install_from_xmldb_file(C:\inetpub\vhosts\lifesaverswales/mod/certificate/db/install.xml) % line  390, file: adminlib.php
Error

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('certificate', 'received', 'certificate', 'name')  
1062: Duplicate entry 'certificate-received' for key 'mdl_logdisp_modact_uix'
            ADOConnection._Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('certificate', 'received', 'certificate', 'name'), false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('certificate', 'received', 'certificate', 'name')) % line   89, file: dmllib.php
      execute_sql(INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('certificate', 'received', 'certificate', 'name'), true) % line 2364, file: dmllib.php
   execute_sql_arr(Array[11]) % line  635, file: ddllib.php
install_from_xmldb_file(C:\inetpub\vhosts\lifesaverswales/mod/certificate/db/install.xml) % line  390, file: adminlib.php
Error

certificate tables could NOT be set up successfully!

Keyboard Shortcuts
(x)

Admin Shortcut keys

Ctrl+Shift+K : Shortcut Details Esc : Return to Moodle
Ctrl+Shift+B : Manage Blocks Ctrl+Shift+M : Manage Activities
Ctrl+Shift+F : Manage Filters Ctrl+Shift+A : Manage Authentication
Ctrl+Shift+S : Schedule calendar Ctrl+Shift+C : Add/Edit Courses
Ctrl+Shift+E : Edit Mode toggle Ctrl+Shift+M : Notifications
Ctrl+Shift+L : Live Logs Ctrl+Shift+U : Browse Users
Ctrl+Shift+H : Moodle Homepage Ctrl+Shift+D : Logout