Jump to content
×
×
  • Create New...
  • 0

Error Log


Cristian.D

Question

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.

Link to comment
Share on other sites

8 answers to this question

Recommended Posts

  • 0

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.

Link to comment
Share on other sites

  • 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 this :)

Link to comment
Share on other sites

  • 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'

Link to comment
Share on other sites

  • 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=latin1;
 

Try it now..

Link to comment
Share on other sites

  • 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'

Link to comment
Share on other sites

  • 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.

  • Love 2
Link to comment
Share on other sites

  • 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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.