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)
Backtrace:
* GlobalFunctions.php line 451 calls wfbacktrace() * Database.php line 400 calls wfdebugdiebacktrace() * Database.php line 350 calls databasemysql::reportqueryerror() * Database.php line 726 calls databasemysql::query() * User.php line 693 calls databasemysql::select() * User.php line 623 calls user::loadfromdatabase() * Setup.php line 209 calls user::loadfromsession() * index.php line 63 calls require_once() ______________________________________
Note that going to the site without a cookie set gets you a different and less informative error (see http://wolfandturtle.net/Indigo).
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.
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.
Versions - Wiki -- 1.5rc4 (The Day of the Dead version) MySQL -- Ver 12.22 Distrib 4.0.16 (The Killer of Wikis version) PHP -- 4.3.8 (The I Wish I was Ruby on Rails version)
If anyone knows anything about this 'user_groups.MYI' and why it, or the lack thereof, might have caused my Wiki to join the digital dead, please let me know.
Myria