If you are using MySQL with TimeTrex you must ensure that you have the proper time zone support as described in the MySQL manual.WARNING: TimeTrex was unable to set your time zone. Please contact your TimeTrex administrator immediately.
If you are using Linux, run this command:
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -p -u root mysql
If you are using windows, you need to download the latest time zone description files from:
http://dev.mysql.com/downloads/timezones.html
Then shutdown your MySQL server if its running, unzip the time zone description files to your MySQL database data directory, ie:
C:\Program Files\MySQL\MySQL Server 5.0\data\mysql
It should ask to overwrite files that already exist, say yes.
Start MySQL again and you should now have full time zone support.