Hi I have been working using Pagetemplates,XML,python script and Postgres sql At times when I use a select statement to select values from a table in zope I get an error on the time variable. The error is : Error, Invalid Date-Time String: 2002-06-08 00:00:00+05 SQL used: select * from calendar order by cuser Traceback (innermost last): File /home/zope/Zope-2.5.1/lib/python/ZPublisher/Publish.py, line 150, in publish_module File /home/zope/Zope-2.5.1/lib/python/ZPublisher/Publish.py, line 114, in publish File /home/zope/Zope-2.5.1/lib/python/Zope/__init__.py, line 159, in zpublisher_exception_hook (Object: zsqll_event) File /home/zope/Zope-2.5.1/lib/python/ZPublisher/Publish.py, line 98, in publish File /home/zope/Zope-2.5.1/lib/python/ZPublisher/mapply.py, line 88, in mapply (Object: manage_test) File /home/zope/Zope-2.5.1/lib/python/ZPublisher/Publish.py, line 39, in call_object (Object: manage_test) File /home/zope/Zope-2.5.1/lib/python/Shared/DC/ZRDB/DA.py, line 328, in manage_test (Object: zsqll_event) File /home/zope/Zope-2.5.1/lib/python/Shared/DC/ZRDB/DA.py, line 306, in manage_test (Object: zsqll_event) File /home/zope/Zope-2.5.1/lib/python/Shared/DC/ZRDB/DA.py, line 421, in __call__ (Object: zsqll_event) File /home/zope/Zope-2.5.1/lib/python/Products/ZPsycopgDA/db.py, line 205, in query File /home/zope/Zope-2.5.1/lib/python/Products/ZPsycopgDA/DA.py, line 120, in cast_DateTime File /home/zope/Zope-2.5.1/lib/python/DateTime/DateTime.py, line 651, in __init__ File /home/zope/Zope-2.5.1/lib/python/DateTime/DateTime.py, line 1022, in _parse Invalid Date-Time String: (see above) But at other times there is no error thrown .I rectify the error usually by checking the properties of the Database connection and saving the settings again.The error does nopt appear always only at times Couls you please tell me how I can avoid this error from creeping up.Because I have found that at some time or the other this error comes up and so far I have not been able to find a solution. Best Regards John Kunchandy
Hi. What locale did you set your postmaster to? Maybe it's putting out some date/time string, the DateTime module can't handle? Maybe it only can handle it on some special times because of it's format. Is it displaying the correct times/dates when it seems to work? Cheers Christian * zope <zope@stylusinc.net> [020816 05:55]:
Hi
I have been working using Pagetemplates,XML,python script and Postgres sql At times when I use a select statement to select values from a table in zope I get an error on the time variable.
The error is : Error, Invalid Date-Time String: 2002-06-08 00:00:00+05 SQL used:
[kicked a lot of trace]
But at other times there is no error thrown .I rectify the error usually by checking the properties of the Database connection and saving the settings again.The error does nopt appear always only at times Couls you please tell me how I can avoid this error from creeping up.Because I have found that at some time or the other this error comes up and so far I have not been able to find a solution.
Best Regards John Kunchandy
-- Christian Theune - ct@gocept.com gocept gmbh & co.kg - schalaunische strasse 6 - 06366 koethen/anhalt tel.+49 3641 511586 - fax.+49 3496 3099118 mob. - +49 179 7808366 reduce(lambda x,y:x+y,[chr(ord(x)^42) for x in 'zS^BED\nX_FOY\x0b'])
participants (2)
-
Christian Theune -
zope