Cannot clear up the list shown in: Look for inconsistent default values

Cannot clear up the list shown in: Look for inconsistent default values

by Jerry Lau -
Number of replies: 2

Running on RHEL 7.1, PHP 7.18, Moodle 3.4.7+ and MySQL 5.7.21-community

So I ran the "Look for inconsistent default values" and it originally came up with 55 records so I followed the instructions as shown to ALTER tables.

Then I reran it and now it shows only 33 but it's the same 33 that was on the list. As a test, I ran one alter table statement again but it never seemed to be cleared off the list and shows up again

Here is an example:

mysql> ALTER TABLE mdl_question MODIFY COLUMN defaultmark NUMERIC(12,7) NOT NULL DEFAULT 1 after generalfeedbackformat;
Query OK, 0 rows affected (0.02 sec)
Records: 0  Duplicates: 0  Warnings: 0

Is it because there are no rows affected?

How can I fix this list?

thank you



Average of ratings: -
In reply to Jerry Lau

Re: Cannot clear up the list shown in: Look for inconsistent default values

by Séverin Terrier -
Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Testers Picture of Translators

Hi Jerry,

I think you should look (and vote/comment) at MDL-63252 !

HTH,
Séverin

Average of ratings: Useful (1)
In reply to Séverin Terrier

Re: Cannot clear up the list shown in: Look for inconsistent default values

by Jerry Lau -

Thank you!



Average of ratings: -