Docker Issue - missing fields and failed upgrade


(R Magauran) #1

I just opened a docker container on my mac. I noticed some database fields were not correct so I ran the sql_upgrade to get them up to the latest.

 OpenEMR Database Upgrade

Processing 5_0_1-to-5_0_2_upgrade.sql …
UPDATE background_services SET require_once=’/library/MedEx/MedEx_background.php’ WHERE name=‘MedEx’
Skipping section #IfNotTable form_eye_base
UPDATE list_options set notes={form_npi: {numericality: {onlyInteger: true}, NPI: {message:"NPI is not valid"}}} where list_id=page_validation and option_id=addrbook_edit#theform and notes={}
Query Error

ERROR: query failed: UPDATE list_options set notes={form_npi: {numericality: {onlyInteger: true}, NPI: {message:"NPI is not valid"}}} where list_id=page_validation and option_id=addrbook_edit#theform and notes={}

Error: Unknown column ‘page_validation’ in ‘where clause’

/var/www/localhost/htdocs/openemr/library/sql_upgrade_fx.php at 892:sqlStatement
/var/www/localhost/htdocs/openemr/sql_upgrade.php at 91:upgradeFromSqlFile(5_0_1-to-5_0_2_upgrade.sql)


(Brady Miller) #2

Hi @rmagauran ,
Which docker did you use?
thanks,
-brady


(R Magauran) #3

I used the docker instructions here:


which the yml points to:

And I opened https://localhost:9091/


(Brady Miller) #4

Hi @rmagauran ,

That is odd because port 9091 does not get setup in the docker-compose.yml file for that docker setup:
openemr/docker-compose.yml at master · openemr/openemr · GitHub

Did you modify that file. If so, what does it look like?

-brady


(R Magauran) #5

Checking my firefox logs the upgrade was done through port 8081
http://localhost:8081/sql_upgrade.php

Same error this AM.


(Brady Miller) #6

Hi @rmagauran ,

Still at a loss here (does not seem like you are using the docker from the contributing.md isntructions, since the port you are using is not the port that is set up in that docker-compose.yml):

-brady