General developer forum

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

 
Picture of Jerry Lau
Cannot clear up the list shown in: Look for inconsistent default values
 

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: -
C'est moi :-)
Re: Cannot clear up the list shown in: Look for inconsistent default values
Documentation writersParticularly helpful MoodlersTestersTranslators

Hi Jerry,

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

HTH,
Séverin

 
Average of ratings: Useful (1)
Picture of Jerry Lau
Re: Cannot clear up the list shown in: Look for inconsistent default values
 

Thank you!



 
Average of ratings: -