Hoi
Bij de XMLDB editor krijg ik deze meldingen, de overige test zijn goed en geven geen meldingen.
Heb de SQL script al uitgevoerd maar blijf deze meldingen krijgen?
GR Bas
Er zijn inconsistenties gevonden in je databank. Hier zijn de juiste standaardwaarden en de nodige SQL-expressies om uit te voeren in je favoriete SQL-interface om ze allemaal te herstellen
- Tabel: question. Veld: defaultmark, Verwacht '1' Actual '1.0000000'
- Tabel: question_answers. Veld: fraction, Verwacht '0' Actual '0.0000000'
- Tabel: question_attempts. Veld: maxfraction, Verwacht '1' Actual '1.0000000'
- Tabel: grade_items. Veld: grademax, Verwacht '100' Actual '100.00000'
- Tabel: grade_items. Veld: grademin, Verwacht '0' Actual '0.00000'
- Tabel: grade_items. Veld: gradepass, Verwacht '0' Actual '0.00000'
- Tabel: grade_items. Veld: multfactor, Verwacht '1.0' Actual '1.00000'
- Tabel: grade_items. Veld: plusfactor, Verwacht '0' Actual '0.00000'
- Tabel: grade_items. Veld: aggregationcoef, Verwacht '0' Actual '0.00000'
- Tabel: grade_items. Veld: aggregationcoef2, Verwacht '0' Actual '0.00000'
- Tabel: grade_grades. Veld: rawgrademax, Verwacht '100' Actual '100.00000'
- Tabel: grade_grades. Veld: rawgrademin, Verwacht '0' Actual '0.00000'
- Tabel: grade_items_history. Veld: grademax, Verwacht '100' Actual '100.00000'
- Tabel: grade_items_history. Veld: grademin, Verwacht '0' Actual '0.00000'
- Tabel: grade_items_history. Veld: gradepass, Verwacht '0' Actual '0.00000'
- Tabel: grade_items_history. Veld: multfactor, Verwacht '1.0' Actual '1.00000'
- Tabel: grade_items_history. Veld: plusfactor, Verwacht '0' Actual '0.00000'
- Tabel: grade_items_history. Veld: aggregationcoef, Verwacht '0' Actual '0.00000'
- Tabel: grade_items_history. Veld: aggregationcoef2, Verwacht '0' Actual '0.00000'
- Tabel: grade_grades_history. Veld: rawgrademax, Verwacht '100' Actual '100.00000'
- Tabel: grade_grades_history. Veld: rawgrademin, Verwacht '0' Actual '0.00000'
- Tabel: backup_controllers. Veld: progress, Verwacht '0' Actual '0.00000000000000'
- Tabel: analytics_models_log. Veld: score, Verwacht '0' Actual '0.00000'
- Tabel: assign_grades. Veld: grade, Verwacht '0' Actual '0.00000'
- Tabel: quiz. Veld: sumgrades, Verwacht '0' Actual '0.00000'
- Tabel: quiz. Veld: grade, Verwacht '0' Actual '0.00000'
- Tabel: quiz_slots. Veld: maxmark, Verwacht '0' Actual '0.0000000'
- Tabel: quiz_feedback. Veld: mingrade, Verwacht '0' Actual '0.00000'
- Tabel: quiz_feedback. Veld: maxgrade, Verwacht '0' Actual '0.00000'
- Tabel: quiz_grades. Veld: grade, Verwacht '0' Actual '0.00000'
- Tabel: workshop. Veld: grade, Verwacht '80' Actual '80.00000'
- Tabel: workshop. Veld: gradinggrade, Verwacht '20' Actual '20.00000'
- Tabel: question_numerical_options. Veld: unitpenalty, Verwacht '0.1' Actual '0.1000000'
- Tabel: question_numerical_units. Veld: multiplier, Verwacht '1.00000000000000000000' Actual '1.0000000000000000000'
ALTER TABLE mdl_question MODIFY COLUMN defaultmark NUMERIC(12,7) NOT NULL DEFAULT 1 after generalfeedbackformat;
ALTER TABLE mdl_question_answers MODIFY COLUMN fraction NUMERIC(12,7) NOT NULL DEFAULT 0 after answerformat;
ALTER TABLE mdl_question_attempts MODIFY COLUMN maxfraction NUMERIC(12,7) NOT NULL DEFAULT 1 after minfraction;
ALTER TABLE mdl_grade_items MODIFY COLUMN grademax NUMERIC(10,5) NOT NULL DEFAULT 100 after gradetype;
ALTER TABLE mdl_grade_items MODIFY COLUMN grademin NUMERIC(10,5) NOT NULL DEFAULT 0 after grademax;
ALTER TABLE mdl_grade_items MODIFY COLUMN gradepass NUMERIC(10,5) NOT NULL DEFAULT 0 after outcomeid;
ALTER TABLE mdl_grade_items MODIFY COLUMN multfactor NUMERIC(10,5) NOT NULL DEFAULT 1.0 after gradepass;
ALTER TABLE mdl_grade_items MODIFY COLUMN plusfactor NUMERIC(10,5) NOT NULL DEFAULT 0 after multfactor;
ALTER TABLE mdl_grade_items MODIFY COLUMN aggregationcoef NUMERIC(10,5) NOT NULL DEFAULT 0 after plusfactor;
ALTER TABLE mdl_grade_items MODIFY COLUMN aggregationcoef2 NUMERIC(10,5) NOT NULL DEFAULT 0 after aggregationcoef;
ALTER TABLE mdl_grade_grades MODIFY COLUMN rawgrademax NUMERIC(10,5) NOT NULL DEFAULT 100 after rawgrade;
ALTER TABLE mdl_grade_grades MODIFY COLUMN rawgrademin NUMERIC(10,5) NOT NULL DEFAULT 0 after rawgrademax;
ALTER TABLE mdl_grade_items_history MODIFY COLUMN grademax NUMERIC(10,5) NOT NULL DEFAULT 100 after gradetype;
ALTER TABLE mdl_grade_items_history MODIFY COLUMN grademin NUMERIC(10,5) NOT NULL DEFAULT 0 after grademax;
ALTER TABLE mdl_grade_items_history MODIFY COLUMN gradepass NUMERIC(10,5) NOT NULL DEFAULT 0 after outcomeid;
ALTER TABLE mdl_grade_items_history MODIFY COLUMN multfactor NUMERIC(10,5) NOT NULL DEFAULT 1.0 after gradepass;
ALTER TABLE mdl_grade_items_history MODIFY COLUMN plusfactor NUMERIC(10,5) NOT NULL DEFAULT 0 after multfactor;
ALTER TABLE mdl_grade_items_history MODIFY COLUMN aggregationcoef NUMERIC(10,5) NOT NULL DEFAULT 0 after plusfactor;
ALTER TABLE mdl_grade_items_history MODIFY COLUMN aggregationcoef2 NUMERIC(10,5) NOT NULL DEFAULT 0 after aggregationcoef;
ALTER TABLE mdl_grade_grades_history MODIFY COLUMN rawgrademax NUMERIC(10,5) NOT NULL DEFAULT 100 after rawgrade;
ALTER TABLE mdl_grade_grades_history MODIFY COLUMN rawgrademin NUMERIC(10,5) NOT NULL DEFAULT 0 after rawgrademax;
ALTER TABLE mdl_backup_controllers MODIFY COLUMN progress NUMERIC(15,14) NOT NULL DEFAULT 0 after timemodified;
ALTER TABLE mdl_analytics_models_log MODIFY COLUMN score NUMERIC(10,5) NOT NULL DEFAULT 0 after timesplitting;
ALTER TABLE mdl_assign_grades MODIFY COLUMN grade NUMERIC(10,5) NULL DEFAULT 0 after grader;
ALTER TABLE mdl_quiz MODIFY COLUMN sumgrades NUMERIC(10,5) NOT NULL DEFAULT 0 after shuffleanswers;
ALTER TABLE mdl_quiz MODIFY COLUMN grade NUMERIC(10,5) NOT NULL DEFAULT 0 after sumgrades;
ALTER TABLE mdl_quiz_slots MODIFY COLUMN maxmark NUMERIC(12,7) NOT NULL DEFAULT 0 after includingsubcategories;
ALTER TABLE mdl_quiz_feedback MODIFY COLUMN mingrade NUMERIC(10,5) NOT NULL DEFAULT 0 after feedbacktextformat;
ALTER TABLE mdl_quiz_feedback MODIFY COLUMN maxgrade NUMERIC(10,5) NOT NULL DEFAULT 0 after mingrade;
ALTER TABLE mdl_quiz_grades MODIFY COLUMN grade NUMERIC(10,5) NOT NULL DEFAULT 0 after userid;
ALTER TABLE mdl_workshop MODIFY COLUMN grade NUMERIC(10,5) NULL DEFAULT 80 after useselfassessment;
ALTER TABLE mdl_workshop MODIFY COLUMN gradinggrade NUMERIC(10,5) NULL DEFAULT 20 after grade;
ALTER TABLE mdl_question_numerical_options MODIFY COLUMN unitpenalty NUMERIC(12,7) NOT NULL DEFAULT 0.1 after unitgradingtype;
ALTER TABLE mdl_question_numerical_units MODIFY COLUMN multiplier NUMERIC(38,19) NOT NULL DEFAULT 1.00000000000000000000 after question;