PDA

View Full Version : MySQL errors that can't be repaired...


Pacman15
31 Aug 2006, 12:14
This tables are messed up.
vb1_rpg_alignments Check Error: Can't find file: 'vb1_rpg_alignments.MYI' (errno: 2)
vb1_rpg_battle Check Error: Can't find file: 'vb1_rpg_battle.MYI' (errno: 2)
vb1_rpg_battle_posts Check Error: Can't find file: 'vb1_rpg_battle_posts.MYI' (errno: 2)
vb1_rpg_battlemusic Check Error: Can't find file: 'vb1_rpg_battlemusic.MYI' (errno: 2)
vb1_rpg_categories Check Error: Can't find file: 'vb1_rpg_categories.MYI' (errno: 2)
vb1_rpg_clans Check Error: Can't find file: 'vb1_rpg_clans.MYI' (errno: 2)
vb1_rpg_classes Check Error: Can't find file: 'vb1_rpg_classes.MYI' (errno: 2)
vb1_rpg_elements Check Error: Can't find file: 'vb1_rpg_elements.MYI' (errno: 2)
vb1_rpg_genders Check Error: Can't find file: 'vb1_rpg_genders.MYI' (errno: 2)
vb1_rpg_ibot_templates Check Error: Can't find file: 'vb1_rpg_ibot_templates.MYI' (errno: 2)
vb1_rpg_ibots Check Error: Can't find file: 'vb1_rpg_ibots.MYI' (errno: 2)
vb1_rpg_items Check Error: Can't find file: 'vb1_rpg_items.MYI' (errno: 2)
vb1_rpg_lottery Check Error: Can't find file: 'vb1_rpg_lottery.MYI' (errno: 2)
vb1_rpg_lottery_tickets Check Error: Can't find file: 'vb1_rpg_lottery_tickets.MYI' (errno: 2)
vb1_rpg_monster_battle_posts Check Error: Can't find file: 'vb1_rpg_monster_battle_posts.MYI' (errno: 2)
vb1_rpg_monster_battles Check Error: Can't find file: 'vb1_rpg_monster_battles.MYI' (errno: 2)
vb1_rpg_races Check Error: Can't find file: 'vb1_rpg_races.MYI' (errno: 2)
vb1_rpg_scenes Check Error: Can't find file: 'vb1_rpg_scenes.MYI' (errno: 2)
vb1_rpg_types Check Error: Can't find file: 'vb1_rpg_types.MYI' (errno: 2)
vb1_rpg_user Check Error: Can't find file: 'vb1_rpg_user.MYI' (errno: 2)

Can anyone help me out? I got those errors because of that.
Invalid SQL:

SELECT `rpgname`, `battles`, `wins`, `losses`, `draws`, `retreats`
FROM `vb1_rpg_user` AS `rpg_user `
ORDER BY wins desc
LIMIT 10;

MySQL Error : Can't find file: 'vb1_rpg_user.MYI' (errno: 2)
Error Number : 1017
Invalid SQL:
UPDATE vb1_rpg_user SET
ap = 0,
maxhp = 243,
maxmp = 25,
maxpp = 25,
hp = 243,
mp = 25,
pp = 25,
xp = 8512,
level = 16
WHERE userid = 1;

MySQL Error : Can't find file: 'vb1_rpg_user.MYI' (errno: 2)
Error Number : 1017

And i won't check other RPG pages because I know they'll be messed up too...

Thanks.

Revan
01 Sep 2006, 07:25
Your MySQL files are corrupt. Talk to your host or reinstall the hack.