I've upgraded my installation today and also switched to a new database (PostgreSQL) however during the installer, I get an error that tells me my database time differs from my PHP time.
QuoteDB Time: NOT OK (Database time differs s from PHP time)
I checked my PHP.ini file in Linux and it just tells me:
[Date]
; Defines the default timezone used by the date functions
date.timezone = America/New_York
Can someone please tell me what is wrong? I checked my database server and it shows the correct time in both PostgreSQL and on Linux:
postgres=# SELECT current_time;
timetz
--------------------
14:32:34.115421-04
(1 row)
postgres=# SELECT current_date;
date
------------
2011-08-23
(1 row)
cmennens@db1:~$ date
Tue Aug 23 14:32:54 EDT 2011
Can anyone please tell me what I'm missing here?
Anyone know what this means and how to fix it? I've verified my database and system time on Linux are correct and they are:
[ATTACH=CONFIG]1736[/ATTACH]
[root@ideweb1 config]# date
Fri Aug 26 09:15:56 EDT 2011
postgres=# SELECT current_date; date
------------
2011-08-26
(1 row)
postgres=# SELECT current_time;
timetz
--------------------
10:16:50.827416-04
(1 row)
One hour difference often has something to do with a DST (Daylight Saving Time)-setting. Check your configs for that
Check my configurations in RC or PHP? I don't understand? My database time is obviously right and my PHP time is set to US/Eastern.
Quote from: CarlosinFL;36380Check my configurations in RC or PHP? I don't understand? My database time is obviously right and my PHP time is set to US/Eastern.
Well, first check the time-zone in RC, and if it's automatic, check your PHP-config.