Myria wrote:
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' Function: User::loadFromDatabase 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 MySQL table.)
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 upgraded 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)