search

mdjnelson / moodle-mod_customcert

Enables the creation of dynamically generated certificates with complete customisation via the web browser.
https://moodle.org/plugins/mod_customcert
GNU General Public License v3.0
89 stars 157 forks source link

Missing index on customcert_issues table #537

Closed jtsafran closed 6 months ago

jtsafran commented 1 year ago

It looks like there should be an index on userid and customcertid for the customcert_issues table as lookups for a cert issue should be on both fields. Thoughts?

mdjnelson commented 1 year ago

This makes sense to me. Are you able to provide a patch? It will need to update install.xml and have an upgrade for existing sites.

aspark21 commented 6 months ago

this is causing some issues

mdjnelson commented 6 months ago

Are you able to provide more details? I suspect it's because you have multiple issues of the same certificate to one user.