SQL ERROR

[bahiana]

hello , I have this problem

MySQL : Comando SQL:

 

CREATE TABLE IF NOT EXISTS `char` (
`char_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`char_num` TINYINT(1) NOT NULL DEFAULT '0',
`name` VARCHAR(30) NOT NULL DEFAULT '',
`class` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`base_level` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '1',
`job_level` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '1',
`base_exp` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
`job_exp` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
`zeny` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`str` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
`agi` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
`vit` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
`int` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
`dex` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
`luk` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
`max_hp` INT(9) UNSIGNED NOT NULL DEFAULT '0',
`hp` INT(9) UNSIGNED NOT NULL DEFAULT '0',
`max_sp` INT(9) UNSIGNED NOT NULL DEFAULT[...]

 

Mensagens do MySQL : 

#145 - Table '.\ragnarok\char' is marked as crashed and should be repaired

Edited February 5, 2016 by bahiana

[Secrets]

Run this MySQL query.

REPAIR TABLE char

or

REPAIR TABLE char USE_FRM

If all above fails, try ask around in Hercules forum

[Aureon]

This is the correct format for char table.

CREATE TABLE IF NOT EXISTS `char` (
  `char_id` int(11) unsigned NOT NULL auto_increment,
  `account_id` int(11) unsigned NOT NULL default '0',
  `char_num` tinyint(1) NOT NULL default '0',
  `name` varchar(30) NOT NULL DEFAULT '',
  `class` smallint(6) unsigned NOT NULL default '0',
  `base_level` smallint(6) unsigned NOT NULL default '1',
  `job_level` smallint(6) unsigned NOT NULL default '1',
  `base_exp` bigint(20) unsigned NOT NULL default '0',
  `job_exp` bigint(20) unsigned NOT NULL default '0',
  `zeny` int(11) unsigned NOT NULL default '0',
  `str` smallint(4) unsigned NOT NULL default '0',
  `agi` smallint(4) unsigned NOT NULL default '0',
  `vit` smallint(4) unsigned NOT NULL default '0',
  `int` smallint(4) unsigned NOT NULL default '0',
  `dex` smallint(4) unsigned NOT NULL default '0',
  `luk` smallint(4) unsigned NOT NULL default '0',
  `max_hp` mediumint(8) unsigned NOT NULL default '0',
  `hp` mediumint(8) unsigned NOT NULL default '0',
  `max_sp` mediumint(6) unsigned NOT NULL default '0',
  `sp` mediumint(6) unsigned NOT NULL default '0',
  `status_point` int(11) unsigned NOT NULL default '0',
  `skill_point` int(11) unsigned NOT NULL default '0',
  `option` int(11) NOT NULL default '0',
  `karma` tinyint(3) NOT NULL default '0',
  `manner` smallint(6) NOT NULL default '0',
  `party_id` int(11) unsigned NOT NULL default '0',
  `guild_id` int(11) unsigned NOT NULL default '0',
  `pet_id` int(11) unsigned NOT NULL default '0',
  `homun_id` int(11) unsigned NOT NULL default '0',
  `elemental_id` int(11) unsigned NOT NULL default '0',
  `hair` tinyint(4) unsigned NOT NULL default '0',
  `hair_color` smallint(5) unsigned NOT NULL default '0',
  `clothes_color` smallint(5) unsigned NOT NULL default '0',
  `weapon` smallint(6) unsigned NOT NULL default '0',
  `shield` smallint(6) unsigned NOT NULL default '0',
  `head_top` smallint(6) unsigned NOT NULL default '0',
  `head_mid` smallint(6) unsigned NOT NULL default '0',
  `head_bottom` smallint(6) unsigned NOT NULL default '0',
  `robe` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `last_map` varchar(11) NOT NULL default '',
  `last_x` smallint(4) unsigned NOT NULL default '53',
  `last_y` smallint(4) unsigned NOT NULL default '111',
  `save_map` varchar(11) NOT NULL default '',
  `save_x` smallint(4) unsigned NOT NULL default '53',
  `save_y` smallint(4) unsigned NOT NULL default '111',
  `partner_id` int(11) unsigned NOT NULL default '0',
  `online` tinyint(2) NOT NULL default '0',
  `father` int(11) unsigned NOT NULL default '0',
  `mother` int(11) unsigned NOT NULL default '0',
  `child` int(11) unsigned NOT NULL default '0',
  `fame` int(11) unsigned NOT NULL default '0',
  `rename` SMALLINT(3) unsigned NOT NULL default '0',
  `delete_date` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `moves` int(11) unsigned NOT NULL DEFAULT '0',
  `unban_time` int(11) unsigned NOT NULL default '0',
  `font` tinyint(3) unsigned NOT NULL default '0',
  `uniqueitem_counter` int(11) unsigned NOT NULL default '0',
  `sex` ENUM('M','F','U') NOT NULL default 'U',
  `hotkey_rowshift` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY  (`char_id`),
  UNIQUE KEY `name_key` (`name`),
  KEY `account_id` (`account_id`),
  KEY `party_id` (`party_id`),
  KEY `guild_id` (`guild_id`),
  KEY `online` (`online`)
) ENGINE=MyISAM AUTO_INCREMENT=150000;