system
(system)
July 10, 2013, 2:51am
1
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?
Do I need to change 644 and 755 values?
Or should I check old version and new version folder by folder?
Or do a new install for version 4.1.1 and patch only if V4.1.1 is working properly?
system
(system)
July 10, 2013, 4:54am
2
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
system
(system)
July 10, 2013, 9:52am
3
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.
system
(system)
July 10, 2013, 9:59am
4
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