What error how can fix it?

[031599450]

Hello!

I use sv rAthena 16965 but when i look map-sql i see the error.

What is this? and How can fix error and Debug?

Thank all read my topic and sorry if my bad english.

Edited November 29, 2012 by 031599450

[Brian]

There is a SQL query that goes with that script.

/raijero/trunk/sql-files/main2.sql

-- Add columns to table `char`
ALTER TABLE `char` 
ADD `secs_online` INT(11) UNSIGNED NOT NULL DEFAULT '0';

Connect to your MySQL Server and execute that query.

Then the "Unknown column" SQL error will stop.

[Emistry]

in official sql char table...we dont have this column

secs_online

refer here

trunk/sql-files/main.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',
 `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',
 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 `name` (`name`),
 KEY `online` (`online`)
) ENGINE=MyISAM AUTO_INCREMENT=150000;

so it must be your custom script that you add recently / any changes in SQL table with script that caused this..

double check what you have add recently....