Jump to content

Problem with log out time


Recommended Posts

Hi, I have this problem:

SYSERR: Feb  3 16:10:47 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'playtime' at row 1 (query: UPDATE loginlog2 SET type='VALID', logout_time=NOW(), playtime = TIMEDIFF(logout_time, login_time) WHERE id=@i errno: 1265)
 

I think that error it's because this function doesn't work:

dc5e3a2350e0425b5faffea334c2fec5.png

Because the program try to do a TIMEDIFF(logout_time,login_time) but not have a value on logout_time:

01e5c865c37394a52df526256508ee7c.png

The configuration of playtime column is:

b6ec637ea599ea705fef37b78a372cd2.png

 

Someone can help me? Thanks :)

Edited by Metin2 Dev
Core X - External 2 Internal
Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Announcements



×
×
  • Create New...

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.