[Zope] psycopg import error

[Rowan Woodhouse]

Ok, look at the error message again. It says

raise ImportError("psycopg version mismatch (imported %s)" %
ImportError: psycopg version mismatch (imported 2.0.11 (dt dec ext pq3))

so the version being reported back is '2.0.11 (dt dec ext pq3)' not '2.0.11'

Rowan

Amir wrote:
> Things that i have noticed
> 
> 1)running and importing psycopg2
> 
> gives this error
> 
> Traceback (most recent call last):
>   File "<stdin>", line 1, in ?
>   File "/usr/lib/python2.4/site-packages/psycopg2/__init__.py", line 60, in
> ?
>     from _psycopg import BINARY, NUMBER, STRING, DATETIME, ROWID
> ImportError: /usr/lib/python2.4/site-packages/psycopg2/_psycopg.so:
> undefined symbol: PyUnicodeUCS2_Decode
> 
> 2) for some reason in the Python-2.4.3/lib/python2.4/site-packages/psycopg2
> it has psycopg1.py so when i open it, it
> says in order to import do:- "from psycopg2 import psycopg1 as psycopg"(also
> says to run in psycopg1.1.x compatible mode) and if i do import it this way
> it gives me this error
> 
> Traceback (most recent call last):
>   File "<stdin>", line 1, in ?
>   File "/usr/lib/python2.4/site-packages/psycopg2/__init__.py", line 55, in
> ?
>     from psycopg2 import tz
> ImportError: cannot import name tz
> 
> I am thinking there is something in 2) is this normal?
> 
> 
> 
> ps : 2.0.11 is in the allowed psycopg ALLOWED_PSYCOPG_VERSIONS =
> ('2.0.7','2.0.8','2.0.9','2.0.10', '2.0.11')
> 
> 
> Regards,
> Amir
> 
> tlc2
> 
> On Wed, Jun 24, 2009 at 10:56 AM, Rowan Woodhouse <
> rwoodhouse at wirelessmeasurement.com> wrote:
> 
>> I had the same problem but found that if I just modified the list of
>> acceptable psycopg versions everything worked fine.
>>
>> Rowan
>>
>> Amir wrote:
>>> Hey,
>>>       yes i have it installed at
>>> instance/Python-2.4.3/lib/python2.4/site-packages/psycopg2  and i had
>> also
>>> moved the adapter to the
>>> instance/client1/Products folder, but still it is giving me the version
>>> mismatch error. Also i checked the psycopg* in my system but
>>> over there also i can see that it is correct version that has been
>> installed
>>> /usr/lib/python2.4/site-packages/psycopg2 .
>>>
>>> Regards,
>>> Amir
>>>
>>> tlc2
>>>
>>> On Tue, Jun 23, 2009 at 3:41 PM, Thomas Bennett <bennetttm at appstate.edu
>>> wrote:
>>>
>>>> Have you installed psycopg2 2.0.11, not the adapter but the library for
>>>> python?  and is it in the python path for your Zope python?
>>>>
>>>> I'm thinking you have psycopg not psycopg2 installed as your python
>> library
>>>> and the psycopg2 adapter.  There is no psycopg 2.0.11.
>>>>
>>>> I am assuming this is still how psycopg is installed, the library and
>> the
>>>> DA
>>>> product.
>>>>
>>>> http://initd.org/pub/software/psycopg/
>>>>
>>>>
>>>> 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 at 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 )
>>>>
>>>
>>> ------------------------------------------------------------------------
>>>
>>> _______________________________________________
>>> Zope maillist  -  Zope at 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 )
>> _______________________________________________
>> Zope maillist  -  Zope at 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 )
>>
>