Ragnar Lothbrok Posted October 23, 2012 Group: Members Topic Count: 91 Topics Per Day: 0.02 Content Count: 309 Reputation: 6 Joined: 04/24/12 Last Seen: January 7, 2016 Share Posted October 23, 2012 when i run the server this error appears and after selecting the character this error appear and i cant connect to the server.... BUMP! Quote Link to comment Share on other sites More sharing options...
michaelsoftman Posted October 23, 2012 Group: Members Topic Count: 48 Topics Per Day: 0.01 Content Count: 410 Reputation: 29 Joined: 04/04/12 Last Seen: August 5, 2021 Share Posted October 23, 2012 You are missing those fields from your SQL database. Did you make some custom source edits? You have to update your databases. Quote Link to comment Share on other sites More sharing options...
nanakiwurtz Posted October 23, 2012 Group: Members Topic Count: 81 Topics Per Day: 0.02 Content Count: 1654 Reputation: 583 Joined: 08/09/12 Last Seen: January 14, 2020 Share Posted October 23, 2012 Yes, redownload the latest version from trunk SVN and recompile. Quote Link to comment Share on other sites More sharing options...
eJay Posted October 24, 2012 Group: Members Topic Count: 80 Topics Per Day: 0.02 Content Count: 325 Reputation: 76 Joined: 03/22/12 Last Seen: August 5, 2019 Share Posted October 24, 2012 hmmm do you have insert npc script before ? Quote Link to comment Share on other sites More sharing options...
Mystery Posted October 24, 2012 Group: Members Topic Count: 94 Topics Per Day: 0.02 Content Count: 2192 Reputation: 252 Joined: 11/11/11 Last Seen: June 24, 2020 Share Posted October 24, 2012 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? Quote Link to comment Share on other sites More sharing options...
Judas Posted October 24, 2012 Group: Members Topic Count: 26 Topics Per Day: 0.01 Content Count: 2244 Reputation: 182 Joined: 11/19/11 Last Seen: April 14 Share Posted October 24, 2012 is that serial/playtime from eamod, or is this the script/src xanatria made Quote Link to comment Share on other sites More sharing options...
nicoscene Posted December 10, 2012 Group: Members Topic Count: 30 Topics Per Day: 0.01 Content Count: 154 Reputation: 6 Joined: 04/26/12 Last Seen: January 26, 2016 Share Posted December 10, 2012 recompile your server files Quote Link to comment Share on other sites More sharing options...
Muster Bait Posted December 10, 2012 Group: Members Topic Count: 0 Topics Per Day: 0 Content Count: 2 Reputation: 0 Joined: 12/10/12 Last Seen: June 9, 2013 Share Posted December 10, 2012 just redownload everything back Quote Link to comment Share on other sites More sharing options...
Question
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!
Link to comment
Share on other sites
7 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.