Configure Time Zone

Phoca Cart - complex e-commerce extension
gbarbosa
Phoca Newbie
Phoca Newbie
Posts: 4
Joined: 13 Jul 2020, 00:18

Configure Time Zone

Post by gbarbosa » 13 Jul 2020, 00:28

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

User avatar
dmlwebal
Phoca Enthusiast
Phoca Enthusiast
Posts: 91
Joined: 18 Sep 2019, 12:49

Re: Configure Time Zone

Post by dmlwebal » 14 Jul 2020, 15:18

Hi

Is your Joomla Timezone set correctly for your region?

gbarbosa
Phoca Newbie
Phoca Newbie
Posts: 4
Joined: 13 Jul 2020, 00:18

Re: Configure Time Zone

Post by gbarbosa » 14 Jul 2020, 15:39

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

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 42730
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Configure Time Zone

Post by Jan » 15 Jul 2020, 13:33

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
If you find Phoca extensions useful, please support the project

gbarbosa
Phoca Newbie
Phoca Newbie
Posts: 4
Joined: 13 Jul 2020, 00:18

Re: Configure Time Zone

Post by gbarbosa » 15 Jul 2020, 17:49

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,

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 42730
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Configure Time Zone

Post by Jan » 16 Jul 2020, 17:49

Hi, I cannot access the screenshot on onedrive server :idea:
If you find Phoca extensions useful, please support the project

gbarbosa
Phoca Newbie
Phoca Newbie
Posts: 4
Joined: 13 Jul 2020, 00:18

Re: Configure Time Zone

Post by gbarbosa » 16 Jul 2020, 19:30

Hello,

Perdon Me

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

Thanks,

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 42730
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Configure Time Zone

Post by Jan » 27 Jul 2020, 22:08

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

Jan
If you find Phoca extensions useful, please support the project

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 42730
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Configure Time Zone

Post by Jan » 28 Jul 2020, 16:35

Hi, testing now, everything is OK for me:

Image

Image

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
If you find Phoca extensions useful, please support the project

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 42730
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Configure Time Zone

Post by Jan » 29 Jul 2020, 13:05

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

Jan
If you find Phoca extensions useful, please support the project

Post Reply