[Zope-DB] Zope and ZPyGreSQL Help wanted !!!

[Florian Schuler]

Hello list,

I=B4ve got a problem using Zope 2.3.3  and ZPyGreSQL on PostgreSQL =
7.1.x.
Ok, there are further developed DAs like ZPyGreSQL but the Zope Product
which we want to use just support these adapter.
The Problem is a little bit difficult to explain but i try it and hope
you=B4ll find an awnser.

While installing 'our' product (it is called Proiektor, a Web Based
Project management interface ) it creates some tables in its PostGreSQL
database. One of these tables is the 'person' table. There are all data
of users saved.=20

When my ZPyGreSQL DA want to read ( select * from table where
username=3D'proiektor'; proiektor is the standart user ) out of this
table, immediately a KeyError occurs.

We tried everything. I found out that these error only occurs if the
table which is selected (select * from .. ) is not empty or the select
isn=B4t made withe a '*'. For example, 'select username from person;'
works fine.

I=B4m at the end of my Lathin.

Greetings Florian

The Error:

Error Type: KeyError
Error Value: errorvonFlo

...

Traceback (innermost last):
  File /usr/lib/Zope-2.3.3-src/lib/python/ZPublisher/Publish.py, line
223, in publish_module
  File /usr/lib/Zope-2.3.3-src/lib/python/ZPublisher/Publish.py, line
187, in publish
  File /usr/lib/Zope-2.3.3-src/lib/python/Zope/__init__.py, line 221, =
in
zpublisher_exception_hook
    (Object: Traversable)
  File /usr/lib/Zope-2.3.3-src/lib/python/ZPublisher/Publish.py, line
171, in publish
  File /usr/lib/Zope-2.3.3-src/lib/python/ZPublisher/mapply.py, line
160, in mapply
    (Object: loginAction)
  File /usr/lib/Zope-2.3.3-src/lib/python/ZPublisher/Publish.py, line
112, in call_object
    (Object: loginAction)
  File /usr/lib/Zope-2.3.3-src/lib/python/OFS/DTMLMethod.py, line 189,
in __call__
    (Object: loginAction)
  File =
/usr/lib/Zope-2.3.3-src/lib/python/DocumentTemplate/DT_String.py,
line 540, in __call__
    (Object: loginAction)
  File /usr/lib/Zope-2.3.3-src/lib/python/DocumentTemplate/DT_Try.py,
line 215, in render
  File /usr/lib/Zope-2.3.3-src/lib/python/DocumentTemplate/DT_Try.py,
line 224, in render_try_except
  File /usr/lib/Zope-2.3.3-src/lib/python/DocumentTemplate/DT_Util.py,
line 339, in eval
    (Object: acl_users.validate(REQUEST))
    (Info: acl_users)
  File <string>, line 0, in ?
  File
/usr/lib/Zope-2.3.3-src/lib/python/Products/Proiektor/UserFolderSupport.=

py, line 74, in validate
    (Object: Traversable)
  File
/usr/lib/Zope-2.3.3-src/lib/python/Products/Proiektor/UserFolderSupport.=

py, line 121, in cookieValidate
    (Object: Traversable)
  File
/usr/lib/Zope-2.3.3-src/lib/python/Products/Proiektor/UserFolderSupport.=

py, line 60, in getUser
    (Object: Traversable)
  File /usr/lib/Zope-2.3.3-src/lib/python/Shared/DC/ZRDB/DA.py, line
489, in __call__
    (Object: qry_getPersonWithUserName)
  File /usr/lib/Zope-2.3.3-src/lib/python/Products/ZPyGreSQLDA/db.py,
line 206, in query
KeyError: (see above)