how to fix this guys?

[Ragnar Lothbrok]

when i run the server this error appears

and after selecting the character this error appear and

i cant connect to the server....

BUMP!

[michaelsoftman]

You are missing those fields from your SQL database.

Did you make some custom source edits? You have to update your databases.

[nanakiwurtz]

Yes, redownload the latest version from trunk SVN and recompile.

[eJay]

hmmm do you have insert npc script before ?

[Mystery]

Basically, the error is stating itself if you read closely to what is being said:

"Unknown column '......' in '........' ". I suggest you try to remember what source modifications you've done and any SQL adjustments. Basically, you have changes because rAthena doesn't support 'serial' in the Auction database:

CREATE TABLE IF NOT EXISTS `auction` (
 `auction_id` bigint(20) unsigned NOT NULL auto_increment,
 `seller_id` int(11) unsigned NOT NULL default '0',
 `seller_name` varchar(30) NOT NULL default '',
 `buyer_id` int(11) unsigned NOT NULL default '0',
 `buyer_name` varchar(30) NOT NULL default '',
 `price` int(11) unsigned NOT NULL default '0',
 `buynow` int(11) unsigned NOT NULL default '0',
 `hours` smallint(6) NOT NULL default '0',
 `timestamp` int(11) unsigned NOT NULL default '0',
 `nameid` int(11) unsigned NOT NULL default '0',
 `item_name` varchar(50) NOT NULL default '',
 `type` smallint(6) NOT NULL default '0',
 `refine` tinyint(3) unsigned NOT NULL default '0',
 `attribute` tinyint(4) unsigned NOT NULL default '0',
 `card0` smallint(11) NOT NULL default '0',
 `card1` smallint(11) NOT NULL default '0',
 `card2` smallint(11) NOT NULL default '0',
 `card3` smallint(11) NOT NULL default '0',
 PRIMARY KEY  (`auction_id`)
) ENGINE=MyISAM;

https://rathena.svn.sourceforge.net/svnroot/rathena/trunk/sql-files/main.sql

Nor play time. You probably have scripts that need those additional fields?

[Judas]

is that serial/playtime from eamod, or is this the script/src xanatria made

[nicoscene]

recompile your server files

[Muster Bait]

just redownload everything back