Hi Manieer,
you can see the screenshots in https://moodle.org/mod/forum/discuss.php?d=311795&parent=1259682

Greetings.
Alex.

Hi Manieer,
I'd like to use your plugin in Moodle 2.8.3, but it's not working. I wish I had more useful information for you, but I turned on debugging and I couldn't find any errors anywhere. The block says "You do not have any certificates issued to you." But I do have certificates. I can see them in the database. I created a new certificate and made sure it was set to save, then issued it to a test user, waited for the cron to run, and the block for the test user still says that there are no certificates. Do you know why this might not be working?

Thanks,
-Elisabeth

Hi Elisabeth,
Thank you for reporting this. I am planning to release the updates for 2.8 and 2.9 soon. I just haven't had the chance to work on this due to work and personal commitments. I will be looking to start working on this in the next few weeks and hopefully the fix for 2.8 and 2.9 shouldn't be that bigger change.

I will update this page as soon as I have the updated version. In the meantime if you find any obvious errors or fixes please do let me know.

Thanks,
M

Hi Alex & Elisabeth,
I have just updated the codes and tested on my moodle 2.8.3. It works fine now. Had to change the course module and date format. For some reason I had to uninstall my previous install and reinstall the plugin again. I haven't submitted the final code here but wanted to check if it would work for both of you.

Please download the zip from here - https://github.com/manieer/moodle-block_report_certificates/tree/For-Moodle-2.8

You will need to do a manual install of the plugin. Also this plugin is really aimed for the 'My home page' where you can place it on the main content pane.

Please let me know if you encounter any problems.

Thanks,
M

Hello Manieer,
I just installed the block and everything is correct during installation, but when activating the block following error message:

Error reading the database

Debug info: ERROR: la columna «ci.id» debe aparecer en la cláusula GROUP BY o ser usada en una función de agregación
LINE 1: SELECT DISTINCT ci.id AS certificateid, ci.userid, ci.code A...
^
SELECT DISTINCT ci.id AS certificateid, ci.userid, ci.code AS code,
ci.timecreated AS citimecreated,
crt.name AS certificatename, crt.*,
cm.id AS coursemoduleid, cm.course, cm.module,
c.id AS id, c.fullname AS fullname, c.*,
ctx.id AS contextid, ctx.instanceid AS instanceid,
f.itemid AS itemid, f.filename AS filename
FROM mdl_certificate_issues ci
INNER JOIN mdl_certificate crt
ON crt.id = ci.certificateid
INNER JOIN mdl_course_modules cm
ON cm.course = crt.course
INNER JOIN mdl_course c
ON c.id = cm.course
INNER JOIN mdl_context ctx
ON ctx.instanceid = cm.id
INNER JOIN mdl_files f
ON f.contextid = ctx.id
WHERE ctx.contextlevel = 70 AND
f.mimetype = 'application/pdf' AND
ci.userid = f.userid AND
ci.userid = $1
GROUP BY ci.code
ORDER BY ci.timecreated ASC LIMIT 5
[array (
0 => '2',
)]
Error code: dmlreadexception
Stack trace:

line 443 of \lib\dml\moodle_database.php: dml_read_exception thrown
line 244 of \lib\dml\pgsql_native_moodle_database.php: call to moodle_database->query_end()
line 764 of \lib\dml\pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
line 115 of \blocks\report_certificates\block_report_certificates.php: call to pgsql_native_moodle_database->get_records_sql()
line 288 of \blocks\moodleblock.class.php: call to block_report_certificates->get_content()
line 230 of \blocks\moodleblock.class.php: call to block_base->formatted_contents()
line 971 of \lib\blocklib.php: call to block_base->get_content_for_output()
line 1023 of \lib\blocklib.php: call to block_manager->create_block_contents()
line 392 of \lib\outputrenderers.php: call to block_manager->ensure_content_created()
line 34 of \theme\uikit\layout\frontpage1.php: call to core_renderer->standard_head_html()
line 27 of \theme\uikit\layout\frontpage.php: call to require_once()
line 915 of \lib\outputrenderers.php: call to include()
line 845 of \lib\outputrenderers.php: call to core_renderer->render_page_layout()
line 101 of \index.php: call to core_renderer->header()

I remind you that I'm using the version 2.8.6+

Greetings

Hi Manieer Chhettri,

I am trying to install it on Moodle 2.8.6 but facing a white blank page when trying to update the database. Does it require a specific version of the certificate module? I am currently using 2013021200.

Thanks for you help.

I am trying to install it into v2.9 but get the Validation failed notice. Where can I download a version that works?

Should this block allow admins to get a report of all certificates for all students and courses?

I've added it, but I need to see all student certificates. Does anyone know where I can find something like this? This seems to show only the logged in person's certificates.

Is it possible to install this block on Moodle 2014051202?
I can see that the minimum requirement is 2014051203.

Thanks

Running version 2.9.x with PostgreSQL, I received the same error as Alex Ferrer:

Error reading from database
Debug: ERROR: column "ci.id" must appear in the GROUP BY clause or be used in an aggregate function at character 17
SELECT DISTINCT ci.id AS certificateid, ci.userid, ci.code AS code,
ci.timecreated AS citimecreated,
crt.name AS certificatename, crt.*,
cm.id AS coursemoduleid, cm.course, cm.module,
c.id AS id, c.fullname AS fullname, c.*,
ctx.id AS contextid, ctx.instanceid AS instanceid,
f.itemid AS itemid, f.filename AS filename
FROM mdl_certificate_issues ci
INNER JOIN mdl_certificate crt
ON crt.id = ci.certificateid
INNER JOIN mdl_course_modules cm
ON cm.course = crt.course
INNER JOIN mdl_course c
ON c.id = cm.course
INNER JOIN mdl_context ctx
ON ctx.instanceid = cm.id
INNER JOIN mdl_files f
ON f.contextid = ctx.id
WHERE ctx.contextlevel = 70 AND
f.mimetype = 'application/pdf' AND
ci.userid = f.userid AND
ci.userid = $1
GROUP BY ci.code
ORDER BY ci.timecreated ASC LIMIT 5
[array (\n 0 => '2',
)]
Error code: dmlreadexception
* line 443 of /lib/dml/moodle_database.php: dml_read_exception thrown
* line 244 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
[...]

Hello - would this plugin support a tutor viewing their students certificates? For example, we have a customer who would like to generate the certificates on behalf of their students but using the certificate module, they're unable to view them directly.

This block is addressing highly needed functionality that Moodle seems to be lacking. Is there going to be a version of this plug-in for Moodle 3.0? Have anyone been successfull in installing the current code in 3.0 version of Moodle?

Hi Nels Lindquist,
I think this is to do with PostgreSQL as I use MySQL on my test server. I will test this and report back.

Hi Blue Kearsley,
Not sure what you are really trying to achieve but the full list of issued certificates are already available at course level. Your teachers should be able to go in and view them if they have permissions to do so. I wouldn't want to replicate that feature here as if you have huge list of courses then there could be tons of certificates to display!

Hi Janette Dimitrova,
Thanks and I am currently testing this on Moodle 3. Will upload it here once its ready and tested at my end.

Thank you everyone for your feedback and am glad this has been a helpful plugin.

Regards,
M

Hi, Will you have this block working with the module Custom Certificate mod_customcert ?