[Zope] Z SQL test in the ZMI aborts on key error

[Dennis Allison]

I've never had any problem with parameterless queries.  (-:

No, this is a simple case of a parameter somehow being lost in 
the ZMI interface.  


On Tue, 7 Jun 2005, Joe Bezier wrote:

> Hi there,
> 
> By any chance are you trying to test a ZSQL method that doesn't 
> (shouldn't) need any query parameters? For some reason (and I'm not the 
> guy who can tell you why...) these types of tests always break - try 
> adding '?query=' to the end of the URL. and see if that helps.
> 
> Cheers,
> 
> Joe.
> On 7 Jun 2005, at 11:41, Dennis Allison wrote:
> 
> > Zope 2.7.6
> > Python 2.3.5
> > MySQLDA-1.2.1c3
> > ZMYSQLDA-2.09b3
> >
> >
> > Site Error
> >
> > An error was encountered while publishing this resource.
> >
> > Error Type: KeyError
> > Error Value: 'query'
> >
> > Troubleshooting Suggestions
> >
> >     * This resource may be trying to reference a nonexistent object or
> > variable 'query'.
> >     * The URL may be incorrect.
> >     * The parameters passed to this resource may be incorrect.
> >     * A resource that this resource relies on may be encountering an
> > error.
> >
> >
> > ----------
> > Error log:
> >
> >  2005/06/07 03:33:03.344 GMT-7
> > User Name (User Id) allison (allison)
> > Request URL http://group1.agilemind.com/Scratch/simpleq/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'
> >
> >
> > There does not seem to be a bug like this in the collectors.
> >
> > Any help/pointers appreciated.
> >
> >
> > _______________________________________________
> > Zope maillist  -  Zope at 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 )
> >
> 
> 
> 		
> ___________________________________________________________ 
> How much free photo storage do you get? Store your holiday 
> snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com
> 

-- 
Dennis Allison * Computer Systems Laboratory * Gates 227
               * Stanford University *  Stanford CA  94305
	       * (650) 723-9213 * (650) 723-0033 fax
	       * allison at shasta.stanford.edu
	       * allison at sumeru.stanford.edu