HELP Problem with datetime object in a condition

Technical assistance
1

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 (https://zammad.com/getting-started [same Version])
    but here works the condition as expected

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

Neues%20Bild%20(38)
Neues Bild (38).jpg717×927 56.9 KB

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

Who has an idea?

2

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

3

Hi @MrGeneration
Sorry for the delay. :slight_smile:
Yes I think also.
https://community.zammad.org/t/zammad-works-in-the-wrong-time-zone/2201

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

4

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)

5

Hi
I think it is the database which has the problem.

irb(main):004:0> Time.zone.now
=> 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.

6

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:

7

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

1 Like
8

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:

9

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