Hi all,
I am using Moodle 1.9.11 (Build: 20110221) and first time wanted to add module certificate. I downloaded it and placed into mod directory. When I went to notification for installation it is giving me an error below:
"Module "certificate" (2011110101) could not be installed. It requires a newer version of Moodle (currently you are using 2007101591.02, you need 2010102600)"
Have anyone faced similar problem. How can I resolve it?
Regards,
I have the same issue, posted about two months ago with no replies. I wll be watching carefully.
I am about to revert to 1.9.9 so that I can make it work. I HAVE to use the certificate for my classes.
Kevin Duffy
krduffy@me.com
Looks like you are trying to use the Moodle 2.x Certificate module on a Moodle 1.9 site.
The Certificate module for Moodle 1.9 is available from here:
Worked fine for me
Gordon
Tried it three times with 1.9.12 and come up with a whole page of errors.
This script generated 8 warnings - Scroll to the first warning
(mysql): CREATE TABLE mo_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 'mo_certificate' already exists
ADOConnection._Execute(CREATE TABLE mo_certificate ( 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 mo_certificate ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAUL...) % line 89, file: dmllib.php execute_sql(CREATE TABLE mo_certificate ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAUL..., true) % line 2302, file: dmllib.php execute_sql_arr(Array[11]) % line 635, file: ddllib.php install_from_xmldb_file(/home/www/dts-orc.com/moodle_1.9.12/mod/certificate/db/install.xml) % line 390, file: adminlib.php
(mysql): ALTER TABLE mo_certificate COMMENT='Defines certificates'
(mysql): CREATE TABLE mo_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 'mo_certificate_issues' already exists
ADOConnection._Execute(CREATE TABLE mo_certificate_issues ( id BIGINT(10) unsigned NOT NULL auto_increment, certificateid BIGINT(10) unsigned N..., false) % line 891, file: adodb.inc.php ADOConnection.Execute(CREATE TABLE mo_certificate_issues ( id BIGINT(10) unsigned NOT NULL auto_increment, certificateid BIGINT(10) unsigned N...) % line 89, file: dmllib.php execute_sql(CREATE TABLE mo_certificate_issues ( id BIGINT(10) unsigned NOT NULL auto_increment, certificateid BIGINT(10) unsigned N..., true) % line 2302, file: dmllib.php execute_sql_arr(Array[11]) % line 635, file: ddllib.php install_from_xmldb_file(/home/www/dts-orc.com/moodle_1.9.12/mod/certificate/db/install.xml) % line 390, file: adminlib.php
(mysql): ALTER TABLE mo_certificate_issues COMMENT='Info about issued certificates'
(mysql): CREATE TABLE mo_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 'mo_certificate_linked_modules' already exists
ADOConnection._Execute(CREATE TABLE mo_certificate_linked_modules ( id BIGINT(10) unsigned NOT NULL auto_increment, certificate_id BIGINT(10) u..., false) % line 891, file: adodb.inc.php ADOConnection.Execute(CREATE TABLE mo_certificate_linked_modules ( id BIGINT(10) unsigned NOT NULL auto_increment, certificate_id BIGINT(10) u...) % line 89, file: dmllib.php execute_sql(CREATE TABLE mo_certificate_linked_modules ( id BIGINT(10) unsigned NOT NULL auto_increment, certificate_id BIGINT(10) u..., true) % line 2302, file: dmllib.php execute_sql_arr(Array[11]) % line 635, file: ddllib.php install_from_xmldb_file(/home/www/dts-orc.com/moodle_1.9.12/mod/certificate/db/install.xml) % line 390, file: adminlib.php
(mysql): ALTER TABLE mo_certificate_linked_modules COMMENT='Defines certificate dependencies'
(mysql): INSERT INTO mo_log_display(module, action, mtable, field) VALUES ('certificate', 'view', 'certificate', 'name')
1062: Duplicate entry 'certificate-view' for key 2
ADOConnection._Execute(INSERT INTO mo_log_display(module, action, mtable, field) VALUES ('certificate', 'view', 'certificate', 'name'), false) % line 891, file: adodb.inc.php ADOConnection.Execute(INSERT INTO mo_log_display(module, action, mtable, field) VALUES ('certificate', 'view', 'certificate', 'name')) % line 89, file: dmllib.php execute_sql(INSERT INTO mo_log_display(module, action, mtable, field) VALUES ('certificate', 'view', 'certificate', 'name'), true) % line 2302, file: dmllib.php execute_sql_arr(Array[11]) % line 635, file: ddllib.php install_from_xmldb_file(/home/www/dts-orc.com/moodle_1.9.12/mod/certificate/db/install.xml) % line 390, file: adminlib.php
(mysql): INSERT INTO mo_log_display(module, action, mtable, field) VALUES ('certificate', 'add', 'certificate', 'name')
1062: Duplicate entry 'certificate-add' for key 2
ADOConnection._Execute(INSERT INTO mo_log_display(module, action, mtable, field) VALUES ('certificate', 'add', 'certificate', 'name'), false) % line 891, file: adodb.inc.php ADOConnection.Execute(INSERT INTO mo_log_display(module, action, mtable, field) VALUES ('certificate', 'add', 'certificate', 'name')) % line 89, file: dmllib.php execute_sql(INSERT INTO mo_log_display(module, action, mtable, field) VALUES ('certificate', 'add', 'certificate', 'name'), true) % line 2302, file: dmllib.php execute_sql_arr(Array[11]) % line 635, file: ddllib.php install_from_xmldb_file(/home/www/dts-orc.com/moodle_1.9.12/mod/certificate/db/install.xml) % line 390, file: adminlib.php
(mysql): INSERT INTO mo_log_display(module, action, mtable, field) VALUES ('certificate', 'update', 'certificate', 'name')
1062: Duplicate entry 'certificate-update' for key 2
ADOConnection._Execute(INSERT INTO mo_log_display(module, action, mtable, field) VALUES ('certificate', 'update', 'certificate', 'name'), false) % line 891, file: adodb.inc.php ADOConnection.Execute(INSERT INTO mo_log_display(module, action, mtable, field) VALUES ('certificate', 'update', 'certificate', 'name')) % line 89, file: dmllib.php execute_sql(INSERT INTO mo_log_display(module, action, mtable, field) VALUES ('certificate', 'update', 'certificate', 'name'), true) % line 2302, file: dmllib.php execute_sql_arr(Array[11]) % line 635, file: ddllib.php install_from_xmldb_file(/home/www/dts-orc.com/moodle_1.9.12/mod/certificate/db/install.xml) % line 390, file: adminlib.php
(mysql): INSERT INTO mo_log_display(module, action, mtable, field) VALUES ('certificate', 'report', 'certificate', 'name')
1062: Duplicate entry 'certificate-report' for key 2
ADOConnection._Execute(INSERT INTO mo_log_display(module, action, mtable, field) VALUES ('certificate', 'report', 'certificate', 'name'), false) % line 891, file: adodb.inc.php ADOConnection.Execute(INSERT INTO mo_log_display(module, action, mtable, field) VALUES ('certificate', 'report', 'certificate', 'name')) % line 89, file: dmllib.php execute_sql(INSERT INTO mo_log_display(module, action, mtable, field) VALUES ('certificate', 'report', 'certificate', 'name'), true) % line 2302, file: dmllib.php execute_sql_arr(Array[11]) % line 635, file: ddllib.php install_from_xmldb_file(/home/www/dts-orc.com/moodle_1.9.12/mod/certificate/db/install.xml) % line 390, file: adminlib.php
(mysql): INSERT INTO mo_log_display(module, action, mtable, field) VALUES ('certificate', 'received', 'certificate', 'name')
1062: Duplicate entry 'certificate-received' for key 2
ADOConnection._Execute(INSERT INTO mo_log_display(module, action, mtable, field) VALUES ('certificate', 'received', 'certificate', 'name'), false) % line 891, file: adodb.inc.php ADOConnection.Execute(INSERT INTO mo_log_display(module, action, mtable, field) VALUES ('certificate', 'received', 'certificate', 'name')) % line 89, file: dmllib.php execute_sql(INSERT INTO mo_log_display(module, action, mtable, field) VALUES ('certificate', 'received', 'certificate', 'name'), true) % line 2302, file: dmllib.php execute_sql_arr(Array[11]) % line 635, file: ddllib.php install_from_xmldb_file(/home/www/dts-orc.com/moodle_1.9.12/mod/certificate/db/install.xml) % line 390, file: adminlib.php
Kevin,
those message tell us that the previous install of the wrong version of the Certificate module failed, and that the debris from that install is blocking your attempt to install the correct version.
You can fix it. Do this:
This time the install will complete successfully.
good luck - and happy thoughts to you and your customer
Gordon
Thank you very much Gordon.
I just downloaded from your link
http://download.moodle.org/download.php/plugins19/mod/certificate.zip
It worked perfect for me too. Now successfully installed and created few certificates. I was using the wrong version of certificate before. Thanks a lot.
PS: If anyone need the process to create a certificate view this video url:
