Configure Time Zone

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

Configure Time Zone

Post by gbarbosa »

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 Professional
Phoca Professional
Posts: 238
Joined: 18 Sep 2019, 12:49

Re: Configure Time Zone

Post by dmlwebal »

Hi

Is your Joomla Timezone set correctly for your region?
gbarbosa
Phoca Newbie
Phoca Newbie
Posts: 6
Joined: 13 Jul 2020, 00:18

Re: Configure Time Zone

Post by gbarbosa »

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: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Configure Time Zone

Post by Jan »

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: 6
Joined: 13 Jul 2020, 00:18

Re: Configure Time Zone

Post by gbarbosa »

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: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Configure Time Zone

Post by Jan »

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: 6
Joined: 13 Jul 2020, 00:18

Re: Configure Time Zone

Post by gbarbosa »

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: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Configure Time Zone

Post by Jan »

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: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Configure Time Zone

Post by Jan »

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: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Configure Time Zone

Post by Jan »

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