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