[Bugs] Database

[kaio Santos 32]

Preciso muito resolver esses problemas rep+ para melhor resposta

 

 

Gesior

 

 

 

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1194 Table 'players' is marked as crashed and should be repaired' in C:\xampp\htdocs\latestnews.php:30 Stack trace: #0 C:\xampp\htdocs\latestnews.php(30): PDO->query('SELECT `players...') #1 C:\xampp\htdocs\index.php(63): include('C:\xampp\htdocs...') #2 {main} thrown inC:\xampp\htdocs\latestnews.php on line 30

 

 

Database (mysql)

 

 mysql_real_query(): SELECT `player_skills`.`value`, `players`.`name` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=6 AND `player_skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `player_skills`.`count` DESC LIMIT 15 - MYSQL ERROR: Unknown column 'player_skills.value' in 'field list' (1054)

 

 

mysql_real_query(): SELECT `maglevel`, `name` FROM `players` ORDER BY `maglevel` DESC, `manaspent` DESC LIMIT 15 - MYSQL ERROR: Table 'players' is marked as crashed and should be repaired (1194)

 

mysql_real_query(): SELECT `level`, `name` FROM `players` ORDER BY `level` DESC, `experience` DESC LIMIT 15 - MYSQL ERROR: Table 'players' is marked as crashed and should be repaired (1194)

Editado Março 4, 2013 por kaio Santos (veja o histórico de edições)

[kaio Santos 32]

@up

[Moose 45]

parece que conten algum nome com caracteres especiais que ta bugando sua tabela player, remove o nomes que tenha ' neles pra ver se resolve.