part_main

[EnKor 42]

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;
 

[MORTE 76]

I have the same error, if you can solve please tell me: /

[tierrilopes 446]

« 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.

[EnKor 42]

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

[tierrilopes 446]

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.

[EnKor 42]

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