Game server crashing since update

[Dragol]

I updated my server tonight doing a pull and now two weird things are happening. The first is I can't login to any new character I create. They show up in the mog house, and then the game server crashes right after. Second, is none of my characters before the update show up on character select. I backed up the databases, and put it all back in after updating. They show up in navicat, just not when I go to the character select screen. The account ids match up on the char and account table, and when I do make that new character they are added to the chars table with the other characters and just they show up. Can't login to them though.

Any thoughts? Thanks in advance.

[Delaide]

Please help provide logs.

[kjLotus]

you probably need to update your char tables

[Dragol]

I've been getting that invalid key thing that usually happens when you create a character almost everytime I try to log in as well. I feel like I messed something up when I restored character tables. I put some stuff from the logs that wasn't normal below. When you mean update char tables do you mean running that batch file to implement them after updating server? I did that first, but after my characters didn't show up I tried executing the sql dump files in navicat. All the data is in the tables in navicat, just doesn't show up in the game.

Thanks!

Edit:

My search server also throws errors when I do /sea in game.

Throws this: Name: (null) Job: 0 Lvls: 0~0
DB error: - Column 'mlvl' in field list is ambiguous

Code: Select all

[23:52:13][1;35m[SQL][0m DB error - Unknown column 'campaign_allegiance' in 'field list'
[23:52:13][1;35m[SQL][0m Query: SELECT charname,pos_zone,pos_prevzone,pos_rot,pos_x,pos_y,pos_z,boundary,home_zone,home_rot,home_x,home_y,home_z,nation,quests,keyitems,spells,abilities,titles,zones,missions,assault,campaign,playtime,isnewplayer,campaign_allegiance FROM chars WHERE charid = 21832
[23:52:13][1;37m[Info][0m parse: 00A | 0001 0000 2E from user: 
[23:52:13][1;36m[Debug][0m [1;36mCZone:: Residential_Area IncreaseZoneCounter <1>  
[0m[23:52:13][1;37m[Info][0m parse: 011 | 0002 0001 04 from user: 
[23:52:15][1;37m[Info][0m parse: 0DB | 0003 0002 14 from user: 
[23:52:15][1;37m[Info][0m parse: 00C | 0003 0002 06 from user: 
[23:52:15][1;37m[Info][0m parse: 061 | 0003 0002 02 from user: 
[23:52:15][1;37m[Info][0m parse: 118 | 0003 0002 04 from user: 
[23:52:15][1;33m[Warning][0m [1;33mparse: Unhandled game packet 118 from user: 
[0m[23:52:15][1;37m[Info][0m parse: 053 | 0003 0002 44 from user: 
[23:52:15][1;33m[Warning][0m [1;33mparse: Unhandled game packet 053 from user: 
[0m[23:52:15][1;37m[Info][0m parse: 04B | 0003 0002 0C from user: 
[23:52:15][1;37m[Info][0m parse: 0E0 | 0003 0002 4C from user: 
[23:52:15][1;37m[Info][0m parse: 00F | 0003 0002 12 from user: 
[23:52:15][1;37m[Info][0m parse: 112 | 0003 0002 04 from user: 
[23:52:15][1;36m[Debug][0m [1;36mparse: SmallPacket is not implemented Type<112>
[0m[23:52:15][1;37m[Info][0m parse: 05A | 0003 0002 02 from user: 

Code: Select all

[0m[1;32m[Status][0m Memory manager initialised: [1;37mlog/DSP.leaks[0m
[1;37m[Info][0m DarkStar - Git Revision Hash: [1;37m333585887222bacb34e646f8bd0b8241d95d8319[0m.
[1;32m[Status][0m do_init: begin server initialization...
[20:24:49][1;37m[Info][0m Console Silent Setting: 0 			 - [1;32m[OK][0m
[20:24:49][1;32m[Status][0m do_init: map_config is reading 		 - [1;32m[OK][0m
[20:24:49][1;32m[Status][0m luautils::init:lua initializing... 		 - [1;32m[OK][0m
[20:24:49][1;32m[Status][0m do_init: sqlhandle is allocating 		 - [1;32m[OK][0m
[20:24:49][1;32m[Status][0m do_init: zlib is reading 			 - [1;32m[OK][0m
[20:24:49][1;32m[Status][0m do_init: loading items 			 - [1;32m[OK][0m
[20:24:50][1;32m[Status][0m do_init: loading spells 			 - [1;32m[OK][0m
[20:24:50][1;36m[Debug][0m [1;36mUpdateGuildPointsPattern is finished. New pattern: 6
[0m[20:24:52][1;32m[Status][0m do_init: loading zones 			 - [1;32m[OK][0m
[20:26:23][1;32m[Status][0m do_init: server is binding with port 54230 	 - [1;32m[OK][0m
[20:26:23][1;36m[Debug][0m [1;36mInitializeWeather Finished
[0m[20:26:23][1;32m[Status][0m The map-server is [1;32mready[0m to work...
 =======================================================================
[20:26:23][1;36m[Debug][0m [1;36m[Lua] Garbage Collected. Current State Top: 0
[0m[20:29:55][1;36m[Debug][0m Message: Received message 0 from message server
[20:30:15][1;37m[Info][0m [1;37mmapsession[0m:[1;37m127.0.0.1[0m:[1;37m54090[0m is coming to world...
[20:30:15][1;37m[Info][0m parse: 00A | 0001 0000 2E from user: Cyan
[20:30:15][1;36m[Debug][0m [1;36mCZone:: Windurst_Woods IncreaseZoneCounter <1> Cyan 
[0m[20:30:17][1;37m[Info][0m parse: 00A | 0002 0000 2E from user: Cyan
[20:30:17][1;33m[Warning][0m [1;33mClient cannot receive packet or key is invalid: Cyan
[0m[20:30:19][1;37m[Info][0m parse: 00A | 0003 0000 2E from user: Cyan
[20:30:19][1;33m[Warning][0m [1;33mClient cannot receive packet or key is invalid: Cyan
[0m[20:30:21][1;37m[Info][0m parse: 00A | 0004 0000 2E from user: Cyan
[20:30:21][1;33m[Warning][0m [1;33mClient cannot receive packet or key is invalid: Cyan
[0m[20:30:23][1;37m[Info][0m parse: 00A | 0005 0000 2E from user: Cyan
[20:30:23][1;33m[Warning][0m [1;33mClient cannot receive packet or key is invalid: Cyan
[0m[20:30:25][1;37m[Info][0m parse: 00A | 0006 0000 2E from user: Cyan
[20:30:25][1;33m[Warning][0m [1;33mClient cannot receive packet or key is invalid: Cyan
[0m

[Dragol]

The invalid key thing was normal actually...just happened like 5 times. Usually only did it once or twice for me. Now its just my characters not showing up.

[Delaide]

Dragol, I think he means that one of the recent submits added a new column to the chars.sql.

It added in the

Code: Select all

`campaign_allegiance` tinyint(1) unsigned NOT NULL DEFAULT '0',

column.

You will probably need to go into your sql manager and add in that column.

Code: Select all

CREATE TABLE `chars` (
  `charid` int(10) unsigned NOT NULL,
  `accid` int(10) unsigned NOT NULL,
  `charname` varchar(15) NOT NULL,
  `nation` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `pos_zone` smallint(3) unsigned NOT NULL,
  `pos_prevzone` smallint(3) unsigned NOT NULL DEFAULT '0',
  `pos_rot` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `pos_x` float(7,3) NOT NULL DEFAULT '0.000',
  `pos_y` float(7,3) NOT NULL DEFAULT '0.000',
  `pos_z` float(7,3) NOT NULL DEFAULT '0.000',
  `boundary` smallint(5) unsigned NOT NULL DEFAULT '0',
  `home_zone` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `home_rot` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `home_x` float(7,3) NOT NULL DEFAULT '0.000',
  `home_y` float(7,3) NOT NULL DEFAULT '0.000',
  `home_z` float(7,3) NOT NULL DEFAULT '0.000',
  `merits` blob,
  `missions` blob,
  `assault` blob,
  `campaign` blob,
  `quests` blob,
  `keyitems` blob,
  `spells` blob,
  `set_blue_spells` blob,
  `abilities` blob,
  `titles` blob,
  `zones` blob,
  `playtime` int(10) unsigned NOT NULL DEFAULT '0',
  `unlocked_weapons` blob,
  `gmlevel` smallint(3) unsigned NOT NULL DEFAULT '0',
  `isnewplayer` smallint(3) NOT NULL DEFAULT '1',
  `mentor` smallint(3) NOT NULL DEFAULT '0',
  `campaign_allegiance` tinyint(1) unsigned NOT NULL DEFAULT '0', /* <---this */
  PRIMARY KEY (`charid`),
  FULLTEXT KEY `charname` (`charname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[kjLotus]

It added in the

Code: Select all

`campaign_allegiance` tinyint(1) unsigned NOT NULL DEFAULT '0',

column.

he's also missing mlvl and slvl, which is why searches don't work

[Delaide]

Got it. Well, here is a sql to fix it.

campaign_allegiance_mlvl_slvl.sql

(239 Bytes) Downloaded 355 times

Download it, put it wherever. When you open your sql manager application, double click the dspdb, then find "Execute batch file" or "load sql file" or whatever. Might be a right click on the database, or something in the top menu. Sorry, I work with navicat lite and heidisql, so cannot be sure what instructions to give you for that. This will automatically add in the right columns in the tables for you.

[Dragol]

My characters are back! Woo thanks guys. However searches still arent working It just shows 0 people when I search.

Getting this error on search server.

DB error - Column 'mlvl' in field list is ambiguous

[Delaide]

Hmm. mlvl is the main job level. I recommend going, changing jobs, then you can change back.

You can also try shutting down and restarting the server, see if it fixes it.

Honestly though, no idea what that even means, that it is ambiguous? I gave you the sql add table that had the same info as a fresh sql.