Database update script fails when upgrading with an exsting version

OpenEMR Development
1

I am currently working on an upgrade from an older 501 version to 703/4. I noticed that in the file database.sql creates tables like ‘immunizations.php’ has new columns that do not get created using the sql_upgrade.php script. I also am getting fatal errors as well that stops the upgrade. Is anyone currently working on a fix for this? If not, I am happy to take this on.

2

hi @growlingflea, do you have the error message or a screenshot from the upgrade output page please? It might offer more clues. Not seeing an issue with the demos running this statement in the 704 upgrade script:

#IfMissingColumn immunizations encounter_id
ALTER TABLE `immunizations` ADD COLUMN `encounter_id` BIGINT(20) DEFAULT NULL COMMENT 'fk to form_encounter.encounter to link immunization to encounter record';
#EndIf

Thanks!

3

I think I upgraded from an already existing instance using master. I should have used a tag.

1 Like