OpenEMR 6.0 Billing Manager "date based queries" not working

Support
9

Hello All,

The upgrade ‘redo’ has the same issues as before …

I believe that the problem is that I am attempting to upgrade from 5.0.0, database version identifier ‘206’ and it is not playing nice with the current sql_upgrade.php … ?

It appears that the ‘keys’ table should be added by line 709 of 5_0_1-to-5_0_2_upgrade.sql

But I still get a bunch of errors

  • ERROR: query failed: SELECT value FROM keys WHERE name = ?

during the 5.0.0 to 5.0.1 sql upgrade … ?

So it appears that the current upgrade logic already anticipates my OpenEMR version to be 5.0.2 even though the process implies that I can upgrade from an earlier version …

So do I need to walk the upgrades … ?

  1. make a 5.0.1 installation
  2. upgrade from 5.0.0 to 5.0.1
  3. make a 5.0.2 installation
  4. upgrade from 5.0.1 to 5.0.2
  5. make a 6.0.0 installation
  6. upgrade from 5.0.2 to 6.0.0

Or is there a way to appropriately call the upgrade sql files sequentially outside of the OpenEMR installations … ?

Thanks for any guidance … : )

Tom Shepherd