Problem after installing patch 9

system · April 10, 2012, 3:57am

bigsicilian wrote on Tuesday, April 10, 2012:

I installed the latest XAMP install on Ubuntu. Everything seemed to be working fine but then I noticed I couldn’t update the facility in any way. Patients etc added just fine. I found patch nine here http://www.open-emr.org/wiki/index.php/OpenEMR_Patches and installed it as directed. The problem now is when I log in, I get under the procedures tab and error that says Error: query failed: select newcrop_user_role from users where usernam =‘admin’

Error: Unknown column ‘newcrop_user_role’ in fieldlist. I looked and indeed there is no column named that in the users table. Please help!

Thanks.

system · April 11, 2012, 7:36am

bradymiller wrote on Wednesday, April 11, 2012:

Hi,
What version of OpenEMR did you start with? It sounds like you were using version 4.0.0 and not 4.1.0 (I say this because the unable to update facility was a bug in 4.0.0 and the newcrop_user_role field was added in the 4.1.0 upgrade). If so, you’'ll need to upgrade to 4.1.0 and then run the patch again.
-brady
OpenEMR

system · April 12, 2012, 1:31am

bigsicilian wrote on Thursday, April 12, 2012:

Let me take a look. I’ll get back on this.