[Zope-DB] ZPygreSQL and empty columns

[Florian Schuler]

Hello List,

I posted yesterday because of my problem with the Zopeproduct
'Proiektor'. I=B4ve thought that the errors belong the ZPyGreSQL DA.
Today, I found out that these error Messages only occures if a field
(column) in a table is empty.

For example: select * from person; -- Error

if I fill up all empty tables and do a select * no error occures

Is there a special option for PostGres to beware of this error.

Thnks in advance

Florian



Table person:
---------------

id | email | password  | containertype | phone | comments | firstname |
lastname | middlename | title |            roles           =20
| containerid | username
----+-------+-----------+---------------+-------+----------+-----------+=

----------+------------+-------
+-----------------------------+-------------+-----------
  1 |       | proiektor | PersonGroup   |       |          |           =
|
|            | GOD   |=20

ManageGroups,ManageProjects |           1 | proiektor
(1 row)


Error Type: KeyError
Error Value: errorvonFlo
...
=20
 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
=20
/usr/lib/Zope-2.3.3-src/lib/python/Products/Proiektor/UserFolderSupport.=

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

 py, line 121, in cookieValidate
     (Object: Traversable)
   File
=20
/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)