[Sadie Frost]

Originally Posted by Keyser S?ze

ok my site went down for a few hours, qwhen it came back up i was getting this error

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT * from user_troll WHERE userid = '2230' AND realip = '71.161.49.82' AND deleted = 0 AND fqdn = 0 ORDER BY timestamp DESC LIMIT 1;

MySQL Error : Can't open file: 'user_troll.MYI' (errno: 145)
Error Number : 1016
Date : Monday, January 15th 2007 @ 09:11:38 AM
Script : http://www.emuasylum.com/forums/index.php
Referrer :
IP Address : 71.161.49.82
Username : Ice
Classname : vb_database

any suggestions?

Try running a repair on your tables from the admincp. I know I've had those MYI errors before and I *think* that's what I did to fix them but you might just want to search on vb.com about it to be sure.

As for the whole user_troll file not existing error, I've been trying to help DannyBoy8406 with fixing this, and he too has a table prefix. So it looks like the hack is not calling the table prefix from the config file properly. Not sure how to fix it other than adding it manually. Anyone have any ideas?