Buy Now
Sign in

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

mauropiro , October 04 2018
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

You can now copy+paste code from forums
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)
93 Downloads/Views