My calendar items have all disappeared at once, myadmin: Can't open file: 'mdl_event.MYI'. (errno: 145)

David Russo - 2004年12月20日星期一 10:30

Strange issue. First I was trying to log into my moodle (admin) and I kept getting presented with the login page after submitting my login info. This happened on 2 computers, with 2 different logins.

Then after a little while, I was able to successfully login. I tried to add a site event to the calendar, and after submitting the event, the page response had cleared the entire calendar. There was a lot of info in there. If the data is indeed gone, is not clear.

I logged into PHPmyadmin to see what I could understand. Not knowing what records the calendar is in, I saw 'mdl_event' . On the structure TAB it says it's "in use" while all the other fields do not say that. I clicked on 'mdl_event' . The page says:

Database moodleDT - Table mdl_event running on localhost

Can't open file: 'mdl_event.MYI'. (errno: 145)

Error

SQL-query :

SHOW KEYS FROM `mdl_event`

MySQL said:

#1016 - Can't open file: 'mdl_event.MYI'. (errno: 145)

---------------------

Am I on the right track? This obviously is a problem. What should I do? Under the QUERY TAB, it says:

Error

SQL-query :

PMA_mysql_list_fields_alternate(

moodleDT, mdl_event

)

MySQL said:

#1016 - Can't open file: 'mdl_event.MYI'. (errno: 145)

----------------------

Any feedback appreciated, and many thanks in advance.

David Russo

Digital Theater

New College of California

http://digitaltheater.newcollege.edu/moodle

rupert@newcollege.edu

平均分： -

Re: My calendar items have all disappeared at once, myadmin: Can't open file: 'mdl_event.MYI'. (errno: 145)

Martin Dougiamas - 2004年12月20日星期一 10:33

No problem, you just need to REPAIR that table (and all the tables, just to be safe). Most likely you will have lost nothing.

The phpmyadmin interface lets you do that ... look under "Operations" to do just one table. For all the tables at once, look for menus under the list of all tables that you get when you click on the database name in the left frame.

平均分： -

Re: My calendar items have all disappeared at once, myadmin: Can't open file: 'mdl_event.MYI'. (errno: 145)

David Russo - 2004年12月20日星期一 10:58

The $cfg['PmaAbsoluteUri'] directive MUST be set in your configuration file!

I just noticed this in RED in myadmin. Dunno if it's new or not... I have just looked and can't find any reference or command to REPAIR. When I click the OPERATIONS tab, it says...

Can't open file: 'mdl_event.MYI'. (errno: 145)

Error

SQL-query :

SHOW COLUMNS FROM `mdl_event` FROM `moodleDT`

MySQL said:

#1016 - Can't open file: 'mdl_event.MYI'. (errno: 145)

平均分： -

Re: My calendar items have all disappeared at once, myadmin: Can't open file: 'mdl_event.MYI'. (errno: 145)

David Russo - 2004年12月20日星期一 11:11

Hi again,

I forgot to mention that we have also recently, last week, installed a second moodle, with a separate database on the same webserver, which uses vhosting. Could this have caused a problem? What issues must I be aware of in terms od MySQL processes and making sure both moodles operate properly?

Thanks for all your hard work.

-d

平均分： -

Re: My calendar items have all disappeared at once, myadmin: Can't open file: 'mdl_event.MYI'. (errno: 145)

David Russo - 2004年12月20日星期一 13:14

Update,

I logged into mysql from the prompt based on advice from here: http://www.karakas-online.de/forum/viewtopic.php?t=332

But the repair command didn't work right off the bat. I'm working on repairing it. Any tips would be helpful. Also, how did it happen? Could one moodle database be getting confused with another on the same server. The databases are in the same directory of /usr/local/mysql/var

thanks,

david

-----------------------

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Didn't find any fields in table 'mdl_event'
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4338 to server version: 4.0.20

平均分： -

FIXED IT Re: My calendar items have all disappeared at once, myadmin: Can't open file: 'mdl_event.MYI'. (errno: 145)

David Russo - 2004年12月20日星期一 15:43

SUCCESS! After using my eyes a little more, and downing a few Hefeweizens, I discovered a pulldown menu with a REPAIR option. I checkboxed the mdl_events table and chose repair, and vwalah.

What causes these corruptions? I'm still concerned about the recent addition of another moodle to our server and whether I've configured it properly.

thanks.

平均分： -

Re: FIXED IT Re: My calendar items have all disappeared at once, myadmin: Can't open file: 'mdl_event.MYI'. (errno: 145)

Martin Dougiamas - 2004年12月20日星期一 16:14

MySQL tables can be left in this state if MySQL is suddenly interrupted and not shutdown properly (machine was rebooted or switched off, say).

平均分： -

General help

My calendar items have all disappeared at once, myadmin: Can't open file: 'mdl_event.MYI'. (errno: 145)

My calendar items have all disappeared at once, myadmin: Can't open file: 'mdl_event.MYI'. (errno: 145)

Database moodleDT - Table mdl_event running on localhost

Can't open file: 'mdl_event.MYI'. (errno: 145)

Re: My calendar items have all disappeared at once, myadmin: Can't open file: 'mdl_event.MYI'. (errno: 145)

Re: My calendar items have all disappeared at once, myadmin: Can't open file: 'mdl_event.MYI'. (errno: 145)

Re: My calendar items have all disappeared at once, myadmin: Can't open file: 'mdl_event.MYI'. (errno: 145)

Re: My calendar items have all disappeared at once, myadmin: Can't open file: 'mdl_event.MYI'. (errno: 145)

FIXED IT Re: My calendar items have all disappeared at once, myadmin: Can't open file: 'mdl_event.MYI'. (errno: 145)

Re: FIXED IT Re: My calendar items have all disappeared at once, myadmin: Can't open file: 'mdl_event.MYI'. (errno: 145)

Empowering educators to improve our world

Moodle

Support

Get Involved

Contributions

Downloads

Tracker

Development

Empowering educators to improve our world