Upograde 4.0.1 to 4.1.1 with patch 13

blankev wrote on Wednesday, July 10, 2013:

Following instructions to the letter for Linux versions on WebserverHosting, I am stuck within the first screen, only showing in the left panel menu:

Top Bot

Calendar
Messages
Patient/Client
    Patients
    New/Search
    Summary
    Visits
        Create Visit
        Current
        Visit History
    Records
Fees
Inventory
Procedures

ERROR: query failed: select newcrop_user_role from users where username='admin'

Error: Unknown column 'newcrop_user_role' in 'field list'

The menu stops and I can’t go to administration etc. Version 4.0.1 was running as can be expected from OpenEMR. What could have gone wrong?

  1. Do I need to change 644 and 755 values?
  2. Or should I check old version and new version folder by folder?
  3. Or do a new install for version 4.1.1 and patch only if V4.1.1 is working properly?

tmccormi wrote on Wednesday, July 10, 2013:

Looks like you have not run sql_patch.php scripts or that field would have been added to the tables.

The instructions 4.0.0 to 4.1.0 don’t mention that as it’s part of “patching” not base release…

–Tony

blankev wrote on Wednesday, July 10, 2013:

I did the patch and did run sql_patch.php for V1.1 patch 13 and the green screen tells me everything is done. But have still the same “half” menu screen as mentioned above.

blankev wrote on Wednesday, July 10, 2013:

Following other trial and error approach solved the problem.

Upgrade sql_upgrade.php for version V.1.0 to V1.1
Run again sql_patch.php

Tnx for hinting, as always in debt for the quick response!

The menu is complete, now see if it’s working as expected.

Pimm