quote:

---

SQL Error : 1016 Can't open file: 'phpbb_users.MYI'. (errno: 145)

SELECT * FROM phpbb_users WHERE user_id = 2

Line : 62
File : /home/sakerive/.panel/web/bulletin/bb/includes/sessions.php

---

You were the last one in there, and now one of my databases is just GONE. Didn't you ever learn to put stuff back where you found it?

::sigh:: I have no idea how to fix this.
 

---

Posted by fugu13 (Member # 2859) on :
 
Your index is corrupted. You need to try 'repair table phpbb_users', and possibly mysqlisamchk. Another possibility is a file access problem, though that's unlikely (check the permissions on that .MYI file)

If the table is still gone after those (check phpmyadmin -- install it if you haven't yet),
your forums likely came with some sql code to populate the databases originally -- find that file, copy and paste the lines for that database into a new file, then inject that file into your database.
 

---

Posted by saxon75 (Member # 4589) on :
 
I fixed it. I had made a backup of the whole forum not too long before it crashed, but I didn't want to drop any posts that may have happened between the backup and the crash so I just cut-and-pasted in the SQL commands from the backup.

I haven't actually been able to locate the files for my databases, I do all my administration through my host's web control panel. fugu, are those SQL commands or are they shell commands?
 

---

Posted by saxon75 (Member # 4589) on :
 
Hmmm... Apparently the web client I use for database admin is phpMyAdmin (v. 2.4.0), but it sounds like you're talking about a shell application. Man, I wish my office firewall would let me connect in any way other than the web...
 

---

Posted by fugu13 (Member # 2859) on :
 
The first is an sql command, the second a shell command. Put a colon on the end of the sql command to run it.

I think phpmyadmin may be able to run the shell command, but I'm unsure and don't have easy access to an install right now.
 

---