[Pkg-zope-developers] Bug#305807: marked as done (zope2.7: KeyError in ZRDB.DA)

Debian Bug Tracking System owner at bugs.debian.org
Mon Jul 18 13:18:28 UTC 2005


Your message dated Mon, 18 Jul 2005 09:02:15 -0400
with message-id <E1DuVGB-00057Z-00 at newraff.debian.org>
and subject line Bug#305807: fixed in zope2.7 2.7.5-3
has caused the attached Bug report to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere.  Please contact me immediately.)

Debian bug tracking system administrator
(administrator, Debian Bugs database)

--------------------------------------
Received: (at submit) by bugs.debian.org; 22 Apr 2005 09:56:33 +0000
>From jerome at simplet.unice.fr Fri Apr 22 02:56:33 2005
Return-path: <jerome at simplet.unice.fr>
Received: from taloa.unice.fr [134.59.1.7] 
	by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
	id 1DOutl-0007xD-00; Fri, 22 Apr 2005 02:56:33 -0700
Received: from naxos2.unice.fr (naxos2.unice.fr [134.59.1.112])
	by taloa.unice.fr (8.13.1/8.13.1) with ESMTP id j3M9uUN6010098
	for <submit at bugs.debian.org>; Fri, 22 Apr 2005 11:56:30 +0200
Received: from localhost (localhost.localdomain [127.0.0.1])
	by naxos2.unice.fr (8.13.1/8.13.1) with ESMTP id j3M9uqgR013723
	for <submit at bugs.debian.org>; Fri, 22 Apr 2005 11:56:52 +0200
Received: from naxos2.unice.fr ([127.0.0.1])
 by localhost (naxos2.unice.fr [127.0.0.1]) (amavisd-new, port 10024)
 with LMTP id 13708-01 for <submit at bugs.debian.org>;
 Fri, 22 Apr 2005 11:56:52 +0200 (CEST)
Received: from simplet.unice.fr (simplet.unice.fr [134.59.53.17])
	by naxos2.unice.fr (8.13.1/8.13.1) with ESMTP id j3M9u3qd013478
	for <submit at bugs.debian.org>; Fri, 22 Apr 2005 11:56:04 +0200
Received: from jerome by simplet.unice.fr with local (Exim 4.50)
	id 1DOusp-0004AP-Ih; Fri, 22 Apr 2005 11:55:35 +0200
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: Jerome Alet <jerome at simplet.unice.fr>
To: Debian Bug Tracking System <submit at bugs.debian.org>
Subject: zope2.7: KeyError in ZRDB.DA
X-Mailer: reportbug 3.9
Date: Fri, 22 Apr 2005 11:55:35 +0200
Message-Id: <E1DOusp-0004AP-Ih at simplet.unice.fr>
X-Virus-Scanned: by amavisd-new at unice.fr
Delivered-To: submit at bugs.debian.org
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02 
	(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-8.0 required=4.0 tests=BAYES_00,HAS_PACKAGE 
	autolearn=no version=2.60-bugs.debian.org_2005_01_02
X-Spam-Level: 

Package: zope2.7
Version: 2.7.5-1
Severity: normal


There's a bug which occurs when BOTH of the following conditions are met :

	- Create a ZSQL method of the SELECT type, with NO ARGUMENT.

		e.g. : SELECT * FROM mytable;

	- Have an SQL database (I use PostgreSQL) in which THERE ARE
	  SOME DATAS which match the SQL SELECT query defined above.

	- Click on the Test tab for the ZSQL query, then on the
	  submit button.

The error is in the result rendering code, around line 337 of
Shared/DC/ZRDB/DA.py

Traceback :

Traceback (innermost last):
  Module ZPublisher.Publish, line 101, in publish
    Module ZPublisher.mapply, line 88, in mapply
      Module ZPublisher.Publish, line 39, in call_object
        Module Shared.DC.ZRDB.DA, line 337, in manage_test
	  Module DocumentTemplate.DT_String, line 474, in __call__
	    Module DocumentTemplate.DT_In, line 602, in renderwb
	      Module DocumentTemplate.DT_Var, line 219, in render
	      KeyError: 'query'
	      
	  
The error seems to occur because the query has no parameter (argument)
defined, then the rendering doesn't find the 'query' field.

The error doesn't occur if there's no data which match the SELECT query,
for example with an empty table it works fine.

I wasn't able to exactly understand where to add an hidden and empty
'query' field to the rendered template to quickly fix the problem,
so I can't send a patch. Sorry.

hoping this helps

bye

Jerome Alet

-- System Information:
Debian Release: 3.1
  APT prefers unstable
  APT policy: (500, 'unstable')
Architecture: i386 (i686)
Kernel: Linux 2.4.27-2-686-smp
Locale: LANG=fr_FR at euro, LC_CTYPE=fr_FR at euro (charmap=ISO-8859-15)

Versions of packages zope2.7 depends on:
ii  adduser                     3.63         Add and remove users and groups
ii  debconf                     1.4.48       Debian configuration management sy
ii  dpkg                        1.10.27      Package maintenance system for Deb
ii  libc6                       2.3.2.ds1-21 GNU C Library: Shared libraries an
ii  python2.3                   2.3.5-2      An interactive high-level object-o
ii  python2.3-xml               0.8.4-1      XML tools for Python (2.3.x)

-- debconf information:
  zope/upgrade/2.7:
* zope/tips/2.7:
* zope/tips/standalone_install:
  zope/instance_home/move: true
* shared/zope/restart: end

---------------------------------------
Received: (at 305807-close) by bugs.debian.org; 18 Jul 2005 13:08:14 +0000
>From katie at ftp-master.debian.org Mon Jul 18 06:08:14 2005
Return-path: <katie at ftp-master.debian.org>
Received: from newraff.debian.org [208.185.25.31] (mail)
	by spohr.debian.org with esmtp (Exim 3.36 1 (Debian))
	id 1DuVLy-00051p-00; Mon, 18 Jul 2005 06:08:14 -0700
Received: from katie by newraff.debian.org with local (Exim 3.35 1 (Debian))
	id 1DuVGB-00057Z-00; Mon, 18 Jul 2005 09:02:15 -0400
From: A Mennucc1 <mennucc1 at debian.org>
To: 305807-close at bugs.debian.org
X-Katie: $Revision: 1.56 $
Subject: Bug#305807: fixed in zope2.7 2.7.5-3
Message-Id: <E1DuVGB-00057Z-00 at newraff.debian.org>
Sender: Archive Administrator <katie at ftp-master.debian.org>
Date: Mon, 18 Jul 2005 09:02:15 -0400
Delivered-To: 305807-close at bugs.debian.org
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02 
	(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Level: 
X-Spam-Status: No, hits=-6.0 required=4.0 tests=BAYES_00,HAS_BUG_NUMBER 
	autolearn=no version=2.60-bugs.debian.org_2005_01_02
X-CrossAssassin-Score: 2

Source: zope2.7
Source-Version: 2.7.5-3

We believe that the bug you reported is fixed in the latest version of
zope2.7, which is due to be installed in the Debian FTP archive:

zope2.7_2.7.5-3.diff.gz
  to pool/main/z/zope2.7/zope2.7_2.7.5-3.diff.gz
zope2.7_2.7.5-3.dsc
  to pool/main/z/zope2.7/zope2.7_2.7.5-3.dsc
zope2.7_2.7.5-3_i386.deb
  to pool/main/z/zope2.7/zope2.7_2.7.5-3_i386.deb



A summary of the changes between this version and the previous one is
attached.

Thank you for reporting the bug, which will now be closed.  If you
have further comments please address them to 305807 at bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
A Mennucc1 <mennucc1 at debian.org> (supplier of updated zope2.7 package)

(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmaster at debian.org)


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Format: 1.7
Date: Sun, 17 Jul 2005 20:07:31 +0200
Source: zope2.7
Binary: zope2.7
Architecture: source i386
Version: 2.7.5-3
Distribution: unstable
Urgency: low
Maintainer: Debian Zope team <pkg-zope-developers at lists.alioth.debian.org>
Changed-By: A Mennucc1 <mennucc1 at debian.org>
Description: 
 zope2.7    - Open Source Web Application Server
Closes: 301067 305807 305936 309428 310790 313473 313621 313644
Changes: 
 zope2.7 (2.7.5-3) unstable; urgency=low
 .
   * Kindly warn users trying to use test suites that
     the python-profiler is not in main.
     Thanks martin f krafft (closes: #305936,#301067)
   * Set permission and ownership of inituser.
     Thanks Dmitry E. Oboukhov and Martin f Krafft (closes: #313644,#313621)
   * Error in query using the test "tab" of a ZSQL Method
     Thanks Paolo Alexis Falcone and J Alet (closes: #309428,#305807)
   * Bashism in mkzope2.7instance.
     Thanks  Carlos Laviola and Martin f Krafft (closes: #313473)
   * Stupid awk error.
     Thanks Fabio Tranchitella and martin f krafft (closes: #310790)
Files: 
 1e7fc1d49207c690fc0d8979dfafceb3 894 web optional zope2.7_2.7.5-3.dsc
 55f39f92b9289c66d969e4d4f4f4280a 51911 web optional zope2.7_2.7.5-3.diff.gz
 a29ceae87a6e50081de122837ed776a6 2626176 web optional zope2.7_2.7.5-3_i386.deb

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFC2qK29B/tjjP8QKQRAg/TAJ9DPciFU0EFuoidQbod9VBIq0ujcwCeM0tc
77BxIt95GKerTSOnhaqQrmE=
=90+S
-----END PGP SIGNATURE-----




More information about the Pkg-zope-developers mailing list