[Mailmanager-users] MM 2.0 Error - Invalid input syntax for type timestamp with time zone

[Dick C. <dca...@im...>]

Hi Folks,
Our production version of Mail Manager 2.0 on Windows server-2000; PostgreSQL 8.0.7 has been working OK until recently.  When we attempt to do a "Search", delete & archive, or enter the "Reports" page, we get a programming error as follows: (from Zope ZMI error_log)

ERROR: invalid input syntax for type timestamp with time zone: "2006/11/01 23:59:59 US/Eastern" SELECT COUNT(1) AS count FROM IOC.mm_ticket WHERE id IN (SELECT id FROM IOC.   )

I can think of nothing we consciensly did to cause this?  Have tried to delete the old instance and create a new one but I am sure that all I did was copy the problem into the new instance.

Any ideas on how to cure this??

Dick Calhoun
InterMedi@ Marketing Solutions
Ofc. Ph: 610-701-9654