Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Failed schema checks in report_customsql_categories #123

Open
jnlar opened this issue Dec 21, 2022 · 0 comments
Open

Failed schema checks in report_customsql_categories #123

jnlar opened this issue Dec 21, 2022 · 0 comments

Comments

@jnlar
Copy link

jnlar commented Dec 21, 2022

This error is appearing in version '4.2 for Moodle 3.9+' when running admin/cli/check_database_schema.php

-------------------------------------------------------------------------------
report_customsql_categories
 * column 'name' should be NOT NULL (C)
 * column 'name' has default 'Miscellaneous', expected 'NULL' (C)
-------------------------------------------------------------------------------

At some point the name columns constraint has been changed to NULL leading to this error.
jnlar added a commit to catalyst/moodle-report_customsql that referenced this issue Dec 21, 2022
@jnlar
Fix moodleou#123: Fix schema issues in report_customsql_categories
9d2d735
@jnlar jnlar mentioned this issue Dec 21, 2022
Merged
jnlar added a commit to catalyst/moodle-report_customsql that referenced this issue Dec 22, 2022
@jnlar
Fix moodleou#123: Created new upgrade block
bacdd6a 
Only assess the updates needed instead of moving the original upgrade
block down.
jnlar added a commit to catalyst/moodle-report_customsql that referenced this issue Dec 22, 2022
@jnlar
Fix moodleou#123: Use xmldb editor template for upgrade block
4c24779
jnlar added a commit to catalyst/moodle-report_customsql that referenced this issue Dec 22, 2022
@jnlar
Fix moodleou#123: Fix schema issues in report_customsql_categories
882afea
keevan added a commit to catalyst/moodle-report_customsql that referenced this issue Dec 22, 2022
@keevan
Merge pull request #1 from catalyst/issue123-categories-schema
7b44f4a 
Fix moodleou#123: Fix schema issues in report_customsql_categories
@jnlar jnlar mentioned this issue Dec 22, 2022
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@jnlar