entery of procedure

[ez29]

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

[jordansparks]

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.