[Zope] Re: SQL Session and Gadfly error.

Anthony Baxter Anthony Baxter <anthony@interlink.com.au>
Fri, 05 May 2000 19:28:09 +1000


>>> Hung Jung Lu wrote
> Have you seen an error like 
> 
> Error Type: EOFError
> Error Value: end of stream during parse near :: "f3pqQ'\012AND name"*" = 'person_id'"
> 
> in using SQLSession with Gadfly? Anyway, it's not too important, just to let 
> you know that it seem to happen once in a while. Hard to reproduce, though.

Hm - it looks like something's making gadfly upset. A couple of thoughts...

make sure you're using the oneline form of encoding, or have patched
gadfly to allow newlines in strings.

if you can reproduce it, try putting a 'print' inside 
lib/python/Shared/DC/ZRDB/DA.py to dump out all SQL executed... look for
a line that's something like:
      if src__:
          return query
and put a line before it like
      print "SQL DEBUG:", query

this will send all SQL executed by Zope to stdout.

Obviously this is not something you should do on a busy server unless you're
really sure of yourself (or desperate to track down what's going on...)

Anthony