Premium EnKor 43 Posted December 21, 2016 Premium Share Posted December 21, 2016 Why i get this error in DB\syserr after install sash? SYSERR: Dec 22 22:45:38 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 2, voice = 0, dir = 0, x = 469300, y = 964200, z = 0, map_index = 1, exit_x = 469300, exit_y = 964200, exit_map_index = 1, hp = 16017, mp = 4590, stamina = 875, random_hp = 4264, random_sp = 2080, playtime = 1367, level = 105, level_step = 0, st = 5, ht = 3, dx = 3, iq = 5, gold = 892393003, exp = 0, stat_point = 0, skill_point = 312, sub_skill_point = 104, stat_reset_count = 46, ip = '(null)', part_main = 679845925, part_hair = 41003, part_acce = 5002, last_play = NOW(), skill_group = 4, alignment = 0, horse_level = 5315, horse_riding = 30, horse_hp = 0, horse_hp_droptime = 49, horse_stamina = 1482699486, horse_skill_point = 200, skill_level = '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ its all working 5*, but i get that error in db every time char log out. why? can any one help me. please! structure of player table: /* Navicat MySQL Data Transfer Source Server : FreeBSD Source Server Version : 50634 Source Host : 192.168.1.100:3306 Source Database : player Target Server Type : MYSQL Target Server Version : 50634 File Encoding : 65001 Date: 2016-12-22 23:34:01 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for player -- ---------------------------- DROP TABLE IF EXISTS `player`; 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` int(11) NOT NULL DEFAULT '0', `mp` smallint(4) NOT NULL DEFAULT '0', `stamina` smallint(6) NOT NULL DEFAULT '0', `random_hp` int(11) unsigned NOT NULL DEFAULT '0', `random_sp` smallint(5) unsigned NOT NULL DEFAULT '0', `playtime` int(11) NOT NULL DEFAULT '0', `level` bigint(20) 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` bigint(20) 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', `part_acce` smallint(4) unsigned 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', `lock_system` int(4) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id_idx` (`account_id`), KEY `name_idx` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=10014 DEFAULT CHARSET=latin1; 1 if pc.get_sex() == true and npc.get_sex() == false then npc.purge() end Link to comment Share on other sites More sharing options...
MORTE 79 Posted December 22, 2016 Share Posted December 22, 2016 I have the same error, if you can solve please tell me: / Link to comment Share on other sites More sharing options...
Premium tierrilopes 453 Posted December 22, 2016 Premium Share Posted December 22, 2016 « Out of range value » part_main` smallint(6) NOT NULL DEFAULT '0', __ smallint max value: 32.767 the query part_main value: 679.845.925 __ part_main max length structure: 6 the query part_main max length structure: 9 Fix: On structure, change max length to 20 for example. Change type to bigint. 2 Link to comment Share on other sites More sharing options...
Premium EnKor 43 Posted December 22, 2016 Author Premium Share Posted December 22, 2016 On 22/12/2016 at 1:31 AM, tierrilopes said: « Out of range value » part_main` smallint(6) NOT NULL DEFAULT '0', __ smallint max value: 32.767 the query part_main value: 679.845.925 __ part_main max length structure: 6 the query part_main max length structure: 9 Fix: On structure, change max length to 20 for example. Change type to bigint. after change in part_main, have to do the same in horse_level, horse_stamina etc.... then char atributtes go to SRT: 215648451215 INT: 5451857481 etc.... This is not the soluction if pc.get_sex() == true and npc.get_sex() == false then npc.purge() end Link to comment Share on other sites More sharing options...
Premium tierrilopes 453 Posted December 22, 2016 Premium Share Posted December 22, 2016 Thats the solution for the error you showed. If you have it giving such high values then you must find out why it happens, we're not wizards. Link to comment Share on other sites More sharing options...
Premium EnKor 43 Posted December 22, 2016 Author Premium Share Posted December 22, 2016 On 22/12/2016 at 1:11 PM, tierrilopes said: Thats the solution for the error you showed. If you have it giving such high values then you must find out why it happens, we're not wizards. its because problens in ClientManagerPlayer.cpp "size_t CreatePlayerSaveQuery(char * pszQuery, size_t querySize, TPlayerTable * pkTab)" All working now if pc.get_sex() == true and npc.get_sex() == false then npc.purge() end 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