Page 1 of 1

Scheduled Tasks

Posted: 15 Feb 2020, 04:25
by ArmP
Daily scheduled tasks do not work - https://www.youtube.com/watch?v=81EE5M7r3DM

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.