Thanks you Andrew, for the great help and support you are giving for OIO
While struggling with different date format options in Postgres, found a
setting for the two DB connections in OIO installation. - whether to use
Zope's datetime or mxDatetime module. When I chose mxDatetime, it worked,
OIO page came up!
Thanks once again,
----- Original Message -----
From: "Andrew Ho" <aho@...>
To: "Pradeep" <ppachan@...>
Sent: Saturday, January 18, 2003 4:49 AM
Subject: Re: Date format issue in OIO installation
> According the the traceback, the error occured when Zope's DateTime
> type's syntax checker could not recognize the "2002-12-29 13:42:10+05"
> time stamp string - being returned from PostgreSQL via the Psycopg
> adaptor. The string appears to be a proper ISO style datetime string. So,
> there is something wrong with Zope.
> Here are some ideas and suggestions for fixing this problem:
> 1) This may be a problem caused by Zope 2.6.0 's DateTime.py method.
> See here for explanation and fix:
> 2) Maybe you can bypass the problem by changing the default datestyle
> returned by PostgreSQL. It appears that you are currently using the ISO
> style (e.g. 1997-12-17 07:37:16-08) - you can try the SQL style (e.g.
> 12/17/1997 07:37:16.00 PST) to see if it works. see here for details
> about changing datestyle:
> 3) Use Zope-2.5.1 instead of Zope-2.6.0. However, I do recall a
> successful install of OIO on Zope-2.6.0 by the UCLA Hospital group.
> Best regards,
> Andrew P. Ho, M.D.
> OIO: Open Infrastructure for Outcomes
> On Sat, 18 Jan 2003, Pradeep wrote:
> > Thanks Andrew.
> > Given below is the trace from the HTML page.
> > Regards,
> > Pradeep
> > Zope Error
> > Zope has encountered an error while publishing this resource.
> > Error Type: Invalid Date-Time String
> > Error Value: 2002-12-29 13:42:10+05
> > Troubleshooting Suggestions
> > a.. The URL may be incorrect.
> > b.. The parameters passed to this resource may be incorrect.
> > c.. A resource that this resource relies on may be encountering
> > error.
> > For more detailed information about the error, please refer to the
> > HTML source for this page.
> > If the error persists please contact the site maintainer. Thank
> > for your patience.
> > Traceback (innermost last):
> > a.. Module ZPublisher.Publish, line 150, in publish_module
> > b.. Module ZPublisher.Publish, line 114, in publish
> > c.. Module Zope, line 171, in zpublisher_exception_hook
> > d.. Module ZPublisher.Publish, line 98, in publish
> > e.. Module ZPublisher.mapply, line 88, in mapply
> > f.. Module ZPublisher.Publish, line 39, in call_object
> > g.. Module OFS.DTMLDocument, line 131, in __call__
> > h.. Module DocumentTemplate.DT_String, line 474, in __call__
> > i.. Module OFS.DTMLDocument, line 124, in __call__
> > j.. Module DocumentTemplate.DT_String, line 474, in __call__
> > k.. Module DocumentTemplate.DT_In, line 628, in renderwob
> > l.. Module DocumentTemplate.DT_Util, line 201, in eval
> > __traceback_info__: display_form
> > m.. Module <string>, line 2, in f
> > n.. Module Shared.DC.ZRDB.DA, line 421, in __call__
> > o.. Module Products.ZPsycopgDA.db, line 203, in query
> > p.. Module Products.ZPsycopgDA.DA, line 113, in cast_DateTime
> > q.. Module DateTime.DateTime, line 652, in __init__
> > r.. Module DateTime.DateTime, line 1023, in _parse
> > Invalid Date-Time String: (see above)
> > ----- Original Message -----
> > From: "Andrew Ho" <aho@...>
> > To: "Pradeep Achan" <ppachan@...>
> > Cc: <open-outcomes-general@...>
> > Sent: Friday, January 17, 2003 1:23 AM
> > Subject: Re: Date format issue in OIO installation
> > > On Sun, 12 Jan 2003, Pradeep Achan wrote:
> > >
> > > > Andrew,
> > > >
> > > > As per your suggestion, we installed the new psycopg.zip module and
> > > > errors on
> > > > the console vanished.
> > >
> > > Excellent!
> > >
> > > ...
> > > > Error Type: Invalid Date-Time String
> > > > Error Value: 2002-12-29 13:42:10+05
> > > >
> > > > Any suggestions?
> > >
> > > Pradeep, did you have a chance to look at the trace-back output? You
> > > to view the HTML source of the error page to see the trace-back info
> > > of Zope-2.5+). If you can send me that information, I can try to
> > > the problem and try to reproduce it.
> > >
> > > Otherwise, if you can give me access to your machine (by providing a
> > > and login info), I can try to debug it for you.
> > >
> > > Best regards,
> > >
> > > Andrew
> > > ---
> > > Andrew P. Ho, M.D.
> > > OIO: Open Infrastructure for Outcomes
> > > http://www.TxOutcome.Org
> > >