Problem Issuing Certificates

Re: Problem Issuing Certificates

by Zachary Lyons -
Number of replies: 0

Thank you for your reply. I was using the certificate version appropriate for my version of Moodle.

I did get this issue worked out. There was a problem with the upgrade process where it was not creating the "customtext" column. When I manually created the "customtext" column, the problem did not go away, it changed to something else. Here's how I fixed the problem:

  1. Create a development site
  2. Copy the certificate folder into the mod folder
  3. Rename the "mdl_certificate" and "mdl_certificate_issues" to something else
  4. Delete the "certificate" row out of the mdl_modules table
  5. Delete the certificate-specific rows out of the mdl_log_display table
  6. Install the new certificate module by visiting /admin
  7. Copy all the data from the old mdl_certificate and mdl_certificate_issues tables into the new, empty tables
  8. The install process deleted all the instances of the old certificate module from my courses, so at this point I copied the new tables from my dev site to my live site
  9. Copy the certificate folder into the mod folder on the live site
  10. Edit the mdl_modules table and set the certificate version to the new one in the mod/certificate folder
  11. Visit /admin to make sure no upgrade takes place

Basically, I bypassed the upgrade process. Now all my problems are fixed.

Thanks,
Zachary