Hello.
This error appears whenever I change the system date more than 24 hours after the current date.
I'll explain it better: I have a server stats system, where every day saves specific data based on the current day. In that table a column called StatsDate and is set to DATE. I have a Christmas system too, which is activated when it arrives in December.
So, when I created the Christmas system there was no column set to DATE, so I changed the machine's date to 01/12/2020 and could test everything without any problem in Database.
After I created the server Stats system I cannot change the machine's date more than 24 hours beyond the current day, that is, example: today is 09/06/2020 21:00:36, I can change the date to 10/06/2020 21:00:36 and there is no problem, but if I change to 11/06/2020 21:00:36 or more that this happens the following error when I will save/load the data in the Database: error #2013 while executing query.. (the query) ... Lost connection to MySQL server during query
After going back to the current date everything goes back to normal automatically.
Is there anything related to the columns configured on DATE?
Hello. This error appears whenever I change the system date more than 24 hours after the current date.
I'll explain it better: I have a server stats system, where every day saves specific data based on the current day. In that table a column called StatsDate and is set to DATE. I have a Christmas system too, which is activated when it arrives in December.
So, when I created the Christmas system there was no column set to DATE, so I changed the machine's date to 01/12/2020 and could test everything without any problem in Database.
After I created the server Stats system I cannot change the machine's date more than 24 hours beyond the current day, that is, example: today is 09/06/2020 21:00:36, I can change the date to 10/06/2020 21:00:36 and there is no problem, but if I change to 11/06/2020 21:00:36 or more that this happens the following error when I will save/load the data in the Database: error #2013 while executing query.. (the query) ... Lost connection to MySQL server during query
After going back to the current date everything goes back to normal automatically. Is there anything related to the columns configured on DATE?