Phoca Forum

Hello.

I am having trouble in Phocacart because all SQL queries. UTC date is not converted to local time. All hours do not match.

Could someone help me how can I configure the time zone in phoca cart.

Thanks

Hi

Is your Joomla Timezone set correctly for your region?

Hello

if it is set to joomla, my time zone is America / Bogota. The strange thing is that it only happens in the reports, statistics and see orders in POS mode.

Thanks

Hi, and did you check your server settings. The date is just taken from php method when saving data to database. If interpretting, then it is displayed with help of Joomla! methods.

Can you paste screenshots of where the time is OK and where not?

Jan

Hello,

Images,

POS MODE:
https://onedrive.live.com/embed?cid=A82 ... dB-sTtbELk
https://onedrive.live.com/embed?cid=A82 ... IoimFh2vEU

In reports and statistics the same thing happens. It consults me with the UTC time.

Thanks,

Hi, I cannot access the screenshot on onedrive server

Hello,

Perdon Me

[img]https://i.imgur.com/vgWnB4u.png[/img]
[img]https://i.imgur.com/iLa19zD.png[/img]

Thanks,

Hi, thank you for the screenshots, I will take a look at it.

Jan

Hi, testing now, everything is OK for me:





Are you sure, the time zone settins on your Joomla! site (or server) is OK?

I will try to change this (add for both the Date class), maybe this can help - this will be in version 3.5.3. So after testing it, just let me know.

Jan

Try to test 3.5.3 and let me know:
https://www.phoca.cz/news/1093-phoca-ca ... 3-released

Jan