jcc
Member
J! 2.5.6
Fabrik - github Fabrik-fabrik-3.0.6.1-8-g526c8bf
This seems to be happening for all of my date elements, which seem to imply a system-wide type issue. The elements are set to store in Local Time (see image), but it stores UTC.
The host is set to America/New York
Joomla Server Time Zone is set to New York.
mysql is set to SYSTEM
php is set to America/New_York
Save an account record (element from image)...
Change element to Store UTC and...
What am I missing!?!??? It is like Fabrik is taking the system time as UTC and doing the TZ conversion again.
Fabrik - github Fabrik-fabrik-3.0.6.1-8-g526c8bf
This seems to be happening for all of my date elements, which seem to imply a system-wide type issue. The elements are set to store in Local Time (see image), but it stores UTC.
The host is set to America/New York
Joomla Server Time Zone is set to New York.
mysql is set to SYSTEM
php is set to America/New_York
Code:
mysql> select current_timestamp;
+---------------------+
| current_timestamp |
+---------------------+
| 2012-08-24 11:49:09 |
+---------------------+
1 row in set (0.00 sec)
mysql> exit
Bye
[root]# date
Fri Aug 24 11:49:16 EDT 2012
[root]# date --utc
Fri Aug 24 15:49:18 UTC 2012
[root]# php test.php
PHP time: Fri, 24 Aug 2012 11:49:20
Code:
mysql> select last_update_datetime from account where account_id=1339;
+----------------------+
| last_update_datetime |
+----------------------+
| 2012-08-24 15:49:56 |
+----------------------+
1 row in set (0.00 sec)
Code:
[root]# date
Fri Aug 24 14:51:05 EDT 2012
mysql> select last_update_datetime from account where account_id=1339;
+----------------------+
| last_update_datetime |
+----------------------+
| 2012-08-24 22:50:59 |
+----------------------+
1 row in set (0.00 sec)
What am I missing!?!??? It is like Fabrik is taking the system time as UTC and doing the TZ conversion again.