Yiv 321 Posted March 5, 2014 Share Posted March 5, 2014 Dear community, members of my server are sometimes resseted by level, yang and skills. I already tried to solve the problem on my own but my syserrs don't say anything what's helpful. What makes me most suspicious is that just sometimes this happens and sometimes over 1 level and sometimes over x levels. They just do relog and this happens, they're just warping, they're standing around for 1-2 hours and then relogg, everytime the same. For me it never happens until now. Somebody has any presumption what's the source of this error is? Regards Link to comment Share on other sites More sharing options...
Rumor 2625 Posted March 5, 2014 Share Posted March 5, 2014 are your cores crashing and being automatically restarted? Link to comment Share on other sites More sharing options...
Yiv 321 Posted March 5, 2014 Author Share Posted March 5, 2014 No, they don't crash (as I saw in syserr) and I do not let them restart automatically. Link to comment Share on other sites More sharing options...
Premium Shogun 4613 Posted March 5, 2014 Premium Share Posted March 5, 2014 I suspect you have some crashed table on the db (player.player?) Link to comment Share on other sites More sharing options...
Yiv 321 Posted March 5, 2014 Author Share Posted March 5, 2014 I think this is not the problem. They aren't resetted to level 1 just some level backwards like a rollback. I already repaired and checked all the tables. I added 3 columns to player.player, but set them to allow null and I never had this problem before if I added one or more columns. Any other ideas? Regards Link to comment Share on other sites More sharing options...
Premium Shogun 4613 Posted March 5, 2014 Premium Share Posted March 5, 2014 check db syslog, some query must be failing there, also I'd like to see your player table structure Link to comment Share on other sites More sharing options...
Yiv 321 Posted March 5, 2014 Author Share Posted March 5, 2014 I completly cleaned up my database syserr after I was fucked up by this error. In my syslog there's nothing about failed querys. My structure of player is: CREATE TABLE `player` ( `id` int(11) NOT NULL AUTO_INCREMENT, `account_id` int(11) NOT NULL DEFAULT '0', `name` varchar(24) NOT NULL DEFAULT 'NONAME', `job` tinyint(2) unsigned NOT NULL DEFAULT '0', `voice` tinyint(1) unsigned NOT NULL DEFAULT '0', `dir` tinyint(2) NOT NULL DEFAULT '0', `x` int(11) NOT NULL DEFAULT '0', `y` int(11) NOT NULL DEFAULT '0', `z` int(11) NOT NULL DEFAULT '0', `map_index` int(11) NOT NULL DEFAULT '0', `exit_x` int(11) NOT NULL DEFAULT '0', `exit_y` int(11) NOT NULL DEFAULT '0', `exit_map_index` int(11) NOT NULL DEFAULT '0', `hp` smallint(4) NOT NULL DEFAULT '0', `mp` smallint(4) NOT NULL DEFAULT '0', `stamina` smallint(6) NOT NULL DEFAULT '0', `random_hp` smallint(5) unsigned NOT NULL DEFAULT '0', `random_sp` smallint(5) unsigned NOT NULL DEFAULT '0', `playtime` int(11) NOT NULL DEFAULT '0', `level` tinyint(2) unsigned NOT NULL DEFAULT '1', `level_step` tinyint(1) NOT NULL DEFAULT '0', `st` smallint(3) NOT NULL DEFAULT '0', `ht` smallint(3) NOT NULL DEFAULT '0', `dx` smallint(3) NOT NULL DEFAULT '0', `iq` smallint(3) NOT NULL DEFAULT '0', `exp` int(11) NOT NULL DEFAULT '0', `gold` int(11) NOT NULL DEFAULT '0', `stat_point` smallint(3) NOT NULL DEFAULT '0', `skill_point` smallint(3) NOT NULL DEFAULT '0', `quickslot` tinyblob, `ip` varchar(15) DEFAULT '0.0.0.0', `part_main` smallint(6) NOT NULL DEFAULT '0', `part_base` tinyint(4) NOT NULL DEFAULT '0', `part_hair` smallint(4) NOT NULL DEFAULT '0', `skill_group` tinyint(4) NOT NULL DEFAULT '0', `skill_level` blob, `alignment` int(11) NOT NULL DEFAULT '0', `last_play` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `change_name` tinyint(1) NOT NULL DEFAULT '0', `mobile` varchar(24) DEFAULT NULL, `sub_skill_point` smallint(3) NOT NULL DEFAULT '0', `stat_reset_count` tinyint(4) NOT NULL DEFAULT '0', `horse_hp` smallint(4) NOT NULL DEFAULT '0', `horse_stamina` smallint(4) NOT NULL DEFAULT '0', `horse_level` tinyint(2) unsigned NOT NULL DEFAULT '0', `horse_hp_droptime` int(10) unsigned NOT NULL DEFAULT '0', `horse_riding` tinyint(1) NOT NULL DEFAULT '0', `horse_skill_point` smallint(3) NOT NULL DEFAULT '0', `bounty` int(11) NOT NULL DEFAULT '0', `kills` int(10) NOT NULL DEFAULT '0', `deads` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id_idx` (`account_id`), KEY `name_idx` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=58134 DEFAULT CHARSET=latin1; Hope you can help me. Regards Link to comment Share on other sites More sharing options...
Yiv 321 Posted March 6, 2014 Author Share Posted March 6, 2014 Nobody has any idea? Regards Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now