Jump to content
Forgot your email address? ×
×
×
  • Create New...
  • 0

Mysql Out of range value


Domi

Question

Hello again,
 
At the moment we are working on 40k files from speedi with vanilla core 2.4.1 Hotfix 2 and we found an error occurre in our syserr which looks like this:
SYSERR: Nov 23 21:20:37 :: pid_init: 
Start of pid: 958
SYSERR: Nov 23 21:20:37 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'time' at row 1 (query: INSERT INTO bootlog (time, hostname, channel) VALUES(NOW(), 'auth_test', 1) errno: 1264)
SYSERR: Nov 23 21:22:40 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Nov 23 21:22:40 :: pid_deinit: 
End of pid

MySQL 5.6 with no special changes.

 
 - .Domii
Link to comment
  • Answers 1
  • Created
  • Last Reply

Top Posters For This Question

Top Posters For This Question

1 answer to this question

Recommended Posts

  • 0

Found a solution by myself. The Problem was that:

 

time column was INT instead of DATE in the Database and the second error which occurred right after we fixed this issue was that the hostname column was also INT instead of VARCHAR. Simply ALTER TABLE on bootlog fixed this issue for us.

 

Thanks

Link to comment

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

Announcements

  • -15% Discount in Metin2 Dev Store (01/10/2021 => 31/12/2021) => Code => 15_PCT_OCT_TO_DEC_2021


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.