SQL Debug

[Hatake Kakashi]

sir, please help how to fix this problem? thanks...

[Emistry]

make sure you loaded the robe db 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` 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',
 `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',
 PRIMARY KEY  (`char_id`),
 KEY `account_id` (`account_id`),
 KEY `party_id` (`party_id`),
 KEY `guild_id` (`guild_id`),
 KEY `name` (`name`),
 KEY `online` (`online`)
) ENGINE=MyISAM AUTO_INCREMENT=150000; 

right after the head_bottom column

  `robe` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',

[Brian]

sir, please help how to fix this problem? thanks...

http://i42.tinypic.com/3535yx4.jpg

It looks like you missed this SQL Upgrade file:

../sql-files/upgrade_svn14797.sql

ALTER TABLE `char` ADD `robe` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0' AFTER `head_bottom`;

[Hatake Kakashi]

@brian

in your solution? this script i will execute it on my sql?

ALTER TABLE `char` ADD `robe` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0' AFTER `head_bottom`;

[Emistry]

yes

[Asura]

Hi Hatake Kakashi,

I would recommend running the other SQL upgrades as well, starting from 14797 as Brian had stated to the most recently available.