ich wollte heute meinen Server hochfahren, doch da kam auf einmal eine Meldung: "ITEM_AWARD load id 71701 bMall 0".
Durch diese Meldung funktioniert der Server nicht mehr.
Habe mir die Logs durchgeschaut und sehe zwar viele Fehler, aber wenige Zusammenhänge, bzw. Lösungen wie man es beheben kann..
Hier wäre der letzte Teil der syserr und syslog.
syserr:
Code:
SYSERR: Jun 5 08:10:28 :: Start: TABLE_POSTFIX not configured use default SYSERR: Jun 5 08:10:29 :: 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 5 08:10:29 :: LoadMonarchCandidacy: DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id) SYSERR: Jun 5 08:10:50 :: Load: DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry) SYSERR: Jun 5 08:11:34 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: Jun 5 08:11:39 :: Start: TABLE_POSTFIX not configured use default SYSERR: Jun 5 08:11:39 :: 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 5 08:11:39 :: LoadMonarchCandidacy: DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id) SYSERR: Jun 5 08:11:39 :: Load: DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry) SYSERR: Jun 5 08:13:13 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: Jun 5 08:13:18 :: Start: TABLE_POSTFIX not configured use default SYSERR: Jun 5 08:13:18 :: 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 5 08:13:18 :: LoadMonarchCandidacy: DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id) SYSERR: Jun 5 08:13:18 :: Load: DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry) SYSERR: Jun 5 08:17:46 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: Jun 5 08:20:07 :: Start: TABLE_POSTFIX not configured use default SYSERR: Jun 5 08:20:07 :: 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 5 08:20:07 :: LoadMonarchCandidacy: DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id) SYSERR: Jun 5 08:20:07 :: Load: DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry) SYSERR: Jun 5 08:30:18 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: Jun 5 08:35:10 :: Start: TABLE_POSTFIX not configured use default SYSERR: Jun 5 08:35:10 :: 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 5 08:35:10 :: LoadMonarchCandidacy: DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id) SYSERR: Jun 5 08:35:10 :: Load: DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry) SYSERR: Jun 5 08:35:54 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: Jun 5 08:36:18 :: Start: TABLE_POSTFIX not configured use default SYSERR: Jun 5 08:36:18 :: 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 5 08:36:18 :: LoadMonarchCandidacy: DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id) SYSERR: Jun 5 08:36:18 :: Load: DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry) SYSERR: Jun 5 08:38:33 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: Jun 5 08:42:59 :: Start: TABLE_POSTFIX not configured use default SYSERR: Jun 5 08:42: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 5 08:42:59 :: LoadMonarchCandidacy: DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id) SYSERR: Jun 5 08:42:59 :: Load: DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
syslog:
Code:
Jun 5 08:42:59 :: Metin2DBCacheServer Start Jun 5 08:42:59 :: ClientManager pointer is 0xbf7fe3e8 Jun 5 08:42:59 :: GUILD_RANK: SpongeBobs 1 54270 Jun 5 08:42:59 :: GUILD_RANK: 187er 2 41239 Jun 5 08:42:59 :: GUILD_RANK: LeQuAliTy 3 38855 Jun 5 08:42:59 :: GUILD_RANK: TurboHase 4 35660 Jun 5 08:42:59 :: GUILD_RANK: WirSindStars 5 34746 Jun 5 08:42:59 :: GUILD_RANK: ViOlEnCe 6 30434 Jun 5 08:42:59 :: GUILD_RANK: OnePuncH 7 28676 Jun 5 08:42:59 :: GUILD_RANK: RuhigBrauner 8 28253 Jun 5 08:42:59 :: GUILD_RANK: BlackRoyals 9 26326 Jun 5 08:42:59 :: GUILD_RANK: ShinraTensei 10 25378 Jun 5 08:42:59 :: GUILD_RANK: BaLisTo 11 25284 Jun 5 08:42:59 :: GUILD_RANK: ILoveFruitxD 12 25235 Jun 5 08:42:59 :: GUILD_RANK: eXtraVaGant 13 24771 Jun 5 08:42:59 :: GUILD_RANK: CoMPLiCaTeD 14 24360 Jun 5 08:42:59 :: GUILD_RANK: StarRyders 15 24329 Jun 5 08:42:59 :: GUILD_RANK: NewStars 16 24165 Jun 5 08:42:59 :: GUILD_RANK: DirtyBeat 17 24115 Jun 5 08:42:59 :: GUILD_RANK: FiveGum 18 23962 Jun 5 08:42:59 :: GUILD_RANK: Ne0nShiNe 19 23737 Jun 5 08:42:59 :: GUILD_RANK: Kick 20 23699 Jun 5 08:43:04 :: [ 50] return 0/0/0 async 0/0/0 Jun 5 08:43:04 :: ITEM_AWARD: load id 71701 login killop12 vnum 50026 count 0 socket 10000 Jun 5 08:43:09 :: [ 100] return 0/0/0 async 0/0/0 Jun 5 08:43:14 :: [ 150] return 0/0/0 async 0/0/0 Jun 5 08:43:19 :: [ 200] return 0/0/0 async 0/0/0 Jun 5 08:43:24 :: [ 250] return 0/0/0 async 0/0/0 Jun 5 08:43:29 :: [ 300] return 0/0/0 async 0/0/0 Jun 5 08:43:34 :: [ 350] return 0/0/0 async 0/0/0 Jun 5 08:43:39 :: [ 400] return 0/0/0 async 0/0/0 Jun 5 08:43:44 :: [ 450] return 0/0/0 async 0/0/0 Jun 5 08:43:49 :: [ 500] return 0/0/0 async 0/0/0 Jun 5 08:43:54 :: [ 550] return 0/0/0 async 0/0/0 Jun 5 08:43:59 :: [ 600] return 0/0/0 async 0/0/0 Jun 5 08:44:04 :: [ 650] return 0/0/0 async 0/0/0 Jun 5 08:44:09 :: [ 700] return 0/0/0 async 0/0/0 Jun 5 08:44:14 :: [ 750] return 0/0/0 async 0/0/0 Jun 5 08:44:19 :: [ 800] return 0/0/0 async 0/0/0 Jun 5 08:44:24 :: [ 850] return 0/0/0 async 0/0/0 Jun 5 08:44:29 :: [ 900] return 0/0/0 async 0/0/0 Jun 5 08:44:34 :: [ 950] return 0/0/0 async 0/0/0 Jun 5 08:44:39 :: [ 1000] return 0/0/0 async 0/0/0 Jun 5 08:44:44 :: [ 1050] return 0/0/0 async 0/0/0 Jun 5 08:44:49 :: [ 1100] return 0/0/0 async 0/0/0 Jun 5 08:44:54 :: [ 1150] return 0/0/0 async 0/0/0 Jun 5 08:44:59 :: [ 1200] return 0/0/0 async 0/0/0 Jun 5 08:45:04 :: [ 1250] return 0/0/0 async 0/0/0 Jun 5 08:45:09 :: [ 1300] return 0/0/0 async 0/0/0 Jun 5 08:45:14 :: [ 1350] return 0/0/0 async 0/0/0 Jun 5 08:45:19 :: [ 1400] return 0/0/0 async 0/0/0 Jun 5 08:45:24 :: [ 1450] return 0/0/0 async 0/0/0 Jun 5 08:45:29 :: [ 1500] return 0/0/0 async 0/0/0 Jun 5 08:45:34 :: [ 1550] return 0/0/0 async 0/0/0 Jun 5 08:45:39 :: [ 1600] return 0/0/0 async 0/0/0 Jun 5 08:45:44 :: [ 1650] return 0/0/0 async 0/0/0 Jun 5 08:45:49 :: [ 1700] return 0/0/0 async 0/0/0 Jun 5 08:45:54 :: [ 1750] return 0/0/0 async 0/0/0 Jun 5 08:45:59 :: [ 1800] return 0/0/0 async 0/0/0 Jun 5 08:46:04 :: [ 1850] return 0/0/0 async 0/0/0 Jun 5 08:46:09 :: [ 1900] return 0/0/0 async 0/0/0 Jun 5 08:46:14 :: [ 1950] return 0/0/0 async 0/0/0 Jun 5 08:46:19 :: [ 2000] return 0/0/0 async 0/0/0 Jun 5 08:46:24 :: [ 2050] return 0/0/0 async 0/0/0
Hoffe ihr könntet mir eine Lösung sagen.
