40k log hiba mysql?

[laco1996]

Sziasztok Ezt a hibát hogy lehetne javitani? Logokban nem jelez semmilyen tevékenységet.
(Forrást használok)

Kód Kijelölés Kibont

SYSERR: Aug 19 23:27:01.459631 :: GetMoveMotionSpeed: cannot find motion (name tesztecske race 20019 mode 0)
SYSERR: Aug 19 23:27:01.738962 :: GetMoveMotionSpeed: cannot find motion (name tesztecske race 20019 mode 0)
SYSERR: Aug 19 23:27:02.59547 :: GetMoveMotionSpeed: cannot find motion (name tesztecske race 20019 mode 0)
SYSERR: Aug 19 23:27:02.381046 :: GetMoveMotionSpeed: cannot find motion (name tesztecske race 20019 mode 0)
SYSERR: Aug 19 23:27:02.660060 :: GetMoveMotionSpeed: cannot find motion (name tesztecske race 20019 mode 0)
SYSERR: Aug 19 23:27:02.981986 :: GetMoveMotionSpeed: cannot find motion (name tesztecske race 20019 mode 0)
SYSERR: Aug 19 23:27:07.706172 :: SpawnMob: SpawnMob: no mob data for vnum 1222
SYSERR: Aug 19 23:27:08.222418 :: 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 '" (userid, server, ip, port, username, command, date ) VALUES(68657, 999, '178.4' at line 1 (query: INSERT DELAYED INTO command_log" (userid, server, ip, port, username, command, date ) VALUES(68657, 999, '178.48.192.136', 1, 'tesztecske', 'm 20019', NOW())  errno: 1064)
SYSERR: Aug 19 23:27:10.861092 :: GetMoveMotionSpeed: cannot find motion (name tesztecske race 20019 mode 0)
SYSERR: Aug 19 23:27:17.711317 :: SpawnMob: SpawnMob: no mob data for vnum 1222
SYSERR: Aug 19 23:27:21.979709 :: GetMoveMotionSpeed: cannot find motion (name tesztecske race 20019 mode 0)
SYSERR: Aug 19 23:27:22.380000 :: GetMoveMotionSpeed: cannot find motion (name tesztecske race 20019 mode 0)
SYSERR: Aug 19 23:27:22.660951 :: GetMoveMotionSpeed: cannot find motion (name tesztecske race 20019 mode 0)
SYSERR: Aug 19 23:27:22.979902 :: GetMoveMotionSpeed: cannot find motion (name tesztecske race 20019 mode 0)
SYSERR: Aug 19 23:27:23.301145 :: GetMoveMotionSpeed: cannot find motion (name tesztecske race 20019 mode 0)
SYSERR: Aug 19 23:27:23.580767 :: GetMoveMotionSpeed: cannot find motion (name tesztecske race 20019 mode 0)
SYSERR: Aug 19 23:27:23.899416 :: GetMoveMotionSpeed: cannot find motion (name tesztecske race 20019 mode 0)
SYSERR: Aug 19 23:27:24.730401 :: GetMoveMotionSpeed: cannot find motion (name tesztecske race 20019 mode 0)
SYSERR: Aug 19 23:27:25.23437 :: GetMoveMotionSpeed: cannot find motion (name tesztecske race 20019 mode 0)
SYSERR: Aug 19 23:27:27.723507 :: SpawnMob: SpawnMob: no mob data for vnum 1222
SYSERR: Aug 19 23:27:29.859327 :: Select: wrong QUEST_SELECT request! : 68657
SYSERR: Aug 19 23:27:33.740127 :: 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(), 68657' at line 1 (query: INSERT DELAYED INTO log" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68657, 959861, 273943, 70000050, 'BUY', 'Vörös Ital(Nagy)', '178.48.192.136', 27003) errno: 1064)
SYSERR: Aug 19 23:27:34.940236 :: 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(), 68657' at line 1 (query: INSERT DELAYED INTO log" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68657, 959861, 273943, 70000051, 'BUY', 'Kék Ital(Nagy)', '178.48.192.136', 27006) errno: 1064)
SYSERR: Aug 19 23:27:36.100054 :: GetMoveMotionSpeed: cannot find motion (name tesztecske race 20019 mode 0)
SYSERR: Aug 19 23:27:36.420394 :: GetMoveMotionSpeed: cannot find motion (name tesztecske race 20019 mode 0)
SYSERR: Aug 19 23:27:36.717411 :: GetMoveMotionSpeed: cannot find motion (name tesztecske race 20019 mode 0)
SYSERR: Aug 19 23:27:37.22575 :: GetMoveMotionSpeed: cannot find motion (name tesztecske race 20019 mode 0)
SYSERR: Aug 19 23:27:37.341687 :: GetMoveMotionSpeed: cannot find motion (name tesztecske race 20019 mode 0)
SYSERR: Aug 19 23:27:37.715389 :: SpawnMob: SpawnMob: no mob data for vnum 1222
SYSERR: Aug 19 23:27:43.343026 :: 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 '" (userid, server, ip, port, username, command, date ) VALUES(68657, 999, '178.4' at line 1 (query: INSERT DELAYED INTO command_log" (userid, server, ip, port, username, command, date ) VALUES(68657, 999, '178.48.192.136', 1, 'tesztecske', 'poly 1', NOW())  errno: 1064)
SYSERR: Aug 19 23:27:45.942578 :: 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(), 68657,' at line 1 (query: INSERT DELAYED INTO log" (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68657, 960327, 273063, 0, 'WARP', 'tesztecske MapIdx 41 DestMapIdx0 DestX469300 DestY964200 Empire3', '178.48.192.136') errno: 1064)
SYSERR: Aug 19 23:27:45.942795 :: 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 '" (userid, server, ip, port, username, command, date ) VALUES(68657, 999, '178.4' at line 1 (query: INSERT DELAYED INTO command_log" (userid, server, ip, port, username, command, date ) VALUES(68657, 999, '178.48.192.136', 1, 'tesztecske', 'go a', NOW())  errno: 1064)
SYSERR: Aug 19 23:27:46.60464 :: 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(), 68657,' at line 1 (query: INSERT DELAYED INTO log" (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68657, 960327, 273063, 0, 'LOGOUT', '178.48.192.136 185873855 1 41 44069', '178.48.192.136') errno: 1064)
SYSERR: Aug 19 23:27:47.684995 :: SpawnMob: SpawnMob: no mob data for vnum 1222
SYSERR: Aug 19 23:27:47.752003 :: 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 '" WHERE account_id = 4' at line 1 (query: SELECT size FROM safebox" WHERE account_id = 4 errno: 1064)
SYSERR: Aug 19 23:27:47.752167 :: 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(), 68657,' at line 1 (query: INSERT DELAYED INTO log" (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68657, 469300, 964200, 6, 'GM_LOGIN', '', '178.48.192.136') errno: 1064)
SYSERR: Aug 19 23:27:47.752379 :: 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(), 68657,' at line 1 (query: INSERT DELAYED INTO log" (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68657, 469300, 964200, 0, 'LOGIN', '178.48.192.136 185873855 1 1 44069', '178.48.192.136') errno: 1064)
SYSERR: Aug 19 23:27:50.992862 :: 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 '" WHERE account='tesztecske'' at line 1 (query: SELECT account, companion FROM messenger_list" WHERE account='tesztecske' errno: 1064)
SYSERR: Aug 19 23:27:51.830968 :: 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 '" (userid, server, ip, port, username, command, date ) VALUES(68657, 999, '178.4' at line 1 (query: INSERT DELAYED INTO command_log" (userid, server, ip, port, username, command, date ) VALUES(68657, 999, '178.48.192.136', 1, 'tesztecske', 'r', NOW())  errno: 1064)
SYSERR: Aug 19 23:27:57.684841 :: SpawnMob: SpawnMob: no mob data for vnum 1222
SYSERR: Aug 19 23:27:59.351965 :: 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(), 2, 26' at line 1 (query: INSERT DELAYED INTO log" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2602, 0, 10003226, 'SET_SOCKET', '', '', 72702) errno: 1064)
SYSERR: Aug 19 23:28:07.687040 :: SpawnMob: SpawnMob: no mob data for vnum 1222
SYSERR: Aug 19 23:28:17.656889 :: SpawnMob: SpawnMob: no mob data for vnum 1222
SYSERR: Aug 19 23:28:27.646886 :: SpawnMob: SpawnMob: no mob data for vnum 1222
SYSERR: Aug 19 23:28:31.752995 :: 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(), 68657,' at line 1 (query: INSERT DELAYED INTO log" (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68657, 469651, 961717, 0, 'WARP', 'tesztecske MapIdx 1 DestMapIdx0 DestX969600 DestY278400 Empire3', '178.48.192.136') errno: 1064)
SYSERR: Aug 19 23:28:31.753399 :: 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 '" (userid, server, ip, port, username, command, date ) VALUES(68657, 999, '178.4' at line 1 (query: INSERT DELAYED INTO command_log" (userid, server, ip, port, username, command, date ) VALUES(68657, 999, '178.48.192.136', 1, 'tesztecske', 'go c', NOW())  errno: 1064)
SYSERR: Aug 19 23:28:31.873579 :: 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(), 68657,' at line 1 (query: INSERT DELAYED INTO log" (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68657, 469651, 961717, 0, 'LOGOUT', '178.48.192.136 185873855 1 1 44069', '178.48.192.136') errno: 1064)
SYSERR: Aug 19 23:28:32.365895 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: 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 '" WHERE pid1=68667 OR pid2=68667 OR pid3=68667 OR pid4=68667 AND empire=2' at line 1
query: SELECT id FROM player_index" WHERE pid1=68667 OR pid2=68667 OR pid3=68667 OR pid4=68667 AND empire=2
SYSERR: Aug 19 23:28:33.527045 :: 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(), 68657,' at line 1 (query: INSERT DELAYED INTO log" (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68657, 969600, 278400, 6, 'GM_LOGIN', '', '178.48.192.136') errno: 1064)
SYSERR: Aug 19 23:28:33.527326 :: 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 '" WHERE account_id = 4' at line 1 (query: SELECT size FROM safebox" WHERE account_id = 4 errno: 1064)
SYSERR: Aug 19 23:28:33.527460 :: 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(), 68657,' at line 1 (query: INSERT DELAYED INTO log" (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68657, 969600, 278400, 0, 'LOGIN', '178.48.192.136 185873855 1 41 44069', '178.48.192.136') errno: 1064)
SYSERR: Aug 19 23:28:36.368511 :: 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 '" WHERE account='tesztecske'' at line 1 (query: SELECT account, companion FROM messenger_list" WHERE account='tesztecske' errno: 1064)
SYSERR: Aug 19 23:28:36.613685 :: 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 '" (userid, server, ip, port, username, command, date ) VALUES(68657, 999, '178.4' at line 1 (query: INSERT DELAYED INTO command_log" (userid, server, ip, port, username, command, date ) VALUES(68657, 999, '178.48.192.136', 1, 'tesztecske', 'r', NOW())  errno: 1064)
SYSERR: Aug 19 23:28:37.611559 :: SpawnMob: SpawnMob: no mob data for vnum 1222
SYSERR: Aug 19 23:28:44.928457 :: 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(), 2, 30' at line 1 (query: INSERT DELAYED INTO log" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 3000, 0, 70000052, 'SET_SOCKET', '', '', 72702) errno: 1064)
SYSERR: Aug 19 23:28:44.928735 :: 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(), 68657' at line 1 (query: INSERT DELAYED INTO log" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68657, 968381, 277811, 70000052, 'GM', 'Szél cipõ+ (átadható)', '178.48.192.136', 72702) errno: 1064)
SYSERR: Aug 19 23:28:44.929071 :: 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 '" (userid, server, ip, port, username, command, date ) VALUES(68657, 999, '178.4' at line 1 (query: INSERT DELAYED INTO command_log" (userid, server, ip, port, username, command, date ) VALUES(68657, 999, '178.48.192.136', 1, 'tesztecske', 'i 72702', NOW())  errno: 1064)
SYSERR: Aug 19 23:28:47.567005 :: SpawnMob: SpawnMob: no mob data for vnum 1222
SYSERR: Aug 19 23:28:48.775180 :: 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(), 1, 0,' at line 1 (query: INSERT DELAYED INTO log" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 0, 0, 70000052, 'SET_SOCKET', '', '', 72702) errno: 1064)
SYSERR: Aug 19 23:28:57.525752 :: SpawnMob: SpawnMob: no mob data for vnum 1222
SYSERR: Aug 19 23:28:59.174670 :: 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(), 2, 26' at line 1 (query: INSERT DELAYED INTO log" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2601, 0, 10003226, 'SET_SOCKET', '', '', 72702) errno: 1064)
SYSERR: Aug 19 23:29:01.812295 :: 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 '" (userid, server, ip, port, username, command, date ) VALUES(68657, 999, '178.4' at line 1 (query: INSERT DELAYED INTO command_log" (userid, server, ip, port, username, command, date ) VALUES(68657, 999, '178.48.192.136', 1, 'tesztecske', 'in', NOW())  errno: 1064)
SYSERR: Aug 19 23:29:02.653440 :: 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 '" (userid, server, ip, port, username, command, date ) VALUES(68657, 999, '178.4' at line 1 (query: INSERT DELAYED INTO command_log" (userid, server, ip, port, username, command, date ) VALUES(68657, 999, '178.48.192.136', 1, 'tesztecske', 'in', NOW())  errno: 1064)

[fabtam11]

szal akkor ez most egy mount vagy egy pet vagy egy új karakterkaszt?

[laco1996]

Nem, hanem egy olyan Npc, amit nem találok egyáltalán a item_protoba. csak nemértem hogy hogy lehet, az hogy nincs benne az item_protoban. Illetve, egyáltalán semmit nem mutat a log, mármint a navicatban. se a shut_log log_log stb.. Ez miért van?  Azért idegesit, mert elég hamar megtelik a sysser.  Illetve lenne egy olyan problémám is hogy, felveszem  a kosztümöt akkor látszodik, de viszont a kis ablakban már nem, és nem is tudom levenni. Az is jó volt. milyen fájlokat tegyek bele hogy müködjön?

[fabtam11]

És item_tábla v item award_tábla teljes listanézetben ?
Forrással dolgozol?  Am mit módosítottál az idítóforrásban?

[laco1996]

Igen forrása. Sé mutatás kliensbe, nagyobb bolt, illetve pvp effectet tettem bele. De azok müködnek. Nem tudjuk beszélni faceen vagy skype?
Üzenet összefésülés: 2017-08-20, 10:38:45

Igen forrása. Sé mutatás kliensbe, nagyobb bolt, illetve pvp effectet tettem bele. De azok müködnek. Nem tudjuk beszélni faceen vagy skype?

Valaki legyen már szives segiteni nekem.. :S

[fabtam11]

Illetve lenne egy olyan problémám is hogy, felveszem  a kosztümöt akkor látszodik, de viszont a kis ablakban már nem, és nem is tudom levenni. Az is jó volt. milyen fájlokat tegyek bele hogy müködjön?

na várj a cosztümcuccot miért is buheráltad?  és honnan "tetted be a fájlokat" ahhoz a feléhez? (kosztümpanel rész)

Szerintem még írd le h pontosan milyen módosításokat csináltál mert konkrétan nem lettem okosabb a syserrnél.