Error Log

[Cristian.D 0]

Hy metin2dev!

I have a problem in syserr channel1,game99,db

SYSERR: Aug 26 03:37:48 :: ChildLoop: AsyncSQL: query failed: Table 'log.invalid_server_log' doesn't exist (query: INSERT INTO invalid_server_log(locale_type, log_date, ip, revision) VALUES(25, NOW(), '192.168.16.100', 40250) errno: 1146)

Please help me

Sorry for my bad english.

[Think 118]

Your problem is that Table 'log.invalid_server_log' doesn't exist

Based on that query, create that table with fields locale_type - int(11), log_date - timestamp, ip - varchar(32), revision - int(11).

 

This error should not be critical though.

[Cristian.D 0]

Not functioned,please give my a sql with this tabel.

[M.Sorin 341]

DROP TABLE IF EXISTS `invalid_server_log`;
CREATE TABLE `invalid_server_log` (
  `locale_type` int(11) DEFAULT NULL,
  `log_date` timestamp NULL DEFAULT NULL,
  `ip` varchar(32) DEFAULT NULL,
  `revision` int(11) DEFAULT NULL 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=big5_bin;

Try this

[Cristian.D 0]

DROP TABLE IF EXISTS `invalid_server_log`;
CREATE TABLE `invalid_server_log` (
  `locale_type` int(11) DEFAULT NULL,
  `log_date`  timestamp DEFAULT NULL,
  `ip` varchar(32) DEFAULT NULL,
  `revision` int(11) DEFAULT NULL 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=big5_bin;

Try this

 

[Err] 1067 - Invalid default value for 'log_date'

[M.Sorin 341]

DROP TABLE IF EXISTS `invalid_server_log`;
CREATE TABLE `invalid_server_log` (
  `locale_type` int(11) DEFAULT NULL,
  `log_date` timestamp NULL DEFAULT NULL,
  `ip` varchar(32) DEFAULT NULL,
  `revision` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1;

 

Try it now..

[Cristian.D 0]

DROP TABLE IF EXISTS `invalid_server_log`;
CREATE TABLE `invalid_server_log` (
  `locale_type` int(11) DEFAULT NULL,
  `log_date` timestamp NULL DEFAULT NULL,
  `ip` varchar(32) DEFAULT NULL,
  `revision` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=big5_bin;

Try it now..

 

[Err] 1253 - COLLATION 'big5_bin' is not valid for CHARACTER SET 'latin1'

[M.Sorin 341]

DROP TABLE IF EXISTS `invalid_server_log`;
CREATE TABLE `invalid_server_log` (
`locale_type` int(11) DEFAULT NULL,
`log_date` timestamp NULL DEFAULT NULL,
`ip` varchar(32) DEFAULT NULL,
`revision` int(11) DEFAULT NULL
)ENGINE=MyISAM DEFAULT CHARSET=latin1;

My bad , now it works perfectly.

[Cristian.D 0]

DROP TABLE IF EXISTS `invalid_server_log`;
CREATE TABLE `invalid_server_log` (
`locale_type` int(11) DEFAULT NULL,
`log_date` timestamp NULL DEFAULT NULL,
`ip` varchar(32) DEFAULT NULL,
`revision` int(11) DEFAULT NULL
)ENGINE=MyISAM DEFAULT CHARSET=latin1;

My bad , now it works perfectly.

 

Thanks man,it works perfectly now.