error says: “ERROR: insert failed: insert into history_data set pid = ?, date = NOW()”
I have Snow Leopard (osx v 10.8.3) / PHP 5.3.15 / mySQL 5.6.11 / & oemr 4.1.1 (plus the 4.1.1. patch); everything is a new install in that order and I’ve restarted my apache server, restarted my mySQL, and restarted my computer!
Any insight on any of this would be helpful, as I’ve spent the whole day overcoming a whole bunch of issues already, and I’m stuck, still, on just trying to create users and not being able to do anything with them. I’m half-creating users that will show up if I search for them, but then I’m not able to use them for any scheduling, or anything else for that matter (everything in navigation associated with patients is greyed out).
message: “Your PHP MySQL library version mysqlnd 5.0.8-dev - 20102224 - $Id: 65fe78e70ce53d27a6cd578597722950e490b0d0 $ differs from your MySQL server version 5.6.11. This may cause unpredictable behavior.”
But, after perusing google’s results on this error, it appears it’s not something people find problematic.
I am able to serve OpenEMR on my Mac OS X computers, so I know that it is possible to do it successfully. However, I use MySQL 5.5. I did not think that MySQL 5.6 was ready for prime time. Is anyone else successfully serving OpenEMR with MySQL 5.6?
I know that a year ago, OpenEMR gave errors when using MySQL 5.5. It was due to MySQL 5.5 changing the syntax rules on a statement that OpenEMR was using. It was easy for me to fix. I just did a multi-file find and replace to change the syntax. A few months later, Rod contributed the fix so that this was not necessary. I’m not sure if this is the same case now. Was there more info in the error line? Or, were there errors in the SQL scripts used to create the databases?
Or, it could be directory permission related. I have found that in some screens I get a blank screen if permissions were not done correctly.
Honestly, I suggest that you install MySQL 5.5. Do you know enough about Unix to change the sockets in the php.ini and also to make sure that the version you want is running. It could be a little tricky.
I also strongly recommend using the package installer called MacPorts to install MySQL 5.5. It also allows you to easily install and update other unix software and dependencies. You can also use it to install ImageMagick, which is helpful in accessing certain openEMR features.
I hobble along on my own, but my husband, who is a software developer, and couldn’t figure out what was giving me problems upon quick look, can help w socket change, etc. From your post, I already have ideas. The mySQL 5.6 was touted a “stable build”, though most recent release. I’ll go and rollback — hopefully that will fix the problem of creating new patients (I can create some other things, so far). And to fix blank pages, I’ll look at permissions. I changed the ones openEMR told me to change during setup, but maybe there are more.
THIS IS AN APOLOGY TO OpenEMR DEVELOPERS: I realize now my error to post in “developers” when I should have posted in “users” or “help”. I also live with an openSource contributor (for SQLAlchemy) who spends 4 hours a day answering emails and wishing people would RTM.
I promise I have read everything that I can find, and have reinstalled everything I can, and it is still not working, although I lost half functionality of stuff that WAS working (i.e., calendar), and gained functionality that I didn’t have before (i.e., new patient input).
So’s not to bother any of you anymore, if one of you might be so kind as to tell me which forum I’d be more more suited to, I will repose my question elsewhere.
A blank calendar is almost always because the web server doesn’t have write permissions for
interface/main/calendar/modules/PostCalendar/pntemplates/compiled and
interface/main/calendar/modules/PostCalendar/pntemplates/cache
If that doesn’t seem to be the case. I recommend that you change your error_log settings as described: http://www.open-emr.org/wiki/index.php/FAQ#What_are_the_correct_PHP_settings_.28can_be_found_in_the_php.ini_file.29_.3F
then take a look in your apache error log for further pointers.
Thank you, Kevin. I had done chmod 666 on both directories, but have changed them to 777; the calendar is back! I also fixed date.timezone on php.ini, and added some parameters to the error_reporting. I’ll figure the rest out myself… still so many database errors.
Thanks, Brady!
After setting up locally myself, my husband is going to install openEMR remotely on a server that he will set up and maintain (& lockdown). He said if he comes across any glitches, he’ll fix/help out (& possibly contribute to the project). I’m an acupuncturist, and I haven’t explored options for non-md health-related users yet, but I might ask him to customize, possibly create some modules for me.
I do love the product, so far; it’s really impressiv!e (and by the way, the UI is fine by me. I like how simple & intuitive it is).
