Page 1 of 1
Scheduled Tasks
Posted: 15 Feb 2020, 04:25
by ArmP
Re: Scheduled Tasks
Posted: 15 Feb 2020, 10:07
by Nyuton
the video doesn't make any sense.
you schedule a "run now" task at it shows "run once at 2020-02-14 20:07", then you show your local clock which is 15th feb 07:07.
Your server's host clock or timezone is off. You need to fix this first.,
All time and date info is sensitive to the server's clock and timezone, not your local windows clock.
Re: Scheduled Tasks
Posted: 15 Feb 2020, 11:34
by ArmP
Web server time zone?
Re: Scheduled Tasks
Posted: 15 Feb 2020, 21:23
by Nyuton
no it's the gameserver/database time & timezone
Re: Scheduled Tasks
Posted: 16 Feb 2020, 14:24
by Nyuton
I've added a check time button to the latest patch, so you could get the current server time. I hope it helps to troubleshoot the issue.
Re: Scheduled Tasks
Posted: 18 Feb 2020, 06:08
by ArmP
I solved the problem by assigning to use the system time in the MYSQL server. In the database of the game server, I did not find such a setting))
To use the system time, in MySQL you need to execute a query
SET GLOBAL time_zone = 'SYSTEM';
SET time_zone = 'SYSTEM';
Re: Scheduled Tasks
Posted: 18 Feb 2020, 09:51
by Nyuton
Great, thanks for the info!
Luckily, according to
MariaDB docs, SYSTEM is the default for the time_zone setting.