Re: [Zope] Z SQL test in the ZMI aborts on key error (query keyerror Solution)

2005-06-08 Thread Allen Schmidt
Found it. Edit lib/python/Shared/DC/dtml/customDefaultReport.dtml Replace what is there with the code below (or compare and change) This is from our 2.7.5 install. dtml-in %(id)s size=20 start=query_start dtml-if sequence-start dtml-if previous-sequence a

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

2005-06-08 Thread Dieter Maurer
Dennis Allison wrote at 2005-6-7 03:41 -0700: 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' Interesting, how long it take to fix trivial errors -- Dieter

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

2005-06-07 Thread Dennis Allison
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'. *

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

2005-06-07 Thread Joe Bezier
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.

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

2005-06-07 Thread Tino Wildenhain
Am Dienstag, den 07.06.2005, 12:03 +0100 schrieb Joe Bezier: 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

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

2005-06-07 Thread 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

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

2005-06-07 Thread Allen Schmidt
This bounced around on the list recently. It is supposed to be fixed now but the solution is modifying the source and changing how the batching is done. It works if less than 20 records returned...blows up if more. You can test this by forcing your query to only return a few records. Can't