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 ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Mailmanager-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mailmanager-users
