Certificate Integer Errors

Certificate Integer Errors

by Ms. Letha Sanders -
Number of replies: 0

Hi,

I'm not sure what to do about this since I don't understand the error.

What should I do?  Thanks.  Ms. Letha

Wrong Integers Found: 2

Some wrong integers have been found in your DB. Here are their details and the needed SQL statements to be executed with your favourite SQL interface to create all them (don't forget to backup your data before doing that).

After doing that, it's highly recommended to execute this utility again to check that no more wrong integers are found.

  • Table: certificate. Field: datefmt
  • Table: certificate. Field: printoutcome

ALTER TABLE mdl_certificate MODIFY COLUMN datefmt BIGINT(10) unsigned NOT NULL DEFAULT 0 after printdate;
ALTER TABLE mdl_certificate MODIFY COLUMN printoutcome BIGINT(10) unsigned NOT NULL DEFAULT 0 after gradefmt;

Average of ratings: -