Can't add patients

Management and Administration
1

mike1508 wrote on Friday, October 16, 2015:

I setup OpenEMR according to the manaual and I get an error when trying to add patients, anyone have any ideas?

2

visolveemr wrote on Friday, October 16, 2015:

Hello Michael

What error you get while adding the patient. You can also check your apache error log for more specific details and share here for the community to help you furthur.

Thanks
OpenEMR Customization/Support Team,
ViSolve Inc
services@visolve.com | Phone: 408-850-2243
Demo’s @ ViSolve Demo Library

3

fsgl wrote on Friday, October 16, 2015:

Something went wrong with the creation of the database if layout_options is missing.

If you are using a host, how was the database created?

4

mike1508 wrote on Friday, October 16, 2015:

I’m running MS server 2008 R2, using IIS and mySQL. I followed the install manual and everything seemed to go well. Can this be created manually? I’ve re-installed several time, every other time it failed, but I was trying to change the name of the database and login, I guess it didn’t like that because when I left the defaults, it installed perfectly. However I still get the error when adding patients. If it helps, when I try to add users, it says failure during database access. I think I’ve given the admin account all permission, not super familiar with mySQL/phpmyadmin.

http://www.open-emr.org/wiki/index.php/OpenEMR_4.2.0_Windows_Installation

5

fsgl wrote on Friday, October 16, 2015:

There are very few discussions about hosted installations with Windows & IIS; therefore not a lot of info available.

The easiest install would be the Package.

If it is not possible to install above Package, try to extrapolate from this guide to create the database instead of having OpenEMR Setup do it for you. You should have something similar to cPanel.

The present installation is worthless if there is no database access. So try to create the database yourself.

If all else fails, ask the host about manual database creation.

6

fsgl wrote on Friday, October 16, 2015:

Found this tutorial.

Only skimmed it.

7

yehster wrote on Friday, October 16, 2015:

From whatever tool you use to run SQL queries, try

SELECT @@GLOBAL.sql_mode;

If STRICT_TRANS_TABLES is included in the sql mode shown, that would explain the problem.

https://dev.mysql.com/doc/refman/5.5/en/sql-mode.html

OpenEMR requires disabling Strict Transactions, and the default option when installing MYSQL with the windows installer is enabled.

8

fsgl wrote on Friday, October 16, 2015:

Notable sentence from this webpage:

A WIMP stack is not designed for production environments because MySQL and IIS would compete for server resources.

Unable to locate any discussions about IIS troubleshooting, therefore the choice of the web server may be another potential roadblock.

Your host may have documentation on installing a WAMP stack. If not, here’s the AWS tutorial.

I’m not advocating using AWS for reason mentioned here; just using their guides for illustration purposes.

9

fsgl wrote on Friday, October 16, 2015:

If you wish to ignore the above quote , found this for the missing layout_options table.

That still leaves adding users.