Jump to content
×
×
  • Create New...
  • 0

part_main


EnKor

Question

  • Premium

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;
 

  • Love 1
Link to comment

5 answers to this question

Recommended Posts

  • 0
  • Premium

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

  • Love 2
Link to comment
  • 0
  • Premium
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

Link to comment
  • 0
  • Premium
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

 

 

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Read our Rules
  • Activity

    1. 0

      [Land of Heroes] We are looking for Game / Game Economy Designers

    2. 177

      Render Target Remastered

    3. 1

      MySQL stop when start server

    4. 0

    5. 59

      Emoji in TextLine

    6. 1

      MySQL stop when start server

  • Recently Browsing

    No registered users viewing this page.

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.