Reg: Error while login

Management and Administration
1

ahmed159 wrote on Wednesday, June 17, 2015:

Dear Team,

i am getting this error while login to the openemr, i am using open emr 4.2.0, windows server 2007.

please help me…

ERROR: insert failed: insert into log ( date, event, user, groupname, success, comments, crt_user, patient_id) values ( NOW(), ‘login’,‘admin’,‘Default’,‘1’,‘success: 192.168.1.1’,NULL,NULL)

Error: Duplicate entry ‘203845’ for key ‘PRIMARY’

C:\xampp\htdocs\openemr\library\log.inc at 16:sqlInsertClean_audit
C:\xampp\htdocs\openemr\library\authentication\login_operations.php at 116:newEvent(login,admin,Default,1,success: 192.168.1.1)
C:\xampp\htdocs\openemr\library\auth.inc at 50:validate_user_password(admin,Default)
C:\xampp\htdocs\openemr\interface\globals.php at 368:include_once(C:\xampp\htdocs\openemr\library\auth.inc)
C:\xampp\htdocs\openemr\interface\main\main_screen.php at 25:require_once(C:\xampp\htdocs\openemr\interface\globals.php)

2

fsgl wrote on Wednesday, June 17, 2015:

See this.

3

ahmed159 wrote on Wednesday, June 17, 2015:

THanks for the support fsgl,

I have been using this version 4.2.0 since jan 2015, its working fine i didn’t face any issues since 6 months. I had ups issue my server got restarted after that i am facing this issue.

Can you please point me where is the problem. My background is from Networking so its difficult for me to understand.

Login page is working fine after login i am facing this error.

4

mdsupport wrote on Thursday, June 18, 2015:

Looks like the auto increment counter for log table was corrupted during shutdown. You will need to access mysql database and enter :

CHECK TABLE log;

If it shows corruption, enter:

REPAIR TABLE log;

5

ahmed159 wrote on Friday, June 19, 2015:

Thanks for the support Md support, half of my problem resolved after repair the Table Log file.

After that i am facing different issue. Please advise me for the same i have attached the error pic along with this post.

Thanks once again for you support.

6

fsgl wrote on Friday, June 19, 2015:

Because more than 1 table has been corrupted, would suggest having CapMinds help. They are in Chennai.

7

mdsupport wrote on Saturday, June 20, 2015:

You should try running mysqlcheck and check all databases. This utility will perform minor repair when possible. Otherwise you will need to restore the database from your last backup.

8

ahmed159 wrote on Wednesday, June 24, 2015:

After Repair ar_session in Data Base every thing is working fine.

Thanks Md support, Really i was in deep trouble With your help i solved the problem.

Thanks once again Md support & Team.