Problems with database schema

[foxlapinou]

Hi,

I'm using Moodle 3.7.4 and Moodle 3.5.10, with latest Attestoodle version (1.8.3).
I've just checked the database schema (admin/cli/check_database_schema.php) and found errors related to Attestoodle plugin, only for Moodle 3.5.10 (strange for me) :

-------------------------------------------------------------------------------
tool_attestoodle_training
* column 'startdate' should be NOT NULL (I)
-------------------------------------------------------------------------------
tool_attestoodle_user_style
* column 'userid' should be NOT NULL (I)
* column 'trainingid' should be NOT NULL (I)
* column 'templateid' should be NOT NULL (I)
-------------------------------------------------------------------------------
tool_attestoodle_learner
* column 'userid' should be NOT NULL (I)
* column 'trainingid' should be NOT NULL (I)
* column 'categoryid' should be NOT NULL (I)
-------------------------------------------------------------------------------

Do you think there's a coherence problem between files db/upgrade.php and db/install.xml, that you should correct ?

Or is the problem only in my Moodle installation (because it's 3.5) ? And if it's the case, how to correct this?

Thanks in advance if you can provide information.
Séverin

[mleconte]

Hello
Thank you for your comments, I didn't know about this test.

I don't have a platform in 3.5, but I don't think it comes from the Moodle version.
I think on your Moodle 3.5 you installed attestoodle and upgraded it, so the definition of the new tables was given by upgrade.php rather than install.xml.

Whereas on your 3.8 you directly installed the last version that had natively these tables.

I'm going to modify the upgrade.php file even though it should not be used anymore.

After checking the indexes via xmldb, I see that the indexes refer to table names with prefix, I will also modify the install.xml

Yours sincerely.