florian.schuler at braunconsulting
Sep 18, 2001, 1:29 AM
Post #1 of 2
(529 views)
Permalink
|
|
Zope and ZPyGreSQL Help wanted !!!
|
|
Hello list,
I´ve 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´ll 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.
When my ZPyGreSQL DA want to read ( select * from table where
username='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´t made withe a '*'. For example, 'select username from person;'
works fine.
I´m 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)
|
