Login error

uctopuk wrote on Wednesday, September 28, 2011:

I am getting the following error when any user attempts to log into OpenEMR.

"ERROR: insert failed: insert into log ( date, event, user, groupname, success, comments, crt_user) values ( NOW(), ‘login’,’’,‘Default’,‘0’,‘failure: ::1. user not in any phpGACL groups. (bad username?)’,’’)

Error: Duplicate entry ‘5891’ for key ‘PRIMARY’"

Platform details:
Linux OpenSuse 11.2
OpenEMR 4.0.0

Context:
I was using grep to find a directory in a /var sub-directory. My OS froze and had to be rebooted. After the reboot the login errors began.

Any suggestions on how to fix this?

bradymiller wrote on Thursday, September 29, 2011:

Hi,

Suggest checking for mysql database corruption using mysqlcheck command(note this command can also fix the database). Here’s a tutorial:
http://beginlinux.com/blog/2009/12/maintaining-mysql-databases/

hope this helps get you started,
-brady

uctopuk wrote on Thursday, September 29, 2011:

Hi Brady,

Thanks a million! That did the trick.