Hello,
I encounter a really weird issue.
This morning, I have a look at new tickets to manage. But I can not open any tickets created since last friday. When I click on a ticket recently created, it loads forever and and after some time, it displays an, incomplete ticket (see picture).

If I click on a ticket that was created before last friday, it displays smoothly.
Of course, nothing has changed on the server, nothing has changed in osticket configuration during the weekend.

I tried to investigate, and I logged as a user lambda to create a new ticket. And it doesn't runs as it should. I can access the interface to write my ticket, but when I click on "Create" it takes longer than usually and it loads a totally blank page.
After logging back to my administrator account, the ticket is created and appears in the "my tickets" list. But it can not be displayed as described before. I verified the mysql database through phpmyadmin, the ticket seems to be correctly stored as I can find the different information that I wrote when I created the ticket. But I'm not an expert of mysql and I can not tell if every fields are correct.

Once again, every "old" tickets can be access smoothly as usual.

One information that maybe intersting, but I don't want to push you forward a wrong clue : I'm in France, and this weekend, we've changed the time. At 2 o'clock, we have to forward our watch to 3 o'clock.
So I had a look at different system information and that's where it's beginning more weird. My osticket installation information tells /!\date.timezone defaut timezone is highly recommended
So I opened mysite.com/info.php to confirm that it uses /etc.php.ini, I edited it and there was nothing mentionned at ;date.timezone= . So I replaced by date.timezone = "Europe/Paris". I restarted the httpd server but osticket keeps telling /!\date.timezone defaut timezone is highly recommended and info.php keeps telling date.timezone no value no value, as if nothing was changed.

Maybe I'm spending my time for nothing and this has nothing to do with my problem.

    It looks like the display dies either at due date or Help Topic.

    Orvis and it loads a totally blank page.

    This means that you have a PHP error being logged. You should consult your error logs and see what that error is (and maybe post it here) as it should help us narrow down where the error is.

      I use a Fedora server v34
      I'm not sure where to find the PHP logs, but here is what I found in /var/log/php-fpm :
      from error.log :

      from www-error.log

      I deleted the Schedules and it solved the issue.

      BUT, I would like to understand what's the link between the schedules and the fact that a ticket won't display correctly.

      I would hazard a guess that it is messing up on the due date. It also says that the Timezone could not be found in the database and all the years are showing 2066 and 2067. Since thats over 40 years from now, it might not know what to do. Since you deleted the schedules it just defaults back to the basics.

      @Daedalus01

      It’s the translation of the dates in schedules. I’ve explained this in a previous thread on here or GitHub that you can look for but essentially there’s a bug where we we use the translated dates in PHP functions for schedules and PHP apparently only understands English. So for now deleting the US Holidays schedule should fix it. We already have this on our bug sheet to look into.

      Cheers.

      Write a Reply...