[SUCHE HILFE] Server Fehler beheben.

9TAILS · 04/22/2013, 16:48

Hey liebe Community,

bei mir sagt der Auth Server:

Auth:

PHP Code:


			
SYSERR: Apr 22 14:34:33 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 22 14:34:36 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 22 14:34:39 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 22 14:34:42 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 22 14:34:45 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 22 14:34:48 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 22 14:34:51 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 22 14:34:54 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 22 14:34:57 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 22 14:35:00 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 22 14:35:00 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Apr 22 14:35:00 :: socket_block: fcntl: nonblock: Bad file descriptor
SYSERR: Apr 22 14:43:40 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 22 14:48:42 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Apr 22 14:49:45 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 22 14:51:34 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Apr 22 14:54:17 :: socket_connect: HOST localhost:15000, could not connect.

Die DB sagt:

DB:

PHP Code:


			
SYSERR: Apr 22 14:43:40 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Apr 22 14:43:42 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Apr 22 14:43:42 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Apr 22 14:48:42 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Apr 22 14:49:45 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Apr 22 14:49:47 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Apr 22 14:49:47 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Apr 22 14:51:34 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Apr 22 14:54:17 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Apr 22 14:54:19 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Apr 22 14:54:19 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)

Alle Channels sagen das gleiche. Hier mal Channel 1

Channel1:

PHP Code:


			
SYSERR: Apr 22 14:34:34 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 22 14:34:37 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 22 14:34:40 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 22 14:34:43 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 22 14:34:46 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 22 14:34:49 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 22 14:34:52 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 22 14:34:55 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 22 14:34:58 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 22 14:35:00 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Apr 22 14:35:00 :: socket_block: fcntl: nonblock: Bad file descriptor
SYSERR: Apr 22 14:43:41 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 22 14:44:18 :: heart_idle: losing 33 seconds. (lag occured)
SYSERR: Apr 22 14:48:42 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Apr 22 14:49:46 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 22 14:50:34 :: heart_idle: losing 44 seconds. (lag occured)
SYSERR: Apr 22 14:51:34 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Apr 22 14:54:18 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Apr 22 14:54:53 :: heart_idle: losing 30 seconds. (lag occured)

ich suche wirklich jemanden der mir dabei hilft diese Fehler ein für alle mal zu beheben.

Als Belohnung würde ich dem jenigen eine 25 Euro PSC anbieten.

Mfg Tomchen Jessel

Spartan#117 · 04/22/2013, 17:32

Hi!

Es scheint, als würde irgendwas mit dem DB-Core nicht stimmen, da die Gamecores & der Authcore sich nicht mit dem DB-Core verbinden können.

Code:

socket_connect: HOST localhost:15000, could not connect.

Jedoch kann dieses Problem sehr viele Ursachen haben, um das ganze einzugrenzen, poste bitte diese Informationen:

Welche Serverfiles benutzt du bzw. auf welchen sind deine Serverfiles aufgebaut?
Versionen der db- und der game-Datei
Poste die CONFIG des DB-Cores

Dazu könntest du noch diese beiden Befehle ausführen und die Ausgabe posten / anängen:

Code:

sockstat -4 -l

Code:

ps auxww

Achtung: Die beiden Befehle ausführen, nachdem du den Server gestartet hast! (bzw. es versuchst, falls er nicht startet)

Der erste Befehl listet alle lauschenden Socketverbindungen auf, der zweite zeigt Informationen zu allen laufenden Prozessen.

9TAILS · 04/22/2013, 18:23

Quote:
Originally Posted by Spartan#117
Hi!

Es scheint, als würde irgendwas mit dem DB-Core nicht stimmen, da die Gamecores & der Authcore sich nicht mit dem DB-Core verbinden können.
Code:
socket_connect: HOST localhost:15000, could not connect.
Jedoch kann dieses Problem sehr viele Ursachen haben, um das ganze einzugrenzen, poste bitte diese Informationen:
Welche Serverfiles benutzt du bzw. auf welchen sind deine Serverfiles aufgebaut?

Versionen der db- und der game-Datei

Poste die CONFIG des DB-Cores

Dazu könntest du noch diese beiden Befehle ausführen und die Ausgabe posten / anängen:
Code:
sockstat -4 -l
Code:
ps auxww
Achtung: Die beiden Befehle ausführen, nachdem du den Server gestartet hast! (bzw. es versuchst, falls er nicht startet)

Der erste Befehl listet alle lauschenden Socketverbindungen auf, der zweite zeigt Informationen zu allen laufenden Prozessen.

Hey, ich hab keine DB.core hab nur eine Datei namens DB.
Meine FLies sind auf den daroo flies aufgebaucht.
hier die DB.config:

PHP Code:


			
WELCOME_MSG = "DB Server has been started"



SQL_ACCOUNT = "localhost account m2user m2pass@# 0"

SQL_PLAYER = "localhost player m2user m2pass@# 0"

SQL_COMMON = "localhost common m2user m2pass@# 0"

SQL_HOTBACKUP = "localhost hotbackup m2user m2pass@# 0"



TABLE_POSTFIX = ""



BIND_PORT               = 15000

DB_SLEEP_MSEC           = 10

CLIENT_HEART_FPS        = 10

HASH_PLAYER_LIFE_SEC    = 600

BACKUP_LIMIT_SEC        = 3600

PLAYER_ID_START = 100

PLAYER_DELETE_LEVEL_LIMIT = 70

PLAYER_DELETE_CHECK_SIMPLE = 1



ITEM_ID_RANGE = 2000000000 2100000000



MIN_LENGTH_OF_SOCIAL_ID    = 6



#NAME_COLUMN = "gb2312name"

#LOCALE = "gb2312"

SIMPLE_SOCIALID = 1

Block "Y/QSB7omi36awq4ctpUxuiwRARM="

es wäre viel besser wenn du dir meinen server mal z.B per team viwer ankucken könntest wenn du mal Zeit hast.

iFrost. · 04/22/2013, 18:30

Also in meinem Server steht das drine

Spoiler

Das was in dem Spoiler Rot ist, ist anderst kannst es ja mal so versuchen ^^

9TAILS · 04/22/2013, 18:52

Quote:

Originally Posted by LikeExchange

Also in meinem Server steht das drine

Spoiler

WELCOME_MSG = "DB Server has been started"

SQL_ACCOUNT = "localhost account m2user m2pass@# 0"
SQL_PLAYER = "localhost player m2user m2pass@# 0"
SQL_COMMON = "localhost common m2user m2pass@# 0"
SQL_HOTBACKUP = "localhost hotbackup m2user m2pass@# 0"

TABLE_POSTFIX = ""

BIND_PORT = 15000
DB_SLEEP_MSEC = 10
CLIENT_HEART_FPS = 10
HASH_PLAYER_LIFE_SEC = 600
BACKUP_LIMIT_SEC = 3600
PLAYER_ID_START = 100
PLAYER_DELETE_LEVEL_LIMIT = 70
PLAYER_DELETE_CHECK_SIMPLE = 1

ITEM_ID_RANGE = 2000000000 2500000000

MIN_LENGTH_OF_SOCIAL_ID = 6

#NAME_COLUMN = "gb2312name"
#LOCALE = "gb2312"
SIMPLE_SOCIALID = 1
Block "Y/QSB7omi36awq4ctpUxuiwRARM="

Das was in dem Spoiler Rot ist, ist anderst kannst es ja mal so versuchen ^^

leider nein .. :P

Spartan#117 · 04/22/2013, 20:38

Ich kenne mich leider nicht mit den Daroo Files aus, aber wenn du möchtest kannst du mir die Daten per PN senden und ich schaue mir das an.

Die conf.txt sieht okay aus, bis auf die letzte Zeile.

Code:

Block "Y/QSB7omi36awq4ctpUxuiwRARM="

Was bewirkt diese Konstante?

9TAILS · 04/24/2013, 20:29

Thema kann geschlossen werden, alle Fehler wurden erfolgreich behoben.

Mit freundliche Grüßen Tomche Jessel

» Kamaru « · 06/03/2013, 23:59

Hallo com,

ich weiß das die Frage schon vor ner Weile geöffnet und gelöst wurde nur es scheint so als hätte ich ein ähnliches Problem wie saver345.
Server startet ohne Fehlermeldungen beim Einloggen mit einem falschen Daten kommt "Accountname oder PW falsch" und bei richtigen Daten des Acc's "Fehler beim Verbinden mit dem Server" Pong stimmt clientside & Serverside überein
Habe auch die daroo 1678 files & 1678er Clienten

Syserr - auth

Spoiler

Syserr - db

Spoiler

Code:

SYSERR: Jun  1 00:10:00 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jun  1 00:10:02 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Jun  1 00:10:02 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Jun  2 19:45:58 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jun  2 19:46:00 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Jun  2 19:46:00 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Jun  2 19:46:05 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Jun  2 19:46:05 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Jun  3 22:39:29 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jun  3 22:39:30 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Jun  3 22:39:30 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Jun  3 22:39:34 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Jun  3 22:39:34 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Jun  3 22:45:59 :: ChildLoop: AsyncSQL: query failed: Query execution was interrupted (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 1317)
SYSERR: Jun  3 22:46:02 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jun  3 22:46:44 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jun  3 22:46:44 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Jun  3 22:46:44 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Jun  3 22:46:48 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Jun  3 22:46:48 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Jun  3 23:26:09 :: ChildLoop: AsyncSQL: query failed: Query execution was interrupted (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 1317)
SYSERR: Jun  3 23:26:11 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jun  3 23:26:54 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jun  3 23:26:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Jun  3 23:26:55 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Jun  3 23:26:58 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Jun  3 23:26:59 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Jun  3 23:35:14 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Jun  3 23:35:14 :: ChildLoop: AsyncSQL: retrying
SYSERR: Jun  3 23:35:15 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jun  3 23:35:57 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jun  3 23:35:58 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Jun  3 23:35:58 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Jun  3 23:36:01 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Jun  3 23:36:02 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Jun  3 23:39:37 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Jun  3 23:39:37 :: ChildLoop: AsyncSQL: retrying
SYSERR: Jun  3 23:39:37 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jun  3 23:40:16 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jun  3 23:40:16 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Jun  3 23:40:17 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Jun  3 23:40:19 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Jun  3 23:40:21 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Jun  3 23:42:15 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jun  3 23:42:56 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jun  3 23:42:57 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Jun  3 23:42:57 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Jun  3 23:42:59 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Jun  3 23:43:00 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Jun  3 23:43:00 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Jun  3 23:43:01 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Jun  3 23:50:16 :: ChildLoop: AsyncSQL: query failed: Query execution was interrupted (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 1317)
SYSERR: Jun  3 23:50:18 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jun  3 23:50:58 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jun  3 23:50:59 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Jun  3 23:50:59 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Jun  3 23:51:02 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Jun  3 23:51:03 :: Process: FDWATCH: peer null in event: ident 21

Syserr - channel1

Spoiler

Code:

SYSERR: Jun  1 00:54:39 :: GetPoint: POINT_ERROR: [GA]Kamaru type 1000 val 50 (max: 1006390368)
SYSERR: Jun  1 00:54:39 :: GetPoint: POINT_ERROR: [GA]Kamaru type 1000 val 50 (max: -1077955032)
SYSERR: Jun  1 00:54:39 :: 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(), 57701, 62638, 167289, 5, 'GM_LOGIN', '', '25.6.20.192') errno: 1054)
SYSERR: Jun  1 00:54:39 :: 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(), 57701, 62638, 167289, 0, 'LOGIN', '25.6.20.192 979891061 1 21 200000', '25.6.20.192') errno: 1054)
SYSERR: Jun  1 00:54:39 :: 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, 1, 57701, inet_aton('25.6.20.192'), '') errno: 1146)
SYSERR: Jun  1 00: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(), 0, 13, 2, 30000109, 'SET_ATTR', '', '', 10) errno: 1054)
SYSERR: Jun  1 00: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, 19, 10, 30000109, 'SET_ATTR', '', '', 10) errno: 1054)
SYSERR: Jun  1 00: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(), 0, 1, 0, 30000109, 'SET_SOCKET', '', '', 10) errno: 1054)
SYSERR: Jun  1 00: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(), 57701, 60907, 169226, 30000109, 'GM', 'Schwert+0', '25.6.20.192', 10) errno: 1054)
SYSERR: Jun  1 00:55:16 :: 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(57701, 999, '25.6.20.192', 1, '[GA]Kamaru', 'i 10', NOW())  errno: 1146)
SYSERR: Jun  1 00:55:28 :: GetPoint: POINT_ERROR: [GA]Kamaru type 1000 val 50 (max: 1006388312)
SYSERR: Jun  1 00:55:28 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: SET @i = (SELECT MAX(id) FROM loginlog2 WHERE account_id=1 AND pid=57701) errno: 1146)
SYSERR: Jun  1 00:55:28 :: 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: Jun  1 00:55:28 :: 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(), 57701, 61930, 166783, 0, 'LOGOUT', '', '25.6.20.192') errno: 1054)
SYSERR: Jun  1 00:55:34 :: ItemLoad: cannot create item by vnum 28600 (name [GA]Kamaru id 10000186)
SYSERR: Jun  1 00:55:34 :: PointChange: MALL_BONUS exceeded over 100!! point type: 116 name: [GA]Kamaru amount 23000
SYSERR: Jun  1 00:55:34 :: GetPoint: POINT_ERROR: [GA]Kamaru type 1000 val 50 (max: 1006640272)
SYSERR: Jun  1 00:55:34 :: GetPoint: POINT_ERROR: [GA]Kamaru type 1000 val 50 (max: -1077955032)
SYSERR: Jun  1 00:55:34 :: 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(), 57701, 61930, 166783, 5, 'GM_LOGIN', '', '25.6.20.192') errno: 1054)
SYSERR: Jun  1 00:55:34 :: 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(), 57701, 61930, 166783, 0, 'LOGIN', '25.6.20.192 979891061 1 21 200000', '25.6.20.192') errno: 1054)
SYSERR: Jun  1 00:55:34 :: 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, 1, 57701, inet_aton('25.6.20.192'), '') errno: 1146)
SYSERR: Jun  1 00:55:46 :: 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(57701, 999, '25.6.20.192', 1, '[GA]Kamaru', 'm 20016', NOW())  errno: 1146)
SYSERR: Jun  1 00:56:07 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: SET @i = (SELECT MAX(id) FROM loginlog2 WHERE account_id=1 AND pid=57701) errno: 1146)
SYSERR: Jun  1 00:56:07 :: 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: Jun  1 00:56:07 :: GetPoint: POINT_ERROR: [GA]Kamaru type 1000 val 50 (max: -234881024)
SYSERR: Jun  1 00:56:07 :: 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(), 57701, 61893, 166796, 0, 'LOGOUT', '', '25.6.20.192') errno: 1054)
SYSERR: Jun  2 19:45:59 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun  2 19:46:04 :: ReadSpecialDropItemFile: ReadSpecialDropItemFile : there is no item 13202 : node ҝeڸٰܳZ+
SYSERR: Jun  2 19:46:04 :: Boot: cannot load SpecialItemGroup: locale/germany/special_item_group.txt
SYSERR: Jun  3 22:39:30 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun  3 22:39:33 :: ReadSpecialDropItemFile: ReadSpecialDropItemFile : there is no item 13202 : node ҝeڸٰܳZ+
SYSERR: Jun  3 22:39:33 :: Boot: cannot load SpecialItemGroup: locale/germany/special_item_group.txt
SYSERR: Jun  3 22:46:47 :: ReadSpecialDropItemFile: ReadSpecialDropItemFile : there is no item 13202 : node ҝeڸٰܳZ+
SYSERR: Jun  3 22:46:47 :: Boot: cannot load SpecialItemGroup: locale/germany/special_item_group.txt
SYSERR: Jun  3 23:26:57 :: ReadSpecialDropItemFile: ReadSpecialDropItemFile : there is no item 13192 : node :eڸٰܳZ+
SYSERR: Jun  3 23:26:57 :: Boot: cannot load SpecialItemGroup: locale/germany/special_item_group.txt
SYSERR: Jun  3 23:36:00 :: ReadMonsterDropItemGroup: ReadMonsterDropItemGroup : there is no item 13192 : node z–ڞ:_ы:ѵ : vnum 13192
SYSERR: Jun  3 23:36:00 :: Boot: cannot load MOBDropItemFile: locale/germany/mob_drop_item.txt
SYSERR: Jun  3 23:40:19 :: ReadMonsterDropItemGroup: ReadMonsterDropItemGroup : there is no item 13203 : node ȘƂ : vnum 13203
SYSERR: Jun  3 23:40:19 :: Boot: cannot load MOBDropItemFile: locale/germany/mob_drop_item.txt
SYSERR: Jun  3 23:42:59 :: Boot: cannot load MOBDropItemFile: locale/germany/mob_drop_item.txt
SYSERR: Jun  3 23:51:02 :: Boot: cannot load MOBDropItemFile: locale/germany/mob_drop_item.txt

Nun meine Frage ist es ein ähnliches Problem? Wenn ja wie bekomme ich es gelöst?