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

Dennis Allison wrote:
> Failure occurs with 
>       Zope 2.7.6 final
>       Python 2.3.5 or Phython 2.4.1
>       MySQLdb 1.2.1 gamma or MySQLdb 1.1.1 final
>       ZMySQLDA 2.08 or ZMYSQLDA 2.09
> Failure does not occur with 
>       Zope 2.6.4
>       python 2.3.5
>       MySQLdb 1.1.1 final
>       ZMySQLDA 2.08
> 
> The traceback is:
> 
> Time  2005/06/07 16:47:44.967 GMT-7
> User Name (User Id) allison (allison)
> Request URL http://dev.agilemind.com/draPlay/webpagetest/manage_test
> Exception Type KeyError
> Exception Value 'query'
> 
> 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'
> 
> Failure is highly repeatable and happens for queries of the form
> 
>       select * from table
> 
> The REQUEST shows:
> 
> form
> SUBMIT 'Submit Query'
> cookies
> tree-s 'eJzTyCkw5NLIKTDiClZ3hANXW3WuAmOuxEQ9AIOOB9Q'
> __ac_name 'allison'
> lazy items
> SESSION <bound method SessionDataManager.getSessionData of 
> <SessionDataManager instance at 40ddef50>>
> other
> n_ 5
> 
> REQUEST_METHOD'GET'
> HTTP_KEEP_ALIVE'300'
> SERVER_PROTOCOL'HTTP/1.1'
> QUERY_STRING'SUBMIT=Submit+Query'
> 
> Somewhere between manage_testForm and manage_test something fails,
> possibly as the query goes off to be rendered through the DocumentTemplate
> mechanism.  Right at the moment, I'm stuck.  Advice, clues appreciated.

Thanks for the detailed report.  I can reproduce the bug, which is not
related to MySQL.  Please try the attached patch:  if it works for you,
please submit a collector issue, attaching the patch, at:

  http://www.zope.org/Collectors/Zope


Tres.
- --
===================================================================
Tres Seaver          +1 202-558-7113          [EMAIL PROTECTED]
Palladion Software   "Excellence by Design"    http://palladion.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCpva0+gerLs4ltQ4RAl7/AJ93qN07EWszJFiRwi+hYgVctEtuBQCgrDwc
+L+86GkTxdmy+l9ql9pHr7A=
=pduQ
-----END PGP SIGNATURE-----
--- lib/python/Shared/DC/ZRDB/dtml/customDefaultReport.dtml	2005-05-06 10:33:25.000000000 -0400
+++ lib/python/Shared/DC/ZRDB/dtml/customDefaultReport.dtml.patched	2005-06-08 09:40:52.045347424 -0400
@@ -3,7 +3,7 @@
 
       <dtml-if previous-sequence>
 
-        <a href="&dtml-URL;&dtml-sequence-query;query_start=&dtml-previous-sequence-start-number;">
+        <a href="&dtml-URL;?query_start=&dtml-previous-sequence-start-number;&query=<dtml-var query url_quote missing=''>">
         (Previous <dtml-var previous-sequence-size> results)
         </a>
 
@@ -22,7 +22,8 @@
       %(else no_table)[</table>%(else)]
 
       <dtml-if next-sequence>
-        <a href="&dtml-URL;&dtml-sequence-query;query_start=&dtml-next-sequence-start-number;">
+         <a href="&dtml-URL;?query_start=&dtml-next-sequence-start-number;&query=<dtml-var query url_quote missing=''>">
+
          (Next <dtml-var next-sequence-size> results)
          </a>
 
_______________________________________________
Zope maillist  -  Zope@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 )

Reply via email to