Fliegex3 29 Posted May 7, 2014 Share Posted May 7, 2014 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 Link to comment Share on other sites More sharing options...
Premium Shogun 4614 Posted May 7, 2014 Premium Share Posted May 7, 2014 The table player_deleted has a wrong structure. Copy the structure from player.player. 3 Link to comment Share on other sites More sharing options...
Fliegex3 29 Posted May 7, 2014 Author Share Posted May 7, 2014 /* 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 -- ---------------------------- Link to comment Share on other sites More sharing options...
Premium Shogun 4614 Posted May 7, 2014 Premium Share Posted May 7, 2014 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 3 Link to comment Share on other sites More sharing options...
Fliegex3 29 Posted May 7, 2014 Author Share Posted May 7, 2014 ah okay, i'll try it. Thanks Link to comment Share on other sites More sharing options...
Veneno 7 Posted November 12, 2015 Share Posted November 12, 2015 Thanks helped me a lot Link to comment Share on other sites More sharing options...
[007]DawisHU 278 Posted February 20, 2017 Share Posted February 20, 2017 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 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