Docker Issue - missing fields and failed upgrade

rmagauran · January 8, 2019, 1:31pm

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 · January 9, 2019, 6:55am

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

rmagauran · January 9, 2019, 6:36pm

I used the docker instructions here:

github.com

openemr/openemr/blob/master/CONTRIBUTING.md

Thank you for your contribution. OpenEMR (and global healthcare) continues to get better because of people like you!

The maintainers of OpenEMR want to get your pull request in as seamlessly as possible, so please ensure your code is consistent with our [development policies](http://open-emr.org/wiki/index.php/Development_Policies).

## Code Contributions (local development)
You will need a "local" version of OpenEMR to make changes to the source code. The easiest way to do this is with [Docker](https://hub.docker.com/r/openemr/openemr/):

1. [Create your own fork of OpenEMR](https://github.com/openemr/openemr/fork) (you will need a GitHub account) and `git clone` it to your local machine.
    - It's best to also add an `upstream` origin to keep your local fork up to date. [Check out this guide](https://oneemptymind.wordpress.com/2018/07/11/keeping-a-fork-up-to-date/) for more info.
2. `cd openemr` (the directory you cloned the code into)
    - If you haven't already, [install Docker](https://docs.docker.com/install/) for your system
3. Edit `docker-compose.yml` to use your fork's git url and branch name for `FLEX_REPOSITORY` and `FLEX_REPOSITORY_BRANCH`
    - For example:
    ```
    FLEX_REPOSITORY: https://github.com/[my_user_name]/openemr.git
    FLEX_REPOSITORY_BRANCH: master
    ```
4. Run `docker-compose up` from your command line
    - When the build is done, you'll see the following message:
    ```

This file has been truncated. show original

which the yml points to:

And I opened https://localhost:9091/

brady.miller · January 10, 2019, 10:07am

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

rmagauran · January 10, 2019, 12:29pm

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

Same error this AM.

brady.miller · January 11, 2019, 8:47am

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