Server Laggt

01/04/2015 16:16 slipknot009#1
Hey

Ich habe ein Problem das mein Server Lagt habe 6gb ram den Server gegeben und spiele ihn über Surakopf exe weil meine normale Starter exe erst sich garnicht aufmacht.

Ich habe auch auf der map 1 an den Häusern solche leichten verzerungen aber kp wieso aufjeden fal lagt der Server öfter rum.

Das sagt die Syserr:
Quote:
0104 16:04:24087 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 12249

0104 16:04:24088 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 12250

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13577

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13578

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13579

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13580

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13581

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13582

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13583

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13584

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13585

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13586

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13587

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13588

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13589

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13590

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13591

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13592

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13593

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13594

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13595

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13596

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13597

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13598

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13599

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13600

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13601

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13602

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13603

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13604

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13605

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13606

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13607

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13608

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13609

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13610

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13611

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13612

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13613

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13614

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13615

0104 16:04:24097 :: CItemManager::LoadItemList(locale/de/item_list.txt) - StrangeLine in 13616

0104 16:04:31036 :: 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.
0104 16:04:36346 :: Unknown Server Command HideKillGui | HideKillGui
0104 16:04:36393 :: Unknown Server Command normal_mall 69 | normal_mall
01/04/2015 16:36 Trip.#2
Das sieht stark nach SkyToastY Client aus :).
01/04/2015 16:57 slipknot009#3
Genau so sieht es aus kannst du mir bitte weiterhelfen?
01/04/2015 17:00 Samael#4
Fix erstmal deine item_list.txt in der locale_de. An sich sollten laags aber nicht daran liegen. Vll billig root? :awesome:

€: Sehe gerade.. Hamachi.. sagt alles.
01/04/2015 17:05 slipknot009#5
Ja gut wegen ( Hamachi sagt alles ) alle Server davor die ich hatte haben nicht gelaggt auf Hamachi ich habe die ja nur auf Hamachi laufen zum einstellen den überspiele ich sie auf root
Aber normaler weise dürfte es ja ingame trozdem nicht laggen macht es ja zB bei den daroo files auch nicht auf hamachi ^^
01/04/2015 17:06 Samael#6
Dann ist es doch klar. Hast dir buggy Files geholt. Wenn der SERVER laagt bringt uns deine Clientside sysrr ja auch nicht wirklich was. Dann brauchen wir die channel1 sysrr.
01/04/2015 17:14 slipknot009#7
das steht in der channel 1 syserr

Quote:
SYSERR: Jan 4 15:24:21 :: regen_load: No mob data by vnum 10098
SYSERR: Jan 4 15:24:21 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: boar have not motlist.txt vnum(20110) folder(boar)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: boar have not motlist.txt vnum(20110) folder(boar)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: boar have not motlist.txt vnum(20110) folder(boar)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: dog_god have not motlist.txt vnum(20111) folder(dog_god)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: dog_god have not motlist.txt vnum(20111) folder(dog_god)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: dog_god have not motlist.txt vnum(20111) folder(dog_god)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: lion have not motlist.txt vnum(20113) folder(lion)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: lion have not motlist.txt vnum(20113) folder(lion)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: lion have not motlist.txt vnum(20113) folder(lion)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: mino_mount have not motlist.txt vnum(20114) folder(mino_mount)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: mino_mount have not motlist.txt vnum(20114) folder(mino_mount)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: mino_mount have not motlist.txt vnum(20114) folder(mino_mount)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: boar_2 have not motlist.txt vnum(20115) folder(boar_2)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: boar_2 have not motlist.txt vnum(20115) folder(boar_2)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: boar_2 have not motlist.txt vnum(20115) folder(boar_2)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: dog_god_2 have not motlist.txt vnum(20116) folder(dog_god_2)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: dog_god_2 have not motlist.txt vnum(20116) folder(dog_god_2)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: dog_god_2 have not motlist.txt vnum(20116) folder(dog_god_2)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: fire_tiger_2 have not motlist.txt vnum(20117) folder(fire_tiger_2)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: fire_tiger_2 have not motlist.txt vnum(20117) folder(fire_tiger_2)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: fire_tiger_2 have not motlist.txt vnum(20117) folder(fire_tiger_2)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: lion_2 have not motlist.txt vnum(20118) folder(lion_2)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: lion_2 have not motlist.txt vnum(20118) folder(lion_2)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: lion_2 have not motlist.txt vnum(20118) folder(lion_2)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: lion have not motlist.txt vnum(20146) folder(lion)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: lion have not motlist.txt vnum(20146) folder(lion)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: lion have not motlist.txt vnum(20146) folder(lion)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: lion have not motlist.txt vnum(20147) folder(lion)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: lion have not motlist.txt vnum(20147) folder(lion)
SYSERR: Jan 4 15:24:26 :: GetMotionFileName: Motion: lion have not motlist.txt vnum(20147) folder(lion)
SYSERR: Jan 4 15:25:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:26:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:27:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:28:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:29:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:30:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:31:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:32:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:33:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:34:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:35:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:36:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:37:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:38:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:39:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:40:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:41:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:42:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:43:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:44:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:45:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:46:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:47:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:48:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:49:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:50:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:51:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:52:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:53:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:54:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:55:16 :: ItemLoad: cannot create item by vnum 5 (name [SA]SkytoastY id 10103498)
SYSERR: Jan 4 15:55:16 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 58020, 960348, 272159, 5, 'GM_LOGIN', '', '25.143.174.253') errno: 1054)
SYSERR: Jan 4 15:55:16 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 58020, 960348, 272159, 0, 'LOGIN', '25.143.174.253 1413307650 1 41 200000', '25.143.174.253') errno: 1054)
SYSERR: Jan 4 15:55:16 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 123456789, 58020, inet_aton('25.143.174.253'), '') errno: 1146)
SYSERR: Jan 4 15:55:16 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 0, 0, 10126917, 'SET_SOCKET', '', '', 72702) errno: 1054)
SYSERR: Jan 4 15:55:16 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 0, 0, 30036620, 'SET_SOCKET', '', '', 71011) errno: 1054)
SYSERR: Jan 4 15:55:25 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(58020, 999, '25.143.174.253', 1, '[SA]SkytoastY', 'n [SA]SkytoastY ist Online', NOW()) errno: 1146)
SYSERR: Jan 4 15:55:25 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(58020, 999, '25.143.174.253', 1, '[SA]SkytoastY', 'n Er ist nun f? eure Fragen verf?bar.', NOW()) errno: 1146)
SYSERR: Jan 4 15:55:25 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(58020, 999, '25.143.174.253', 1, '[SA]SkytoastY', 'priv 0 4 1000 123', NOW()) errno: 1146)
SYSERR: Jan 4 15:55:25 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(58020, 999, '25.143.174.253', 1, '[SA]SkytoastY', 'priv 0 2 1000 123', NOW()) errno: 1146)
SYSERR: Jan 4 15:55:25 :: _find_npc_by_vnum: invalid argument
SYSERR: Jan 4 15:55:25 :: _find_npc_by_vnum: invalid argument
SYSERR: Jan 4 15:55:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:55:45 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2285, 0, 10126917, 'SET_SOCKET', '', '', 72702) errno: 1054)
SYSERR: Jan 4 15:56:16 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 58020, 960283, 269989, 30036620, 'UNIQUE_EXPIRE', 'Emotionsmaske 1 ', '25.143.174.253', 71011) errno: 1054)
SYSERR: Jan 4 15:56:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:56:45 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2284, 0, 10126917, 'SET_SOCKET', '', '', 72702) errno: 1054)
SYSERR: Jan 4 15:57:18 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: SET @i = (SELECT MAX(id) FROM loginlog2 WHERE account_id=123456789 AND pid=58020) errno: 1146)
SYSERR: Jan 4 15:57:18 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: UPDATE loginlog2 SET type='VALID', logout_time=NOW(), playtime=TIMEDIFF(logout_time,login_time) WHERE id=@i errno: 1146)
SYSERR: Jan 4 15:57:19 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 58020, 959296, 269645, 0, 'LOGOUT', '', '25.143.174.253') errno: 1054)
SYSERR: Jan 4 15:57:19 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 26, 0, 10126917, 'SET_SOCKET', '', '', 72702) errno: 1054)
SYSERR: Jan 4 15:57:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:58:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 15:59:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:00:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:01:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:01:26 :: ItemLoad: cannot create item by vnum 5 (name [SA]SkytoastY id 10103498)
SYSERR: Jan 4 16:01:26 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 58020, 959296, 269645, 5, 'GM_LOGIN', '', '25.143.174.253') errno: 1054)
SYSERR: Jan 4 16:01:26 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 58020, 959296, 269645, 0, 'LOGIN', '25.143.174.253 1413307650 1 41 200000', '25.143.174.253') errno: 1054)
SYSERR: Jan 4 16:01:26 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 123456789, 58020, inet_aton('25.143.174.253'), '') errno: 1146)
SYSERR: Jan 4 16:01:26 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 0, 0, 10126917, 'SET_SOCKET', '', '', 72702) errno: 1054)
SYSERR: Jan 4 16:01:32 :: _find_npc_by_vnum: invalid argument
SYSERR: Jan 4 16:01:32 :: _find_npc_by_vnum: invalid argument
SYSERR: Jan 4 16:01:32 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(58020, 999, '25.143.174.253', 1, '[SA]SkytoastY', 'n [SA]SkytoastY ist Online', NOW()) errno: 1146)
SYSERR: Jan 4 16:01:32 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(58020, 999, '25.143.174.253', 1, '[SA]SkytoastY', 'n Er ist nun f? eure Fragen verf?bar.', NOW()) errno: 1146)
SYSERR: Jan 4 16:01:32 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(58020, 999, '25.143.174.253', 1, '[SA]SkytoastY', 'priv 0 4 1000 123', NOW()) errno: 1146)
SYSERR: Jan 4 16:01:32 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(58020, 999, '25.143.174.253', 1, '[SA]SkytoastY', 'priv 0 2 1000 123', NOW()) errno: 1146)
SYSERR: Jan 4 16:01:52 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2283, 0, 10126917, 'SET_SOCKET', '', '', 72702) errno: 1054)
SYSERR: Jan 4 16:02:01 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: SET @i = (SELECT MAX(id) FROM loginlog2 WHERE account_id=123456789 AND pid=58020) errno: 1146)
SYSERR: Jan 4 16:02:01 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: UPDATE loginlog2 SET type='VALID', logout_time=NOW(), playtime=TIMEDIFF(logout_time,login_time) WHERE id=@i errno: 1146)
SYSERR: Jan 4 16:02:02 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 58020, 959516, 269736, 0, 'LOGOUT', '', '25.143.174.253') errno: 1054)
SYSERR: Jan 4 16:02:02 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 50, 0, 10126917, 'SET_SOCKET', '', '', 72702) errno: 1054)
SYSERR: Jan 4 16:02:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:03:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:04:11 :: ItemLoad: cannot create item by vnum 5 (name [SA]SkytoastY id 10103498)
SYSERR: Jan 4 16:04:11 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 58020, 959516, 269736, 5, 'GM_LOGIN', '', '25.143.174.253') errno: 1054)
SYSERR: Jan 4 16:04:11 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 58020, 959516, 269736, 0, 'LOGIN', '25.143.174.253 1413307650 1 41 200000', '25.143.174.253') errno: 1054)
SYSERR: Jan 4 16:04:11 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 123456789, 58020, inet_aton('25.143.174.253'), '') errno: 1146)
SYSERR: Jan 4 16:04:11 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 0, 0, 10126917, 'SET_SOCKET', '', '', 72702) errno: 1054)
SYSERR: Jan 4 16:04:17 :: _find_npc_by_vnum: invalid argument
SYSERR: Jan 4 16:04:17 :: _find_npc_by_vnum: invalid argument
SYSERR: Jan 4 16:04:17 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(58020, 999, '25.143.174.253', 1, '[SA]SkytoastY', 'n [SA]SkytoastY ist Online', NOW()) errno: 1146)
SYSERR: Jan 4 16:04:17 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(58020, 999, '25.143.174.253', 1, '[SA]SkytoastY', 'n Er ist nun f? eure Fragen verf?bar.', NOW()) errno: 1146)
SYSERR: Jan 4 16:04:17 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(58020, 999, '25.143.174.253', 1, '[SA]SkytoastY', 'priv 0 4 1000 123', NOW()) errno: 1146)
SYSERR: Jan 4 16:04:17 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(58020, 999, '25.143.174.253', 1, '[SA]SkytoastY', 'priv 0 2 1000 123', NOW()) errno: 1146)
SYSERR: Jan 4 16:04:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:05:01 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2282, 0, 10126917, 'SET_SOCKET', '', '', 72702) errno: 1054)
SYSERR: Jan 4 16:05:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:06:01 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2281, 0, 10126917, 'SET_SOCKET', '', '', 72702) errno: 1054)
SYSERR: Jan 4 16:06:16 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: SET @i = (SELECT MAX(id) FROM loginlog2 WHERE account_id=123456789 AND pid=58020) errno: 1146)
SYSERR: Jan 4 16:06:16 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: UPDATE loginlog2 SET type='VALID', logout_time=NOW(), playtime=TIMEDIFF(logout_time,login_time) WHERE id=@i errno: 1146)
SYSERR: Jan 4 16:06:16 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 58020, 959272, 269330, 0, 'LOGOUT', '', '25.143.174.253') errno: 1054)
SYSERR: Jan 4 16:06:16 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 44, 0, 10126917, 'SET_SOCKET', '', '', 72702) errno: 1054)
SYSERR: Jan 4 16:06:25 :: ItemLoad: cannot create item by vnum 5 (name [SA]SkytoastY id 10103498)
SYSERR: Jan 4 16:06:25 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 58020, 959272, 269330, 5, 'GM_LOGIN', '', '25.143.174.253') errno: 1054)
SYSERR: Jan 4 16:06:25 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 58020, 959272, 269330, 0, 'LOGIN', '25.143.174.253 1413307650 1 41 200000', '25.143.174.253') errno: 1054)
SYSERR: Jan 4 16:06:25 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 123456789, 58020, inet_aton('25.143.174.253'), '') errno: 1146)
SYSERR: Jan 4 16:06:25 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 0, 0, 10126917, 'SET_SOCKET', '', '', 72702) errno: 1054)
SYSERR: Jan 4 16:06:26 :: _find_npc_by_vnum: invalid argument
SYSERR: Jan 4 16:06:26 :: _find_npc_by_vnum: invalid argument
SYSERR: Jan 4 16:06:26 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(58020, 999, '25.143.174.253', 1, '[SA]SkytoastY', 'n [SA]SkytoastY ist Online', NOW()) errno: 1146)
SYSERR: Jan 4 16:06:26 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(58020, 999, '25.143.174.253', 1, '[SA]SkytoastY', 'n Er ist nun f? eure Fragen verf?bar.', NOW()) errno: 1146)
SYSERR: Jan 4 16:06:26 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(58020, 999, '25.143.174.253', 1, '[SA]SkytoastY', 'priv 0 4 1000 123', NOW()) errno: 1146)
SYSERR: Jan 4 16:06:26 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(58020, 999, '25.143.174.253', 1, '[SA]SkytoastY', 'priv 0 2 1000 123', NOW()) errno: 1146)
SYSERR: Jan 4 16:06:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:07:09 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2280, 0, 10126917, 'SET_SOCKET', '', '', 72702) errno: 1054)
SYSERR: Jan 4 16:07:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:07:32 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: SET @i = (SELECT MAX(id) FROM loginlog2 WHERE account_id=123456789 AND pid=58020) errno: 1146)
SYSERR: Jan 4 16:07:32 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: UPDATE loginlog2 SET type='VALID', logout_time=NOW(), playtime=TIMEDIFF(logout_time,login_time) WHERE id=@i errno: 1146)
SYSERR: Jan 4 16:07:33 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 58020, 959177, 270401, 0, 'LOGOUT', '', '25.143.174.253') errno: 1054)
SYSERR: Jan 4 16:07:33 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 35, 0, 10126917, 'SET_SOCKET', '', '', 72702) errno: 1054)
SYSERR: Jan 4 16:08:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:09:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:10:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:11:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:12:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:13:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:14:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:15:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:16:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:17:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:18:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:19:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:20:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:21:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:22:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:23:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:24:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:25:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:26:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:27:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:28:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:29:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:30:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:31:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:32:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:33:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:34:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:35:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:36:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:37:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:38:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:39:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:40:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:41:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:42:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:43:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:44:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:45:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:46:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:47:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:48:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:49:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:50:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:51:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:52:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:53:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:54:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:55:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:56:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:57:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:58:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 16:59:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 17:00:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 17:01:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 17:02:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 17:03:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 17:04:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 17:05:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 17:06:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
SYSERR: Jan 4 17:07:26 :: SpawnMob: SpawnMob: no mob data for vnum 10098
01/04/2015 17:19 Samael#8
Das ist hart.

1. deine regen.txt in einer map versucht die nummer 10098 zu spawnen die es in mob_proto nichtmehr gibt. Füg diese nummer mal als mob hinzu !

2. deine ganzen log tabellen sind im *rsch.

3. number_ex: number(): first argument is bigger than second argument 897 -> 878, irgendwo ist _min größer als _max. zb Mob_proto is gold_min höher eingestellt als gold_max. Such diese 2 zahlen da und schau wo dies der fall ist und korrigiere es !

4. ganz wichtig: hol dir aus unbuggy files richtige log tabellen raus !

ich lad dir mal die command_log hoch. Sie ist im anhang.
01/04/2015 17:37 slipknot009#9
So habe alles gemacht bis auf die Command log wo kam die nochmal rein?
01/04/2015 17:53 Samael#10
Quote:
Originally Posted by slipknot009 View Post
So habe alles gemacht bis auf die Command log wo kam die nochmal rein?

log -> rechtsklick auf log -> execute sql file -> command_log.sql von mir executen und dann rebooten.
01/04/2015 18:11 slipknot009#11
habe das alles so gemacht wie gesagt jetzt bekomme ich immer kick beim einlogen mit folgenden

Syserr client s:

Quote:
0104 18:08:09082 :: CPythonNonPlayer::LoadNonPlayerData: invalid size 307380 check data format.
0104 18:08:09082 :: LoadLocaleData - LoadMobProto(locale/de/mob_proto) Error
0104 18:08:16808 :: 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.
0104 18:09:21090 ::
game.py(line:221) Open
game.py(line:612) StartGame
game.py(line:755) RefreshCharacter
interfaceModule.py(line:503) RefreshCharacter
uiCharacter.py(line:1111) RefreshCharacter
uiCharacter.py(line:1156) __SetSkillSlotData
uiCharacter.py(line:853) RefreshSkill
uiCharacter.py(line:828) __RefreshSkillPage

GameWindow.Open - exceptions.RuntimeError:skill.GetSkillType - Failed to find skill by 46

0104 18:09:21090 :: ================================================== ================================================== ========
0104 18:09:21090 :: Abort!!!!
01/04/2015 19:22 Samael#12
Code:
0104 18:08:09082 :: LoadLocaleData - LoadMobProto(locale/de/mob_proto) Error
Mob proto in locale/de/ ist kaputt oder nicht mehr vorhanden.

Code:
0104 18:09:21090 :: 
game.py(line:221) Open
game.py(line:612) StartGame
game.py(line:755) RefreshCharacter
interfaceModule.py(line:503) RefreshCharacter
uiCharacter.py(line:1111) RefreshCharacter
uiCharacter.py(line:1156) __SetSkillSlotData
uiCharacter.py(line:853) RefreshSkill
uiCharacter.py(line:828) __RefreshSkillPage

GameWindow.Open - exceptions.RuntimeError:skill.GetSkillType - Failed to find skill by 46
ka.. hat nix mit meinen sachen zutun daher weis ichs nicht