HELP Problem with datetime object in a condition

Hi community

  • Used Zammad version: 2.9
  • Used Zammad installation source: (source, package, …) DEB
  • Operating system: Debian 8.11
  • Browser + version: actually Firefox

For example do not understand this:

  • I edit this task at 13.03 10:38
  • Scheduler task displays me a ticket a day before in the preview.
  • The datetime object “termin” of the ticket is more as 8h in the past
  • Then I tested it on the free trial vision ( [same Version])
    but here works the condition as expected

Why displays the preview this ticket “Test Termin 12.03 17:00”?

So I do not understand why my installation work not as expected!!!

Who has an idea?

In what timezone is your browser located and what timezone does your Server have?
Looks like a timezone issue. Hosted instance live in GMT+1

Hi @MrGeneration
Sorry for the delay. :slight_smile:
Yes I think also.

And if I install a new system in my right time zone. Afterwards I restore a backup.
Could be that a solution?

That could be the solution, if it’s possible, you could create a clone environment that doesn’t communicate to any servers (to ensure no data is being changed) and change the timezone in your test system.

Personally I don’t think a complete reinstall would be needed. After a reboot you should be fine (hopefully)

I think it is the database which has the problem.

=> Thu, 07 Mar 2019 12:28:23 UTC +00:00

So I thinking about a

ALTER database zammad SET timezone = 'Europe/Berlin ’

But I’m not sure.

I can’t answer that, sorry.
Maybe @thorsteneckel can do that.

Personally I doubt that this is the issue, but you can never know! :smiley:

So If he has time!!! :slight_smile:
So nice weekend together.

1 Like

Hi there! Yes there actually is an existing issue for that. Unfortunately we have any experience with workarounds so I can’t help much :confused:

This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.