Buy Now
Sign in

Wrong data being saved in the database (3 hours more than my local time)

mauropiro , October 04 at 16:37
M
mauropiro
Dear Sirs
Please help me with this problem.
I am using the CC6 save_data action on Joomla 3.8.12, but the time is being saved 3 hours more than my local time.
I changed the timezone of my php but it did not work.
I used DATE_FORMAT_LC2 override for languages, also did not resolve.
I cleaned my cache, I manually changed the php.ini to date.timezone = "America / Sao_Paulo", I restarted PHP several times.I changed timezone in Joomla, but none of it worked.
Please, your help is greatly appreciated.
Follow the prints on the screens.
Thank you
debug.png
php_timezone_settings.png
CC6_wrong_date.png
joomla_timezone.png
healyhatman
This one took me a while to figure out, but it's because {date:} uses UTC time. What you need to do it
{date/timezone:format}
So for you it SHOULD (not 100% of the Sao Paulo PHP timezone code) be
{date/Sao_Paulo:Y-m-d H:i}
Web developer at SkySpider.com.au
I don't work for ChronoEngine but I do accept donations paypal.me/healyhatman
M
mauropiro
Dear Healyhatman​
​​
​Amazing, it worked.​
​​
​I am very grateful to you for this one.​
​​
​Mauro​
​​
it_worked.png
Attachments
it_worked.png
it_worked.png
(45.97 KiB)
21 Downloads/Views