Need help.
My system is OSTicket (v1.9.8.1)
Mysql Database
Changed the server date to a future date. Tickets were opened by email on the future date.
When I return to the current date, no more tickets are opened.
Tickets are only opened by email on a date and time higher than the last ticket created.
How to return to the current date?
1.9 is end of life and has been for some time. You should really upgrade.
I think that you will find that it's not a matter of osTicket not making new tickets, but that your cron/task scheduler isn't firing the cron.php since it is no longer in the future (as the next scheduled run isn't until some unknown time in the future because of the date change).
@KevinTheJedi to do you concur?
I believe that it is not a problem in Cron.
Because when I set the date for the future. In the year 2027, it works again.
The problem is that tickets are open with the wrong dates, they open in the year 2027.
Thanks for listening
Once you set the server time to some data in the future, MySQL now has the time in the future as well as any other application/service. Once you set the server time, you must restart all services (sometimes even the entire server itself) in order for every application/service to pick up the new time.
Cheers.
I did the test.
After changing the date - I put it in today's date and time. - I restarted the server and it didn't work.
It seems that it records the date of the last ticket somewhere in the database and does not open any at an earlier date.
Okay, so you will need to go to your database, go to the ost_email table, find the email you're fetching from, and change the mail_lastfetch value to today's date maybe a few minutes earlier than your current time.
Cheers.
Thank you.
It's back to working normally.
That was really the problem.
After changing, he reopened the e-mails.
Thank you very much
