Sysser

xAetees · 28 Iul 2019, 16:18

*Problemă:Imi da eroarea asta in sysser in canal1/core1, dupa ce am implementat transmutatia
Tipologie server(PvM / PvP):clean
*Resursă folosită:
*ServerFiles utilizat:j4m
*Syserr:

SYSERR: Jul 27 04:37:43 :: ChildLoop: AsyncSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2824,' at line 1 (query: INSERT DELAYED INTO log " (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2824, 964089, 265754, 50000042, 'BUY', 'Pumnal foaie neagra+0', '25.98.163.73', 1170) errno: 1064)
SYSERR: Jul 27 04:38:14 :: locale_find: LOCALE_ERROR: "Item-ul a fost distrus!";
SYSERR: Jul 27 04:38:14 :: locale_find: LOCALE_ERROR: "1 Yang a fost luat!";
SYSERR: Jul 27 04:38:14 :: ChildLoop: AsyncSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2824,' at line 1 (query: INSERT DELAYED INTO log " (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2824, 954309, 266429, 50000003, 'CHANGE_LOOK_SECOND_ITEM_DESTROY', 'Vesmant trandafiriu+9 1 ', '25.98.163.73', 11829) errno: 1064)
SYSERR: Jul 27 04:38:25 :: locale_find: LOCALE_ERROR: "Item-ul a fost distrus!";
SYSERR: Jul 27 04:38:25 :: locale_find: LOCALE_ERROR: "1 Yang a fost luat!";
SYSERR: Jul 27 04:38:25 :: ChildLoop: AsyncSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2824,' at line 1 (query: INSERT DELAYED INTO log " (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2824, 954309, 266429, 50000008, 'CHANGE_LOOK_SECOND_ITEM_DESTROY', 'Costum rosu scarlatin+9 1 ', '25.98.163.73', 11429) errno: 1064)
SYSERR: Jul 27 04:39:01 :: locale_find: LOCALE_ERROR: "Item-ul a fost distrus!";
SYSERR: Jul 27 04:39:01 :: locale_find: LOCALE_ERROR: "1 Yang a fost luat!";
SYSERR: Jul 27 04:39:01 :: ChildLoop: AsyncSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2824,' at line 1 (query: INSERT DELAYED INTO log " (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2824, 953796, 266384, 50000005, 'CHANGE_LOOK_SECOND_ITEM_DESTROY', 'Vesmantul dragostei+9 1 ', '25.98.163.73', 11839) errno: 1064)
SYSERR: Jul 27 04:39:36 :: Process: SEQUENCE 43502800 mismatch 0xaf != 0x64 header 254
SYSERR: Jul 27 04:39:36 :: Process: SEQUENCE_LOG [UNKNOWN]-------------
[254 : 0xaf]

SYSERR: Jul 27 04:40:01 :: ChildLoop: AsyncSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '" (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 2824, ' at line 1 (query: INSERT DELAYED INTO log " (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 2824, 954185, 266423, 0, 'LOGOUT', '25.98.163.73 1099276594 1 41 15', '25.98.163.73') errno: 1064)
SYSERR: Jul 27 04:40:08 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jul 27 04:40:10 :: pid_deinit:
End of pid

Poză:
*Detalii suplimentare:Transmutatia merge, dar nu merge sa scot transmutatia de pe un item, nu stiu de ce, si merge sa transmutez gen evantai pe clopot, posibil din cauza asta nu inteleg de ce

xAetees · 28 Iul 2019, 19:12

up

[ Postat de pe Android ] Imagine

xAetees · 29 Iul 2019, 10:01

up

[ Postat de pe Android ] Imagine

YoKe · 29 Iul 2019, 10:29

Insereaza astea in log in baza de date.

[ Postat de pe Android ] Imagine

xAetees · 29 Iul 2019, 11:27

YoKe scrie: ↑29 Iul 2019, 10:29 Insereaza astea in log in baza de date.
SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for acce
-- ----------------------------
DROP TABLE IF EXISTS `acce`;
CREATE TABLE `acce` (
`pid` int(11) NOT NULL,
`time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`x` int(1) NOT NULL,
`y` int(1) NOT NULL,
`item_vnum` int(11) NOT NULL,
`item_uid` int(11) NOT NULL,
`item_count` smallint(3) NOT NULL,
`item_abs_chance` smallint(3) NOT NULL,
`success` varbinary(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs ROW_FORMAT=FIXED;

-- ----------------------------
-- Table structure for bonus_hack
-- ----------------------------
DROP TABLE IF EXISTS `bonus_hack`;
CREATE TABLE `bonus_hack` (
`login` longtext COLLATE big5_bin,
`nickname` varchar(11) COLLATE big5_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;

-- ----------------------------
-- Table structure for bootlog
-- ----------------------------
DROP TABLE IF EXISTS `bootlog`;
CREATE TABLE `bootlog` (
`time` int(11) DEFAULT NULL,
`hostname` int(11) DEFAULT NULL,
`channel` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;

-- ----------------------------
-- Table structure for change_name
-- ----------------------------
DROP TABLE IF EXISTS `change_name`;
CREATE TABLE `change_name` (
`pid` int(20) NOT NULL DEFAULT '0',
`old_name` varchar(30) DEFAULT NULL,
`new_name` varchar(30) DEFAULT NULL,
`time` datetime DEFAULT NULL,
`ip` varchar(30) DEFAULT NULL,
PRIMARY KEY (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for command_log
-- ----------------------------
DROP TABLE IF EXISTS `command_log`;
CREATE TABLE `command_log` (
`userid` int(11) DEFAULT NULL,
`server` int(11) DEFAULT NULL,
`ip` text,
`port` int(11) DEFAULT NULL,
`username` varchar(12) CHARACTER SET big5 DEFAULT 'NONAME',
`command` varchar(105) CHARACTER SET big5 COLLATE big5_bin DEFAULT NULL,
`date` datetime DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for cube
-- ----------------------------
DROP TABLE IF EXISTS `cube`;
CREATE TABLE `cube` (
`pid` varchar(20) DEFAULT NULL,
`time` datetime DEFAULT NULL,
`x` varchar(40) DEFAULT NULL,
`y` varchar(40) DEFAULT NULL,
`item_vnum` varchar(40) DEFAULT NULL,
`item_uid` varchar(40) DEFAULT NULL,
`item_count` varchar(20) DEFAULT NULL,
`success` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for dragon_slay_log
-- ----------------------------
DROP TABLE IF EXISTS `dragon_slay_log`;
CREATE TABLE `dragon_slay_log` (
`1` varchar(255) NOT NULL,
`2` varchar(255) NOT NULL,
`3` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`4` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for exo_bank_log
-- ----------------------------
DROP TABLE IF EXISTS `exo_bank_log`;
CREATE TABLE `exo_bank_log` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`user_name` varchar(30) NOT NULL,
`money` int(20) NOT NULL,
`art` varchar(10) NOT NULL,
`time` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for fish_log
-- ----------------------------
DROP TABLE IF EXISTS `fish_log`;
CREATE TABLE `fish_log` (
`1` int(11) DEFAULT NULL,
`2` int(11) DEFAULT NULL,
`3` int(11) DEFAULT NULL,
`4` int(11) DEFAULT NULL,
`5` int(11) DEFAULT NULL,
`6` int(11) DEFAULT NULL,
`7` int(11) DEFAULT NULL,
`8` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;

-- ----------------------------
-- Table structure for gmhost
-- ----------------------------
DROP TABLE IF EXISTS `gmhost`;
CREATE TABLE `gmhost` (
`mIP` varchar(16) NOT NULL DEFAULT '',
PRIMARY KEY (`mIP`)
) ENGINE=MyISAM DEFAULT CHARSET=big5;

-- ----------------------------
-- Table structure for gmlist
-- ----------------------------
DROP TABLE IF EXISTS `gmlist`;
CREATE TABLE `gmlist` (
`mID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`mAccount` varchar(16) NOT NULL DEFAULT '',
`mName` varchar(16) NOT NULL DEFAULT '',
`mContactIP` varchar(16) NOT NULL DEFAULT '',
`mServerIP` varchar(16) NOT NULL DEFAULT 'ALL',
`mAuthority` enum('IMPLEMENTOR','HIGH_WIZARD','GOD','LOW_WIZARD','PLAYER') DEFAULT 'PLAYER',
PRIMARY KEY (`mID`)
) ENGINE=MyISAM DEFAULT CHARSET=big5;

-- ----------------------------
-- Table structure for goldlog
-- ----------------------------
DROP TABLE IF EXISTS `goldlog`;
CREATE TABLE `goldlog` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`date` date DEFAULT NULL,
`time` time DEFAULT NULL,
`pid` int(20) DEFAULT NULL,
`what` int(20) DEFAULT NULL,
`how` varchar(20) DEFAULT NULL,
`hint` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=21523 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for hack_crc_log
-- ----------------------------
DROP TABLE IF EXISTS `hack_crc_log`;
CREATE TABLE `hack_crc_log` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`time` datetime DEFAULT NULL,
`login` varchar(20) DEFAULT NULL,
`name` varchar(20) DEFAULT NULL,
`ip` varchar(30) DEFAULT NULL,
`server` int(20) DEFAULT NULL,
`why` varchar(20) DEFAULT NULL,
`crc` int(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for hack_log
-- ----------------------------
DROP TABLE IF EXISTS `hack_log`;
CREATE TABLE `hack_log` (
`time` time DEFAULT NULL,
`login` longtext COLLATE big5_bin,
`name` varchar(11) COLLATE big5_bin DEFAULT NULL,
`ip` text CHARACTER SET latin1,
`server` varchar(11) COLLATE big5_bin DEFAULT NULL,
`why` varchar(22) COLLATE big5_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;

-- ----------------------------
-- Table structure for hackshield_log
-- ----------------------------
DROP TABLE IF EXISTS `hackshield_log`;
CREATE TABLE `hackshield_log` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`time` datetime DEFAULT NULL,
`account_id` int(20) DEFAULT NULL,
`login` varchar(20) DEFAULT NULL,
`pid` int(20) DEFAULT NULL,
`name` varchar(20) DEFAULT NULL,
`reason` varchar(20) DEFAULT NULL,
`ip` varchar(30) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for ingame_ban_log
-- ----------------------------
DROP TABLE IF EXISTS `ingame_ban_log`;
CREATE TABLE `ingame_ban_log` (
`ban_time` datetime DEFAULT NULL,
`who` varchar(255) COLLATE big5_bin DEFAULT NULL,
`GM` varchar(255) COLLATE big5_bin DEFAULT NULL,
`cause` varchar(255) COLLATE big5_bin DEFAULT NULL,
`until` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;

-- ----------------------------
-- Table structure for levellog
-- ----------------------------
DROP TABLE IF EXISTS `levellog`;
CREATE TABLE `levellog` (
`name` varchar(50) COLLATE big5_bin DEFAULT NULL,
`level` int(11) DEFAULT NULL,
`time` time DEFAULT NULL,
`account_id` varchar(30) COLLATE big5_bin DEFAULT NULL,
`pid` varchar(30) COLLATE big5_bin DEFAULT NULL,
`playtime` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;

-- ----------------------------
-- Table structure for locale
-- ----------------------------
DROP TABLE IF EXISTS `locale`;
CREATE TABLE `locale` (
`mKey` varchar(255) NOT NULL DEFAULT '',
`mValue` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`mKey`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for locale_bug
-- ----------------------------
DROP TABLE IF EXISTS `locale_bug`;
CREATE TABLE `locale_bug` (
`mKey` varchar(255) NOT NULL DEFAULT '',
`mValue` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`mKey`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for log
-- ----------------------------
DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
`ID` int(11) DEFAULT NULL,
`type` varchar(20) COLLATE big5_bin DEFAULT NULL,
`time` datetime DEFAULT NULL,
`who` int(11) DEFAULT NULL,
`x` int(11) DEFAULT NULL,
`y` int(11) DEFAULT NULL,
`what` int(11) DEFAULT NULL,
`how` varchar(20) COLLATE big5_bin DEFAULT NULL,
`hint` varchar(20) COLLATE big5_bin DEFAULT NULL,
`ip` varchar(30) COLLATE big5_bin DEFAULT NULL,
`vnum` int(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;

-- ----------------------------
-- Table structure for loginlog
-- ----------------------------
DROP TABLE IF EXISTS `loginlog`;
CREATE TABLE `loginlog` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`type` text,
`time` datetime DEFAULT NULL,
`channel` int(20) DEFAULT NULL,
`account_id` int(20) DEFAULT NULL,
`pid` int(20) DEFAULT NULL,
`level` int(20) DEFAULT NULL,
`job` int(20) DEFAULT NULL,
`playtime` int(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for loginlog2
-- ----------------------------
DROP TABLE IF EXISTS `loginlog2`;
CREATE TABLE `loginlog2` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` text,
`is_gm` int(11) DEFAULT NULL,
`login_time` datetime DEFAULT NULL,
`channel` int(11) DEFAULT NULL,
`account_id` int(11) DEFAULT NULL,
`pid` int(11) DEFAULT NULL,
`client_version` text,
`ip` text,
`logout_time` datetime DEFAULT NULL,
`playtime` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=45918 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for money_log
-- ----------------------------
DROP TABLE IF EXISTS `money_log`;
CREATE TABLE `money_log` (
`time` datetime DEFAULT NULL,
`1` varchar(20) DEFAULT NULL,
`2` varchar(20) DEFAULT '0',
`3` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for pcbang_loginlog
-- ----------------------------
DROP TABLE IF EXISTS `pcbang_loginlog`;
CREATE TABLE `pcbang_loginlog` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`time` datetime DEFAULT NULL,
`pcbang_id` int(20) DEFAULT NULL,
`ip` varchar(30) DEFAULT NULL,
`pid` int(20) DEFAULT NULL,
`play_time` int(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for quest_reward_log
-- ----------------------------
DROP TABLE IF EXISTS `quest_reward_log`;
CREATE TABLE `quest_reward_log` (
`1` varchar(50) COLLATE big5_bin DEFAULT NULL,
`2` int(11) DEFAULT NULL,
`3` int(11) DEFAULT NULL,
`4` int(11) DEFAULT NULL,
`5` int(11) DEFAULT NULL,
`6` int(11) DEFAULT NULL,
`7` time DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;

-- ----------------------------
-- Table structure for refinelog
-- ----------------------------
DROP TABLE IF EXISTS `refinelog`;
CREATE TABLE `refinelog` (
`Id` int(11) DEFAULT NULL,
`pid` int(11) DEFAULT NULL,
`item_name` varchar(50) COLLATE big5_bin DEFAULT NULL,
`item_id` int(11) DEFAULT NULL,
`step` int(11) DEFAULT NULL,
`time` time DEFAULT NULL,
`is_success` int(11) DEFAULT NULL,
`setType` varchar(50) COLLATE big5_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;

-- ----------------------------
-- Table structure for shout_log
-- ----------------------------
DROP TABLE IF EXISTS `shout_log`;
CREATE TABLE `shout_log` (
`1` time DEFAULT NULL,
`2` int(11) DEFAULT NULL,
`3` int(11) DEFAULT NULL,
`4` varchar(400) COLLATE big5_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;

-- ----------------------------
-- Table structure for speed_hack
-- ----------------------------
DROP TABLE IF EXISTS `speed_hack`;
CREATE TABLE `speed_hack` (
`pid` int(11) DEFAULT NULL,
`time` time DEFAULT NULL,
`x` int(11) DEFAULT NULL,
`y` int(11) DEFAULT NULL,
`hack_count` varchar(20) COLLATE big5_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;

-- ----------------------------
-- Table structure for voucher_log
-- ----------------------------
DROP TABLE IF EXISTS `voucher_log`;
CREATE TABLE `voucher_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`account_id` int(10) unsigned NOT NULL,
`monede` int(10) unsigned NOT NULL,
`data` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for whisper_log
-- ----------------------------
DROP TABLE IF EXISTS `whisper_log`;
CREATE TABLE `whisper_log` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`from_msg` varchar(24) NOT NULL DEFAULT 'error',
`to_msg` varchar(24) NOT NULL DEFAULT 'error',
`msg_text` varchar(250) NOT NULL DEFAULT 'empty_msg_error',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=349498
[ Postat de pe Android ]

la mine e de la transmutatie asta cred, n ar trebui sa fie cv si de change look?

xAetees · 29 Iul 2019, 12:09

le am bagat dar tot apare in syserr, cum fac query singur pt transmutatie si scoatere transmutatie?

[ Postat de pe Android ] Imagine

xAetees · 30 Iul 2019, 08:46

up

[ Postat de pe Android ] Imagine

xAetees · 31 Iul 2019, 11:05

up

[ Postat de pe Android ] Imagine

xAetees · 01 Aug 2019, 14:50

up

[ Postat de pe Android ] Imagine

xAetees · 02 Aug 2019, 19:28

Sysser

Sysser

Sysser

Sysser DB

Sysser

Cine este conectat