Can't open file: 'notes.MYI'

**tgra** · 2006-12-10, 10:55 AM

Runing trixbox, with latest patches for SugarCRM.

Everything have worked fine for months, but today when people should check there e-mails. They got this error in the inbox:

Error filling in additional list fields: Query Failed:select 1 from notes where notes.parent_id = '682995e3-77d7-8f1e-16f7-457bf0c18f11' and notes.deleted = 0::MySQL error 1016: Can't open file: 'notes.MYI' (errno: 145)

When I open PhpMyAdmin it says that it can not open the table 'notes' in the sugarcrm database. What can I do to fix this error?

I get this error in PMA:

SHOW INDEX FROM `notes` ;

MySQL sa: Dokumentasjon
#1016 - Can't open file: 'notes.MYI' (errno: 145)

Thomas..

**ruchida** · 2006-12-10, 12:04 PM

Hi,

Your tables may be corrupted. There are some documentation about ways to check or repair tables below.
http://dev.mysql.com/doc/refman/5.0/...am-tables.html

**tgra** · 2006-12-10, 03:31 PM

It is not possible to repair this table. The error messages says that it can not open the file: notes.myi. Is there anyway to rebuild the table: notes?

Thomas..

**kbrill** · 2006-12-10, 03:47 PM

Originally Posted by tgra

It is not possible to repair this table. The error messages says that it can not open the file: notes.myi. Is there anyway to rebuild the table: notes?

Thomas..

First find out why it cant read the file. Is it not there, is it there but currupt, are the permissions or owners screwed up on it. if it is there then just rename it something else (like notes.tmp) and run a 'REPAIR TABLE notes USE_FRM;'. It's been a real long time since I had to deal with a currupt index file but I thnk this works.

**tgra** · 2006-12-10, 04:49 PM

Thank you for your quick answer.

Where should i look to find the file?

Thomas,

**kbrill** · 2006-12-10, 04:52 PM

Originally Posted by tgra

Thank you for your quick answer.

Where should i look to find the file?

Thomas,

In Linux use the command 'find / | grep notes.myi' in windows just use the search command.

**tgra** · 2006-12-10, 06:01 PM

I am using Linux so I used th command: find / | grep notes.mui. It did not return anything.

I then deleted the notes table and replaced it with an old backup. The e-mails is back, but I do not know how much I lost and what is stored in the notes table? It seemed like the notes table stored information about attachement? Does that mean that I have all the e-mails but may have lost some attachements?

Thank you all for your participation!

Thomas..

**kbrill** · 2006-12-10, 06:17 PM

Originally Posted by tgra

I am using Linux so I used th command: find / | grep notes.mui. It did not return anything.

I then deleted the notes table and replaced it with an old backup. The e-mails is back, but I do not know how much I lost and what is stored in the notes table? It seemed like the notes table stored information about attachement? Does that mean that I have all the e-mails but may have lost some attachements?

Thank you all for your participation!

Thomas..

that I am note sure of, I don't use the email module so I have no idea what it stores where. Wish I could have helped more. You are going to make some 'new' backups now tho right? If you need a script I can send you one.

**tgra** · 2006-12-11, 09:22 AM

Hello!

It all works now! I used your command: 'REPAIR TABLE notes USE_FRM;' The file was there but it did not pu MYI in capital letters in the search. I then deleted the old notes.MYI and logged on to the console in MYSQL and runned the repair command.

It now works again!!!

Thank you very much!

Thomas..