When I went to check on my Wiki this afternoon I was rather surprised to get
this error message --
A database error has occurred
Query: SELECT ug_group FROM `user_groups` WHERE ug_user = '1'
Error: 1017 Can't find file: 'user_groups.MYI' (errno: 2) (localhost)
$ perror 2
System error: 2 = No such file or directory
Either your filesystem is severely damaged or you have some other
problem with your database host. (A .MYI file is an index file for a
If you don't run the database server yourself, contact your system
adminstrator and ask them to check for MySQL problems.
As of this morning the Wiki was working fine and to
the best of my knowledge
nothing has been done to it today. The database appears to be fine, at least
as far as I can tell with a quick glance, as does localsettings and all the
rest, and I've reset the database users just in case (I use two to avoid
problems). Also, other aps I host that use MySQL are running just fine.
What have you tried on the database so far? Doing CHECK TABLES on all
your tables would probably be worthwhile if you haven't.
The most likely explanation for my woes is my host
something-or-other and lost/forgot/broke something (this "user_groups.MYI"
file?!?). In case that assumption is wrong and someone here might have a
clue I'm lacking, I figured I'd ask.
Definitely ask the host...
-- brion vibber (brion @ pobox.com