SORMAS-Project Files

This release fixes a bug in 1.47.0 that removed most symptoms and epi data from cases. Please execute the following code in your database to restore these relations:

DROP TABLE IF EXISTS t_cases;
DROP TABLE IF EXISTS t_cases_history;

CREATE temp table t_cases
AS SELECT c.id FROM cases c WHERE c.epidata_id IS NULL OR c.symptoms_id IS NULL;

CREATE temp table t_cases_history
AS SELECT DISTINCT ON(ch.id) ch.id, ch.epidata_id, ch.symptoms_id FROM cases_history ch, t_cases c WHERE ch.id = c.id AND ch.epidata_id IS NOT NULL AND ch.symptoms_id IS NOT NULL;

UPDATE cases SET symptoms_id = ch.symptoms_id, epidata_id = ch.epidata_id FROM t_cases_history ch WHERE ch.id = cases.id AND (cases.symptoms_id IS NULL OR cases.epidata_id IS NULL);

DROP TABLE IF EXISTS t_cases;
DROP TABLE IF EXISTS t_cases_history;

Changes

• Symptoms, epi data and health conditions are no longer reused when converting contacts to cases (#2735)

Bugfixes

• [Web] Fixed similarity detection not working as intended (#2764)
• [Web] Fixed creating cases at home not working (#2762)
• [App] Fixed some caption inconsistencies (#2765)
• [Web] Fixed detailed case export not working (#2763)
• [Web] Fixed accessing detailed case view not working (#2759)
• [Web] Fixed contact follow-up visits overview not colorizing cells properly on first open (#2781)