[Zope] psycopg import error

[Thomas Bennett]

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/
==========================================