[rt-users] unrecognized time zone name: "GMT"

[Kevin Falcone]

On Wed, Feb 09, 2011 at 11:02:05AM -0800, Lee Hughes wrote:
> Testing RT 3.8.8 with PostgreSQL 9.0.3, seeing these warnings in the
> Apache error log:

That's unusual.  What timezones does your Pg know about?
http://www.postgresql.org/docs/9.0/static/view-pg-timezone-names.html

-kevin

> [Wed Feb  9 18:46:38 2011] [warning]: DBD::Pg::st execute failed:
> ERROR:  unrecognized time zone name: "GMT"
> (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:509)
> [Wed Feb  9 18:46:38 2011] [warning]: RT::Handle=HASH(0xb14ed7c)
> couldn't execute the query 'SET TIME ZONE 'GMT'' at
> /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 522
> 
> Looks like these errors occur on every ticket transaction, for
> example saving a Comment. I confirmed that correct timestamps are
> getting assigned to ticket transactions.
> 
> Any ideas are greatly appreciated.
> 
> Thanks-
> 
> Lee
> 
> 
> 
> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110209/2a653681/attachment.sig>