[Z3-sqlos] SQLOS Breaks on ZopeX3-3.0.0C2

[Carroll Kong]

Since there was a ton of changes from B2 to B3 in regards to the database, I
was not too surprised some things would break.  I updated to C2, updated
psycopgda to the latest rev, updated sqlos to the latest revision.

I cannot create any new SQLOS containers.  The error message seems pretty
vague.  I don't see why it would error out at IterSelect?

My setup has been pretty static (still using sqlobject 0.6) and it works
100% fine if I use the older psycopgda drivers, older sqlos, and
X3-3.0.0-b2.

Anyone got it working with C2?



Traceback (most recent call last):
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/publisher/publish.py",
line 138, in publish
    result = publication.callObject(request, object)
  File
"/usr/local/ZopeX3-3.0.0c2/lib/python/zope/app/publication/zopepublication.p
y", line 153, in callObject
    return mapply(ob, request.getPositionalArguments(), request)
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/publisher/publish.py",
line 113, in mapply
    return debug_call(object, args)
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/publisher/publish.py",
line 119, in debug_call
    return object(*args)
  File
"/usr/local/ZopeX3-3.0.0c2/lib/python/zope/app/pagetemplate/viewpagetemplate
file.py", line 76, in __call__
    return self.im_func(im_self, *args, **kw)
  File
"/usr/local/ZopeX3-3.0.0c2/lib/python/zope/app/pagetemplate/viewpagetemplate
file.py", line 45, in __call__
    s = self.pt_render(namespace)
  File
"/usr/local/ZopeX3-3.0.0c2/lib/python/zope/pagetemplate/pagetemplate.py",
line 118, in pt_render
    context, output, tal=not source, strictinsert=0)()
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/tal/talinterpreter.py",
line 165, in __call__
    self.interpret(self.program)
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/tal/talinterpreter.py",
line 208, in interpret
    handlers[opcode](self, args)
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/tal/talinterpreter.py",
line 681, in do_useMacro
    self.interpret(macro)
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/tal/talinterpreter.py",
line 208, in interpret
    handlers[opcode](self, args)
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/tal/talinterpreter.py",
line 377, in do_optTag_tal
    self.do_optTag(stuff)
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/tal/talinterpreter.py",
line 362, in do_optTag
    return self.no_tag(start, program)
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/tal/talinterpreter.py",
line 357, in no_tag
    self.interpret(program)
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/tal/talinterpreter.py",
line 208, in interpret
    handlers[opcode](self, args)
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/tal/talinterpreter.py",
line 655, in do_defineMacro
    self.interpret(macro)
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/tal/talinterpreter.py",
line 208, in interpret
    handlers[opcode](self, args)
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/tal/talinterpreter.py",
line 714, in do_defineSlot
    self.interpret(block)
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/tal/talinterpreter.py",
line 208, in interpret
    handlers[opcode](self, args)
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/tal/talinterpreter.py",
line 706, in do_defineSlot
    self.interpret(slot)
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/tal/talinterpreter.py",
line 208, in interpret
    handlers[opcode](self, args)
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/tal/talinterpreter.py",
line 655, in do_defineMacro
    self.interpret(macro)
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/tal/talinterpreter.py",
line 208, in interpret
    handlers[opcode](self, args)
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/tal/talinterpreter.py",
line 427, in do_setLocal_tal
    self.engine.setLocal(name, self.engine.evaluateValue(expr))
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/tales/tales.py", line 698,
in evaluate
    return expression(self)
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/tales/expressions.py",
line 207, in __call__
    return self._eval(econtext)
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/tales/expressions.py",
line 201, in _eval
    return ob()
  File
"/usr/local/ZopeX3-3.0.0c2/lib/python/zope/app/container/browser/contents.py
", line 77, in listContentInfo
    self.addObject()
  File
"/usr/local/ZopeX3-3.0.0c2/lib/python/zope/app/container/browser/contents.py
", line 236, in addObject
    adding.action(request['type_name'], new)
  File
"/usr/local/ZopeX3-3.0.0c2/lib/python/zope/app/container/browser/adding.py",
line 158, in action
    self.add(content)
  File
"/usr/local/ZopeX3-3.0.0c2/lib/python/zope/app/container/browser/adding.py",
line 72, in add
    container[name] = content
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/app/folder/folder.py",
line 97, in __setitem__
    setitem(self, self.data.__setitem__, name, object)
  File
"/usr/local/ZopeX3-3.0.0c2/lib/python/zope/app/container/contained.py", line
568, in setitem
    notify(event)
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/event/__init__.py", line
23, in notify
    subscriber(event)
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/app/event/dispatching.py",
line 65, in dispatch
    for ignored in subscribers(event, None):
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/component/__init__.py",
line 178, in subscribers
    return adapters.subscribers(objects, interface)
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/interface/adapter.py",
line 458, in subscribers
    return [subscription(*objects) for subscription in subscriptions]
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/app/event/objectevent.py",
line 74, in objectEventNotify
    adapters = subscribers((event.object, event), None)
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/component/__init__.py",
line 178, in subscribers
    return adapters.subscribers(objects, interface)
  File "/usr/local/ZopeX3-3.0.0c2/lib/python/zope/interface/adapter.py",
line 458, in subscribers
    return [subscription(*objects) for subscription in subscriptions]
  File
"/usr/local/ZopeX3-3.0.0c2/lib/python/zope/app/container/contained.py", line
175, in dispatchToSublocations
    for sub in subs.sublocations():
  File
"/usr/local/ZopeX3-3.0.0c2/lib/python/zope/app/container/contained.py", line
206, in sublocations
    for key in container:
  File
"/usr/local/ZopeX3-3.0.0c2-inst/lib/python/sqlos/container/__init__.py",
line 85, in keys
    for name, obj in self.items(): yield name
  File
"/usr/local/ZopeX3-3.0.0c2-inst/lib/python/sqlos/container/__init__.py",
line 102, in items
    for obj in factory.select():
  File "/usr/local/lib/python2.3/site-packages/sqlobject/main.py", line
1203, in __iter__
    return conn.iterSelect(self)
  File "/usr/local/lib/python2.3/site-packages/sqlobject/dbconnection.py",
line 501, in iterSelect
    select, keepConnection=True))
TypeError: iteration over non-sequence

- Carroll Kong