This morning I’ve been working OK with OpenEMR, but when I came after lunch and reset my computer I tried to get into OpenEMR and I got the following message and I can not get into de soft:
ERROR: insert failed: insert into log (date, event, user, groupname, comments) values (NOW(), ‘login’,‘admin’,‘Default’,‘success’) (Duplicate entry ‘458’ for key 1)
I have no idea what it does mean. Could you please help me?
Thanks
I am using:
- Windows XP
- OpenEMR 2.8.3
- XAMPP 1.4.16
Trying to solve it I made the following:
- I deleted the path "C:\Archivos de programa\xampp\htdocs\openemr" and all its files.
- I download again "openemr-2.8.3.zip"
- I unzip it and put it in "C:\Archivos de programa\xampp\htdocs\openemr"
- When it asked me "have setup create the database" or "I have already created the databases", I select the 2nd option
- I changed $webserver_root = "C:\\Archivos de programa\\xampp\\htdocs\\openemr" in “C:\Archivos de programa\xampp\htdocs\openemr\interface\globals.php”
Now OpenEMR works fine, but… I LOST MY DATABASES
It does not matter too much because it wasn’t a hard job my yesterday job, but be carfull not to do the same as me if you have all your patiens in the databases.
backup mysql database and your openemr installation before reinstalling openemr
install phpmyadmin from http://www.phpmyadmin.net/home_page/index.php so that you have access to the openemr database outside of openemr, just in case you cannot login to openemr, you can still have access to the database
above you probably did not need to reinstall openemr, looks like you had a problem with the log table in mysql. It might have been possible to troubleshoot that error message