You said you can't think of anything that did this... Are you sure the timezone settings didn't change the computer that has either the database or the application?
I ran into this problem on windows too once, it was a long time ago during a new install... I ended up fixing the code in some way, but I bet there is better way to fix this, such as setting the system timezone differently. I would try setting the system timezone to the same as Edinburgh, Scotland, just to see what happens. I am also wondering if upgrading to the latest version of 2.0 would fix it. What version are you using exactly? If no one else has a better idea, I am willing to provide a snapshot of our code. Although I am not sure we fixed the specific error you cite below. Let me know if you want it... Good Luck! -Chris -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dick Calhoun Sent: Tuesday, November 07, 2006 10:01 AM To: Logicalware Mailmanager-users Subject: [Mailmanager-users] MM 2.0 Error - Invalid input syntax for type timestamp with time zone 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 ------------------------------------------------------------------------- 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
