karimkkanji / kenyaemr-plus-issues

This is an External Issue Tracker for KenyaEMR Plus Issues Identified
Apache License 2.0
0 stars 0 forks source link

Processing a Drug at Pharmacy Queue brings the following error: #2

Closed karimkkanji closed 3 years ago

karimkkanji commented 3 years ago

https://gist.github.com/karimkkanji/9412e1c0ffd63de021280e68604843e7

karimkkanji commented 3 years ago

Solved 🥳

The following is missing from the database. https://github.com/uonafya/ehrhospitalcoreopenmrs/blob/master/api/src/main/resources/liquibase.xml#L495

In Mysql Console run the following:

USE openmrs;

DROP table inventory_store_drug_patient_detail;

CREATE TABLE IF NOT EXISTS `inventory_store_drug_patient_detail` (
            `id` int(11) NOT NULL AUTO_INCREMENT,
            `store_drug_patient_id` int(11) DEFAULT NULL,
            `transaction_detail_id` int(11) DEFAULT NULL,
            `issue_count` int(11) DEFAULT '0',
            `quantity` int(11) DEFAULT NULL,
            PRIMARY KEY (`id`)
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8;