PDA

View Full Version : Can't open file error


Loopz
10-23-2005, 07:25 AM
Been up and running for over a month and then today i got the error down below. I have only got 512 of memory in the server so we do lose the sql server on occasions but a quick reboot and we are back in business. I could reinstall the game but i dont want to lose the current state of play. any suggestions please


SELECT name,alive,location,sex,level,laston,loggedin,last ip,uniqueid FROM logd_accounts WHERE locked=0 AND loggedin=1 AND laston>'2005-10-23 06:21:50' ORDER BY level DESC
Can't open file: 'logd_accounts.MYI'. (errno: 145)
Call Stack:
1: db_query() called from /usr/www/virtual/loopz/www.loopzorbital.com/phpbb/games/lotgd/lib/pageparts.php on line 648
2: charstats() called from /usr/www/virtual/loopz/www.loopzorbital.com/phpbb/games/lotgd/lib/pageparts.php on line 112
3: page_footer() called from /usr/www/virtual/loopz/www.loopzorbital.com/phpbb/games/lotgd/referral.php on line 69

Sichae-Saracen
10-23-2005, 04:59 PM
Like I said on DP:
Run this SQL:
REPAIR TABLE `accounts`

Loopz
10-24-2005, 03:27 PM
Thanx. I posted this before DP because i had no response here :)