|
You last visited: Today at 03:50
Advertisement
Problem Hilfe Syserr
Discussion on Problem Hilfe Syserr within the Metin2 Private Server forum part of the Metin2 category.
01/15/2015, 02:48
|
#1
|
elite*gold: 0 
Join Date: Sep 2012
Posts: 1,376
Received Thanks: 223
|
Problem Hilfe Syserr
was das für ein fehler?
PHP Code:
SYSERR: Jan 15 02:30:52 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jan 15 02:30:52 :: GetPoint: POINT_ERROR: AllMighty type 100 val 50 (max: 1032994832)
SYSERR: Jan 15 02:30:52 :: ChildLoop: AsyncSQL: query failed: Query execution was interrupted (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57990, 959897, 271190, 0, 'LOGOUT', '', '*******') errno: 1317)
SYSERR: Jan 15 02:30:52 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57988, 960370, 271798, 0, 'LOGOUT', '', '217.88.34.63') errno: 2002)
SYSERR: Jan 15 02:30:52 :: ChildLoop: AsyncSQL: retrying
SYSERR: Jan 15 02:30:52 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57988, 960370, 271798, 0, 'LOGOUT', '', '217.88.34.63') errno: 2002)
SYSERR: Jan 15 02:30:52 :: ChildLoop: AsyncSQL: retrying
SYSERR: Jan 15 02:30:52 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57988, 960370, 271798, 0, 'LOGOUT', '', '217.88.34.63') errno: 2002)
SYSERR: Jan 15 02:30:52 :: ChildLoop: AsyncSQL: retrying
SYSERR: Jan 15 02:30:52 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57988, 960370, 271798, 0, 'LOGOUT', '', '217.88.34.63') errno: 2002)
SYSERR: Jan 15 02:30:52 :: ChildLoop: AsyncSQL: retrying
SYSERR: Jan 15 02:30:52 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57988, 960370, 271798, 0, 'LOGOUT', '', '217.88.34.63') errno: 2002)
SYSERR: Jan 15 02:30:52 :: ChildLoop: AsyncSQL: retrying
SYSERR: Jan 15 02:40:19 :: socket_connect: HOST localhost:15000, could not connect.
|
|
|
|
01/15/2015, 08:37
|
#2
|
elite*gold: 40
Join Date: Nov 2009
Posts: 1,159
Received Thanks: 442
|
Zunächst mal die Frage: Läuft dein Server?
Ansonsten kann er in die Tabelle: (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57988, 960370, 271798, 0, 'LOGOUT', '', '217.88.34.63'
nichts reinschreiben, da eine Spalte fehlt.
|
|
|
|
|
01/15/2015, 11:01
|
#3
|
elite*gold: 0
Join Date: Sep 2012
Posts: 1,376
Received Thanks: 223
|
Die Tabelle Gibt es nichtmal bei mir 
|
|
|
|
|
01/15/2015, 11:04
|
#4
|
elite*gold: 0
Join Date: Feb 2010
Posts: 413
Received Thanks: 148
|
-- ----------------------------
-- Table structure for `bootlog`
-- ----------------------------
DROP TABLE IF EXISTS `bootlog`;
CREATE TABLE `bootlog` (
`time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`hostname` char(128) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL DEFAULT 'UNKNOWN' ,
`channel` tinyint(1) NOT NULL DEFAULT 0
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=big5 COLLATE=big5_chinese_ci
CHECKSUM=0
ROW_FORMAT=Fixed
DELAY_KEY_WRITE=0
;
-- ----------------------------
-- Table structure for `change_name`
-- ----------------------------
DROP TABLE IF EXISTS `change_name`;
CREATE TABLE `change_name` (
`pid` int(11) NULL DEFAULT NULL ,
`old_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
`new_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
`time` datetime NULL DEFAULT NULL ,
`ip` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
CHECKSUM=0
ROW_FORMAT=Dynamic
DELAY_KEY_WRITE=0
;
-- ----------------------------
-- Table structure for `command_log`
-- ----------------------------
DROP TABLE IF EXISTS `command_log`;
CREATE TABLE `command_log` (
`id` int(11) NOT NULL AUTO_INCREMENT ,
`userid` int(11) NOT NULL DEFAULT 0 ,
`server` int(11) NOT NULL DEFAULT 0 ,
`ip` varchar(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '' ,
`port` int(6) NOT NULL DEFAULT 0 ,
`username` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '' ,
`command` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
AUTO_INCREMENT=1
CHECKSUM=0
ROW_FORMAT=Dynamic
DELAY_KEY_WRITE=0
;
-- ----------------------------
-- Table structure for `cube`
-- ----------------------------
DROP TABLE IF EXISTS `cube`;
CREATE TABLE `cube` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
`pid` int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`x` int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`y` int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`item_vnum` int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`item_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`item_count` int(5) UNSIGNED NOT NULL DEFAULT 0 ,
`success` tinyint(1) NOT NULL DEFAULT 0 ,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=big5 COLLATE=big5_chinese_ci
AUTO_INCREMENT=1
CHECKSUM=0
ROW_FORMAT=Fixed
DELAY_KEY_WRITE=0
;
-- ----------------------------
-- Table structure for `dragon_slay_log`
-- ----------------------------
DROP TABLE IF EXISTS `dragon_slay_log`;
CREATE TABLE `dragon_slay_log` (
`guild_id` int(11) UNSIGNED NOT NULL ,
`vnum` int(11) UNSIGNED NOT NULL ,
`start_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`end_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
CHECKSUM=0
ROW_FORMAT=Fixed
DELAY_KEY_WRITE=0
;
-- ----------------------------
-- Table structure for `fish_log`
-- ----------------------------
DROP TABLE IF EXISTS `fish_log`;
CREATE TABLE `fish_log` (
`time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`player_id` int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`map_index` tinyint(4) NOT NULL DEFAULT 0 ,
`fish_id` int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`fishing_level` int(11) NOT NULL DEFAULT 0 ,
`waiting_time` int(11) NOT NULL DEFAULT 0 ,
`success` tinyint(4) NOT NULL DEFAULT 0 ,
`size` smallint(6) NOT NULL DEFAULT 0
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=big5 COLLATE=big5_chinese_ci
CHECKSUM=0
ROW_FORMAT=Fixed
DELAY_KEY_WRITE=0
;
-- ----------------------------
-- Table structure for `goldlog`
-- ----------------------------
DROP TABLE IF EXISTS `goldlog`;
CREATE TABLE `goldlog` (
`date` varchar(10) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL DEFAULT '0000-00-00' ,
`time` varchar(8) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL DEFAULT '00:00:00' ,
`pid` int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`what` int(11) NOT NULL DEFAULT 0 ,
`how` set('BUY','SELL','SHOP_SELL','SHOP_BUY','EXCHANGE_ TAKE','EXCHANGE_GIVE','QUEST') CHARACTER SET big5 COLLATE big5_chinese_ci NULL DEFAULT NULL ,
`hint` varchar(50) CHARACTER SET big5 COLLATE big5_chinese_ci NULL DEFAULT NULL
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=big5 COLLATE=big5_chinese_ci
CHECKSUM=0
ROW_FORMAT=Dynamic
DELAY_KEY_WRITE=0
;
-- ----------------------------
-- Table structure for `hack_crc_log`
-- ----------------------------
DROP TABLE IF EXISTS `hack_crc_log`;
CREATE TABLE `hack_crc_log` (
`time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`login` char(16) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL DEFAULT '' ,
`name` char(24) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL DEFAULT '' ,
`ip` char(15) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL DEFAULT '' ,
`server` char(100) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL DEFAULT '' ,
`why` char(255) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL DEFAULT '' ,
`crc` int(11) NOT NULL DEFAULT 0
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=big5 COLLATE=big5_chinese_ci
CHECKSUM=0
ROW_FORMAT=Fixed
DELAY_KEY_WRITE=0
;
-- ----------------------------
-- Table structure for `hack_log`
-- ----------------------------
DROP TABLE IF EXISTS `hack_log`;
CREATE TABLE `hack_log` (
`time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`login` char(16) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL DEFAULT '' ,
`name` char(24) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL DEFAULT '' ,
`ip` char(15) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL DEFAULT '' ,
`server` char(100) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL DEFAULT '' ,
`why` char(255) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL DEFAULT ''
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=big5 COLLATE=big5_chinese_ci
CHECKSUM=0
ROW_FORMAT=Fixed
DELAY_KEY_WRITE=0
;
-- ----------------------------
-- Table structure for `hackshield_log`
-- ----------------------------
DROP TABLE IF EXISTS `hackshield_log`;
CREATE TABLE `hackshield_log` (
`pid` int(11) UNSIGNED NOT NULL DEFAULT 0 ,
`login` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
`account_id` int(11) UNSIGNED NOT NULL ,
`name` varchar(25) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
`time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`reason` varchar(25) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
CHECKSUM=0
ROW_FORMAT=Dynamic
DELAY_KEY_WRITE=0
;
-- ----------------------------
-- Table structure for `levellog`
-- ----------------------------
DROP TABLE IF EXISTS `levellog`;
CREATE TABLE `levellog` (
`name` char(24) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL DEFAULT '' ,
`level` tinyint(4) NOT NULL DEFAULT 0 ,
`time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`playtime` int(11) NOT NULL DEFAULT 0 ,
PRIMARY KEY (`name`, `level`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=big5 COLLATE=big5_chinese_ci
CHECKSUM=0
ROW_FORMAT=Fixed
DELAY_KEY_WRITE=0
;
-- ----------------------------
-- Table structure for `log`
-- ----------------------------
DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
`type` enum('ITEM','CHARACTER') CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL DEFAULT 'ITEM' ,
`time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`who` int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`x` int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`y` int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`what` int(11) NOT NULL DEFAULT 0 ,
`how` varchar(50) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL DEFAULT '' ,
`hint` varchar(70) CHARACTER SET big5 COLLATE big5_chinese_ci NULL DEFAULT NULL ,
`ip` varchar(20) CHARACTER SET big5 COLLATE big5_chinese_ci NULL DEFAULT NULL ,
`vnum` int(11) NULL DEFAULT NULL
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=big5 COLLATE=big5_chinese_ci
CHECKSUM=0
ROW_FORMAT=Dynamic
DELAY_KEY_WRITE=0
;
-- ----------------------------
-- Table structure for `loginlog`
-- ----------------------------
DROP TABLE IF EXISTS `loginlog`;
CREATE TABLE `loginlog` (
`type` enum('LOGIN','LOGOUT') CHARACTER SET big5 COLLATE big5_chinese_ci NULL DEFAULT NULL ,
`time` datetime NULL DEFAULT NULL ,
`channel` tinyint(4) NULL DEFAULT NULL ,
`account_id` int(10) UNSIGNED NULL DEFAULT NULL ,
`pid` int(10) UNSIGNED NULL DEFAULT NULL ,
`level` smallint(6) NULL DEFAULT NULL ,
`job` tinyint(4) NULL DEFAULT NULL ,
`playtime` int(10) UNSIGNED NULL DEFAULT NULL
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=big5 COLLATE=big5_chinese_ci
CHECKSUM=0
ROW_FORMAT=Fixed
DELAY_KEY_WRITE=0
;
-- ----------------------------
-- Table structure for `money_log`
-- ----------------------------
DROP TABLE IF EXISTS `money_log`;
CREATE TABLE `money_log` (
`time` datetime NULL DEFAULT NULL ,
`type` enum('MONSTER','SHOP','REFINE','QUEST','GUILD','MI SC','KILL','DROP') CHARACTER SET big5 COLLATE big5_chinese_ci NULL DEFAULT NULL ,
`vnum` int(11) NOT NULL DEFAULT 0 ,
`gold` int(11) NOT NULL DEFAULT 0
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=big5 COLLATE=big5_chinese_ci
CHECKSUM=0
ROW_FORMAT=Fixed
DELAY_KEY_WRITE=0
;
-- ----------------------------
-- Table structure for `pcbang_loginlog`
-- ----------------------------
DROP TABLE IF EXISTS `pcbang_loginlog`;
CREATE TABLE `pcbang_loginlog` (
`id` int(11) NOT NULL AUTO_INCREMENT ,
`time` datetime NULL DEFAULT NULL ,
`pcbang_id` int(11) NOT NULL DEFAULT 0 ,
`ip` varchar(15) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL DEFAULT '000.000.000.000' ,
`pid` int(10) UNSIGNED NULL DEFAULT NULL ,
`play_time` int(10) UNSIGNED NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=big5 COLLATE=big5_chinese_ci
AUTO_INCREMENT=1
CHECKSUM=0
ROW_FORMAT=Dynamic
DELAY_KEY_WRITE=0
;
-- ----------------------------
-- Table structure for `playercount`
-- ----------------------------
DROP TABLE IF EXISTS `playercount`;
CREATE TABLE `playercount` (
`date` datetime NULL DEFAULT NULL ,
`count_red` int(11) NULL DEFAULT NULL ,
`count_yellow` int(11) NULL DEFAULT NULL ,
`count_blue` int(11) NULL DEFAULT NULL ,
`count_total` int(11) NULL DEFAULT NULL
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
CHECKSUM=0
ROW_FORMAT=Fixed
DELAY_KEY_WRITE=0
;
-- ----------------------------
-- Table structure for `quest_reward_log`
-- ----------------------------
DROP TABLE IF EXISTS `quest_reward_log`;
CREATE TABLE `quest_reward_log` (
`quest_name` varchar(32) CHARACTER SET big5 COLLATE big5_chinese_ci NULL DEFAULT NULL ,
`player_id` int(10) UNSIGNED NULL DEFAULT NULL ,
`player_level` tinyint(4) NULL DEFAULT NULL ,
`reward_type` enum('EXP','ITEM') CHARACTER SET big5 COLLATE big5_chinese_ci NULL DEFAULT NULL ,
`reward_value1` int(10) UNSIGNED NULL DEFAULT NULL ,
`reward_value2` int(11) NULL DEFAULT NULL ,
`time` datetime NULL DEFAULT NULL
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=big5 COLLATE=big5_chinese_ci
CHECKSUM=0
ROW_FORMAT=Dynamic
DELAY_KEY_WRITE=0
;
-- ----------------------------
-- Table structure for `refinelog`
-- ----------------------------
DROP TABLE IF EXISTS `refinelog`;
CREATE TABLE `refinelog` (
`pid` int(10) UNSIGNED NULL DEFAULT NULL ,
`item_name` varchar(24) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL DEFAULT '' ,
`item_id` int(11) NOT NULL DEFAULT 0 ,
`step` varchar(50) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL DEFAULT '' ,
`time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`is_success` tinyint(1) NOT NULL DEFAULT 0 ,
`setType` set('SOCKET','POWER','ROD','GUILD','SCROLL','HYUNI RON','GOD_SCROLL','MUSIN_SCROLL') CHARACTER SET big5 COLLATE big5_chinese_ci NULL DEFAULT NULL
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=big5 COLLATE=big5_chinese_ci
CHECKSUM=0
ROW_FORMAT=Dynamic
DELAY_KEY_WRITE=0
;
-- ----------------------------
-- Table structure for `shout_log`
-- ----------------------------
DROP TABLE IF EXISTS `shout_log`;
CREATE TABLE `shout_log` (
`time` datetime NULL DEFAULT '0000-00-00 00:00:00' ,
`channel` tinyint(4) NULL DEFAULT NULL ,
`empire` tinyint(4) NULL DEFAULT NULL ,
`shout` varchar(350) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=big5 COLLATE=big5_chinese_ci
CHECKSUM=0
ROW_FORMAT=Dynamic
DELAY_KEY_WRITE=0
;
-- ----------------------------
-- Table structure for `speed_hack`
-- ----------------------------
DROP TABLE IF EXISTS `speed_hack`;
CREATE TABLE `speed_hack` (
`pid` int(11) NULL DEFAULT NULL ,
`time` datetime NULL DEFAULT NULL ,
`x` int(11) NULL DEFAULT NULL ,
`y` int(11) NULL DEFAULT NULL ,
`hack_count` varchar(20) CHARACTER SET big5 COLLATE big5_bin NULL DEFAULT NULL
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
CHECKSUM=0
ROW_FORMAT=Dynamic
DELAY_KEY_WRITE=0
;
-- ----------------------------
-- Auto increment value for `command_log`
-- ----------------------------
ALTER TABLE `command_log` AUTO_INCREMENT=1;
-- ----------------------------
-- Indexes structure for table cube
-- ----------------------------
CREATE INDEX `pid` ON `cube`(`pid`) USING BTREE ;
CREATE INDEX `item_vnum` ON `cube`(`item_vnum`) USING BTREE ;
CREATE INDEX `item_uid` ON `cube`(`item_uid`) USING BTREE ;
-- ----------------------------
-- Auto increment value for `cube`
-- ----------------------------
ALTER TABLE `cube` AUTO_INCREMENT=0;
-- ----------------------------
-- Indexes structure for table goldlog
-- ----------------------------
CREATE INDEX `date_idx` ON `goldlog`(`date`) USING BTREE ;
CREATE INDEX `pid_idx` ON `goldlog`(`pid`) USING BTREE ;
CREATE INDEX `what_idx` ON `goldlog`(`what`) USING BTREE ;
CREATE INDEX `how_idx` ON `goldlog`(`how`) USING BTREE ;
-- ----------------------------
-- Indexes structure for table log
-- ----------------------------
CREATE INDEX `who_idx` ON `log`(`who`) USING BTREE ;
CREATE INDEX `what_idx` ON `log`(`what`) USING BTREE ;
CREATE INDEX `how_idx` ON `log`(`how`) USING BTREE ;
-- ----------------------------
-- Indexes structure for table loginlog
-- ----------------------------
CREATE INDEX `pid` ON `loginlog`(`pid`, `type`) USING BTREE ;
-- ----------------------------
-- Indexes structure for table money_log
-- ----------------------------
CREATE INDEX `type` ON `money_log`(`type`, `vnum`) USING BTREE ;
-- ----------------------------
-- Indexes structure for table pcbang_loginlog
-- ----------------------------
CREATE INDEX `pid` ON `pcbang_loginlog`(`pid`) USING BTREE ;
CREATE INDEX `pcbang_id` ON `pcbang_loginlog`(`pcbang_id`) USING BTREE ;
-- ----------------------------
-- Auto increment value for `pcbang_loginlog`
-- ----------------------------
ALTER TABLE `pcbang_loginlog` AUTO_INCREMENT=1;
-- ----------------------------
-- Indexes structure for table quest_reward_log
-- ----------------------------
CREATE INDEX `player_id` ON `quest_reward_log`(`player_id`) USING BTREE ;
-- ----------------------------
-- Indexes structure for table shout_log
-- ----------------------------
CREATE INDEX `time_idx` ON `shout_log`(`time`) USING BTREE ;
da hast die komplette log datenbank
|
|
|
|
|
01/15/2015, 13:26
|
#5
|
elite*gold: 0
Join Date: Sep 2012
Posts: 1,376
Received Thanks: 223
|
wie Füge ich die so ein? Hab immer nur per sql eingefügt
|
|
|
|
|
01/15/2015, 14:40
|
#6
|
elite*gold: 56
Join Date: Sep 2011
Posts: 777
Received Thanks: 365
|
Console öffnen und die Tables einfügen.
|
|
|
|
 |
Similar Threads
|
Hilfe by syserr
11/24/2012 - Metin2 Private Server - 9 Replies
Hey ho com ,
Aso ich habe ein problem nach dem ich eine neue map eingefügt habe , und bin auf der map nach 5minuten geht der server down .. und in der syserr kommt das ...
SYSERR: Nov 23 22:52:38 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Nov 23 22:54:15 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Nov 23 22:55:05 :: GetMotionFileName: Motion: lion have not motlist.txt vnum(20119) folder(lion)
SYSERR: Nov 23 22:55:05...
|
Bitte schnell Hilfe Syserr problem
07/12/2012 - Metin2 Private Server - 2 Replies
7 :: GRANNY: r:/granny/rt/granny_file_info.cpp(145): File has run-time type tag of 0x8000000f, which doesn't match this version of Granny (0x80000010). Automatic conversion will be attempted.
0708 19:20:30568 :: Hair number 1016 is not exist.
0708 19:20:30569 :: void CGraphicThingInstance::UpdateTransform(pMatrix, fSecondsElapsed=0.030000, iModelInstanceIndex=0/nLODCount=5) - pkLODCtrl->GetModelInstance() == NULL
0708 19:20:30570 :: void CGraphicThingInstance::UpdateTransform(pMatrix,...
|
[Hilfe] Client Problem - syserr in 3 minuten 50 MB voll
05/10/2012 - Metin2 Private Server - 2 Replies
Hallo ich habe ein problem,
ich hatte meinen client etwas bearbeitet damit es keine
fehler generiert.
nun habe ich das problem das er mir die ganze zeit dieses anzeigt:
0508 15:09:02946 :: CRaceManager::GetRaceDataPointer: cannot load data by dwRaceIndex 104
0508 15:09:02946 :: CPythonCharacterManager::CreateInstance VID Race
0508 15:09:02946 :: CRaceManager::RegisterRacePath : RACE LOAD MSMFILE ERROR
|
[Hilfe] Syserr
04/05/2012 - Metin2 Private Server - 0 Replies
Hallo Com,
Habe leider gestern einen Core Crash erleben dürfen :D Auch mal was neues...
Ich glaube als es heißt write to desc error ist das ganze dann geschehen.
Hat jmd ne Ahnung wieso?
SYSERR: Apr 5 02:11:11 :: ChildLoop: AsyncSQL: query failed: Unknown column 'account_id' in 'field list' (query: REPLACE INTO levellog (name, level, time, account_id, pid, playtime) VALUES('ZiegeunazZzZ', 4, NOW(), 52278, 57867, 7) errno: 1054)
SYSERR: Apr 5 02:11:16 :: ChildLoop: AsyncSQL: query...
|
syserr hilfe
08/11/2010 - Metin2 Private Server - 1 Replies
ich habe folgenden fehler ich habe den server neu gemacht habe meine hongkong drauf gemacht und var/db/mysql
und habe bei der game1_1 ch1 folgenden fehler
SYSERR: Aug 11 10:50:19 :: ForAttrRegion: Cannot find SECTREE_MAP by map index 41
wer kann mir helfen gibt nen thx
|
All times are GMT +2. The time now is 03:50.
|
|
