looks like DA.py is using psycopg2.__version__ not psycopg2.__version__[:5] with the index of 5. You might want to check that. Also, psycopg2.__version__[:5] is 2.0.1 not 2.0.11 and 2.0.1 is not in the list on my install from today. The index should be 6 not 5 for versions higher than 2.0.9 .
On my machine with python 2.5.2 >> import psycopg2 >>> psycopg2.__version__[:5] '2.0.1' >>> psycopg2.__version__ '2.0.11 (dt dec ext pq3)' You might want to undo all of your changes and change the index to 6. If this is the case let me know and I will send a bug report to the author. Thomas On Tuesday 23 June 2009 16:06:03 Amir wrote: > Hi, > I have (Zope 2.9.4-final, python 2.4.3, linux2) and I have used > psycopg2.0.11 adapter to connect Zope to Postgresql but I am getting this > error when I try to add the connection object the error is :- > > Error Type: ImportError > > Error Value: psycopg version mismatch (imported 2.0.11 (dt dec ext pq3)) > > while the event log traceback shows that :- > > 2009-06-23T10:55:49 ERROR Shared.DC.ZRDB.Connection Error connecting to > relational database. > Traceback (most recent call last): > File "/opt/Plone-2.5/lib/python/Shared/DC/ZRDB/Connection.py", line 71, > in __setstate__ > try: self.connect(self.connection_string) > File "/opt/Plone-2.5/zeocluster/client1/Products/ZPsycopgDA/DA.py", line > 120, in connect > raise ImportError("psycopg version mismatch (imported %s)" % > ImportError: psycopg version mismatch (imported 2.0.11 (dt dec ext pq3)) > > I would appreciate for an answer asap. > > Thanks > Amir > > tlc2 > > *** > * -- Normally I'm against big things, I think the world is going to be saved by millions of small things. Too many things can go wrong when they get big. - Pete Seeger at his 90th birthday party Sunday May 3, 2009 ========================================== Thomas McMillan Grant Bennett Appalachian State University Operations & Systems Analyst P O Box 32026 University Library Boone, North Carolina 28608 (828) 262 6587 Library Systems Help Desk: https://www.library.appstate.edu/help/ ========================================== _______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )