Hi
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