Wrong hour in history email module

[vslonska]

Hello,
In the email widget and history email tab on accounts pages, and in the email history page (yetiforceaddress/index.php?module=OSSMailView&view=List), all the emails have a wrong hour as the received hour of the email (two hours before the email was really sent).
In the email header, the date and hour is ok. All the UTC timezones are set (in the account settings of the Yetiforce user, in the php.ini, in the pool of php-fpm, in the php.ini cli which is used by the Cron). The email appears correctly in Rouncube.

Can you tell me were the problem can come from, or if there is a setting of the timezone somewhere for this module ?

My version of php is php 8.3, with php-fpm enabled.

Thanks,

[vslonska]

Hello,
Anyone still answer on Github for Yetiforce ?
Thanks,
Regards,

[vslonska]

Hello,
I still have the same problem with the last update.
In headers of the emails, I have the correct date and hour. But the "date" field in the database (vtiger_ossmailview) is two hours before (UTC time I suppose). In module=OSSMailView&view=Detail and in the widget of the contacts page and account page, prospects page, etc.

I don't know why Yetiforce don't use my local time, set in my settings, in the Cron, in php.ini, in the conf file of the pool of php-fpm...

Thanks for your answer,
Regards,

[vslonska]

And in main.php

[rskrzypczak]

check your time zone settings in user preferences and I don't mean just your user but also the administrator (everyone)

[vslonska]

Hello,
Thank you for your answer.
I just have this setting (index.php?module=Users&view=PreferenceDetail), and it's correctly set :

It's in the main (super admin) user.

I never saw any other setting. Where would that be?

Thank you,
Regards,

[vslonska]

Hello,
Does anyone would have an idea about how to correct that ?
Thanks,
Regards,

[vslonska]

Hello,
After a change of server of the main install, I have this problem now on that main installation. It worked normally before on the previous server.
So the problem doesn't come from the configuration of Yetiforce but from where this module (email history) takes its timezone setting. All the others dates are right (calendar, Inbox, Rouncube, etc.). It's just the email history module that have a wrong hour.
Thank a lot for any help,
Regards,

[vslonska]

Hello,
I can also add that only the record of received emails are false. Sent emails are with the correct hour. I noticed that in the database, the hour of received emails are in UTC time, but with the local timezone (+2 in my case), which is not the correct setting of course.
I have no idea of how to correct that. I already tried to set the server back in UTC time, and I verified that mysql also works in UTC.