Incorrect key file for table- Error

For users or potential users.
Post Reply
alhalwachi
Posts: 74
Joined: Fri Apr 02, 2010 2:26 pm

Incorrect key file for table- Error

Post by alhalwachi » Sat Aug 20, 2011 11:17 pm

Dear All

I am getting the "Incorrect key file for table '.\opendental\procnote.MYI'; try to repair it" when trying to open the chart of certain patients and not all, any ideas why?

alhalwachi
Posts: 74
Joined: Fri Apr 02, 2010 2:26 pm

Re: Incorrect key file for table- Error

Post by alhalwachi » Sun Aug 21, 2011 1:43 pm

I used the Tools-Database mauntainance , checked DB and fixed the table.
I'm replying to keep a good reference for others :p

drpav
Posts: 24
Joined: Sun Aug 01, 2010 9:24 pm

Re: Incorrect key file for table- Error

Post by drpav » Fri Nov 11, 2011 11:02 am

I am getting the "incorrect key file for table 'patient' try to repair it" message when I am trying to convert my ver 6 database to ver 7.9. It then stops the conversion. I have used database maintenance on it, but it still gets this error. When it says try to repair it, what else should I be doing to repair it other than database maintenance?

Thanks!

User avatar
jordansparks
Site Admin
Posts: 5739
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Incorrect key file for table- Error

Post by jordansparks » Fri Nov 11, 2011 12:55 pm

One cause of this might be if you made an incomplete backup and then restored it. Did you do anything like that?

Have you installed dot net 4.0?
Jordan Sparks, DMD
http://www.opendental.com

drpav
Posts: 24
Joined: Sun Aug 01, 2010 9:24 pm

Re: Incorrect key file for table- Error

Post by drpav » Fri Nov 11, 2011 3:08 pm

I am not even sure what an incomplete backup is.... I think all backups were done from inside Open Dental. Is there a way to tell?

I do have .net 4.0

User avatar
jordansparks
Site Admin
Posts: 5739
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Incorrect key file for table- Error

Post by jordansparks » Fri Nov 11, 2011 4:02 pm

It sounds like it's time to get us involved in this. We would usually first look at your my.ini file
http://www.opendental.com/manual/myini.html
Then, we would get a copy of your database and analyze it on our end. We would try upgrading the database to a newer version of OD to see what your error message looks like. If you're able to not use OD while we work, then we could probably get the converted database back to you as 7.9, and away you go.
Jordan Sparks, DMD
http://www.opendental.com

Post Reply