Problem with Char delete

[Fliegex3 29]

I can't delete Characters on my Pserver.

 

DB Error:

SYSERR: May  7 13:07:34 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column count doesn't match value count at row 1

query: INSERT INTO player_deleted SELECT * FROM player WHERE id=57834

 

Game Revision: 34k

[Shogun 5764]

The table player_deleted has a wrong structure. Copy the structure from player.player.

[Fliegex3 29]

/*

Navicat MySQL Data Transfer

 

Source Server         : helfen

Source Server Version : 50532

Source Host           : 25.175.136.42:3306

Source Database       : player

 

Target Server Type    : MYSQL

Target Server Version : 50532

File Encoding         : 65001

 

Date: 2014-05-07 15:31:25

*/

 

SET FOREIGN_KEY_CHECKS=0;

 

-- ----------------------------

-- Table structure for `player_deleted`

-- ----------------------------

DROP TABLE IF EXISTS `player_deleted`;

CREATE TABLE `player_deleted` (

  `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` tinyint(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(32) 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',

  PRIMARY KEY (`id`),

  KEY `account_id_idx` (`account_id`),

  KEY `name_idx` (`name`)

) ENGINE=MyISAM AUTO_INCREMENT=58014 DEFAULT CHARSET=latin1;

 

-- ----------------------------

-- Records of player_deleted

-- ----------------------------

 

[Shogun 5764]

What are you trying to tell me with that? Just delete player.player_deleted, make a copy of player.player, truncate it and rename it as player_deleted

[Fliegex3 29]

ah okay, i'll try it. Thanks

[Veneno 7]

Thanks helped me a lot

[[007]DawisHU 352]

Hello,What i do  ?

In DB config
MIN_LENGTH_OF_SOCIAL_ID    = 6 to MIN_LENGTH_OF_SOCIAL_ID    = 7
SIMPLE_SOCIALID = 0 to SIMPLE_SOCIALID = 1
TABLE_POSTFIX = " " to TABLE_POSTFIX = ""
PLAYER_DELETE_CHECK_SIMPLE = 0 to PLAYER_DELETE_CHECK_SIMPLE = 1