# Problem after installing patch 9

**URL:** <https://community.open-emr.org/t/problem-after-installing-patch-9/5444>\
**Category:** OpenEMR Development\
**Created:** [April 10, 2012, 3:57am UTC](https://community.open-emr.org/t/problem-after-installing-patch-9/5444 "2012-04-10T03:57:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [April 10, 2012, 3:57am UTC](https://community.open-emr.org/t/problem-after-installing-patch-9/5444/1 "2012-04-10T03:57:33Z")

</div>

**[bigsicilian](https://sourceforge.net/u/bigsicilian/)** wrote on [Tuesday, April 10, 2012](https://sourceforge.net/p/openemr/discussion/202506/thread/387e6941/#fb2b):

I installed the latest XAMP install on Ubuntu.&nbsp; Everything seemed to be working fine but then I noticed I couldn’t update the facility in any way.&nbsp; Patients etc added just fine.&nbsp; I found patch nine here [http://www.open-emr.org/wiki/index.php/OpenEMR\_Patches](http://www.open-emr.org/wiki/index.php/OpenEMR_Patches)&nbsp; and installed it as directed.&nbsp; 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.&nbsp; I looked and indeed there is no column named that in the users table.&nbsp; Please help!

Thanks.

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [April 11, 2012, 7:36am UTC](https://community.open-emr.org/t/problem-after-installing-patch-9/5444/2 "2012-04-11T07:36:47Z")

</div>

**[bradymiller](https://sourceforge.net/u/bradymiller/)** wrote on [Wednesday, April 11, 2012](https://sourceforge.net/p/openemr/discussion/202506/thread/387e6941/#1640):

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](http://www.open-emr.org/)

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [April 12, 2012, 1:31am UTC](https://community.open-emr.org/t/problem-after-installing-patch-9/5444/3 "2012-04-12T01:31:07Z")

</div>

**[bigsicilian](https://sourceforge.net/u/bigsicilian/)** wrote on [Thursday, April 12, 2012](https://sourceforge.net/p/openemr/discussion/202506/thread/387e6941/#8fef):

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