Open Dental Forum

hi everyone,

Is anybody have this problem before? When we try to enter a procedure it show the following message:

Error in query:
#23000Duplicate entry '11171' for key 1

INSERT INTO procedurelog (PatNum, AptNum, ADACode, ProcDate,ProcFee,Surf,ToothNum,ToothRange,Priority, ProcStatus, ProcNote, ProvNum,Dx,NextAptNum,PlaceService,HideGraphical,Prosthesis,DateOriginalProsth,ClaimNote,DateLocked,DateEntryC,ClinicNum,MedicalCode,DiagnosticCode,IsPrincDiag,LabFee) VALUES('354', '0', 'D2391', '2007-07-28', '140.00', 'O', '18', '', '0', '1', '', '1', '0', '0', '0', '0', '', '0001-01-01', '', '0001-01-01', NOW(), '0', '', '', '0', '0.00')

any comment will be appricated

Run database maintenance. Also, did you compile? Is your version of MySQL mismatched possibly? In other words, did you transfer the database from one computer to another? You might have a different version of MySQL on each computer. It works ok to move up a version, but not down a version.