Channel 1 Syserr Problem

07/28/2012 14:02 radsj1993#1
Hallo Com.
Ich habe folgende Fehler in der Syserr von channel1


SYSERR: Jul 28 13:43:51 :: 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, 521663, 57705, inet_aton('92.201.32.120'), '') errno: 1146)
SYSERR: Jul 28 13:47:33 :: 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', 'N', NOW(), 1, 23, 57706, inet_aton('92.201.32.120'), '') errno: 1146)
SYSERR: Jul 28 13:48:06 :: 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(57705, 999, '92.201.32.120', 1, 'Horny', 'm Statue', NOW()) errno: 1146)
SYSERR: Jul 28 13:48:09 :: 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(57705, 999, '92.201.32.120', 1, 'Horny', 'i 30311', NOW()) errno: 1146)
SYSERR: Jul 28 13:49:02 :: 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(57705, 999, '92.201.32.120', 1, 'Horny', 'm 20367', NOW()) errno: 1146)
SYSERR: Jul 28 13:54:06 :: 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, 521663, 57705, inet_aton('92.201.32.120'), '') errno: 1146)
SYSERR: Jul 28 13:54:14 :: 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(57705, 999, '92.201.32.120', 1, 'Horny', 'reload', NOW()) errno: 1146)
SYSERR: Jul 28 13:54: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(57705, 999, '92.201.32.120', 1, 'Horny', 'reload player', NOW()) errno: 1146)
SYSERR: Jul 28 13:54:24 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: SET @i = (SELECT MAX(id) FROM loginlog2 WHERE account_id=521663 AND pid=57705) errno: 1146)
SYSERR: Jul 28 13:54:24 :: 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: Jul 28 13:54:47 :: 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, 521663, 57705, inet_aton('92.201.32.120'), '') errno: 1146)
SYSERR: Jul 28 13:55:17 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jul 28 13:56:03 :: 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, 521663, 57705, inet_aton('92.201.32.120'), '') errno: 1146)
SYSERR: Jul 28 13:56:43 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.


Wie kann ich die beheben?
11/24/2012 19:03 ~paradoX#2
Hi, ich weis ist ein bisschen spät aber vielleicht hast du den Fehler immernoch...

Scheint so als ob dir deine loginlog2 Tabelle fehlt.
Such mal in Epvp nach der DB log und hau sie mit Navicat rein dann sollten 98% der Syserr weg sein. Andernfalls hab ich hier die Query dafür gefunden.

Quote:
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=293362 DEFAULT CHARSET=latin1;
An der Stelle dann auch mal ein
#closerquest