[Zope] - re: ZSolidDA name error? additional info

BScherer@mobile.bam.com BScherer@mobile.bam.com
8 Jan 99 10:47:05 EST


As usual, I spoke too soon.  I clicked on the Browse tab of the DA details page and got a 'Sorry, an error occured'.  The source of this reveals:

----------------------------------------------------------
Traceback (innermost last):
  File /usr/local/src/Zope-1.9.0-src/lib/python/ZPublisher/Publish.py, line 870, in publish_module
  File /usr/local/src/Zope-1.9.0-src/lib/python/ZPublisher/Publish.py, line 583, in publish
    (Info: /zopeland/Solid_database_connection/manage_browse)
  File /usr/local/src/Zope-1.9.0-src/lib/python/Globals.py, line 234, in __call__
    (Object: manage_browse)
  File /usr/local/src/Zope-1.9.0-src/lib/python/DocumentTemplate/DT_String.py, line 514, in __call__
    (Object: manage_browse)
  File /usr/local/src/Zope-1.9.0-src/lib/python/TreeDisplay/TreeTag.py, line 166, in render
    (Object: a tree tag)
  File /usr/local/src/Zope-1.9.0-src/lib/python/TreeDisplay/TreeTag.py, line 256, in tpRender
    (Object: RoleManager)
  File /usr/local/src/Zope-1.9.0-src/lib/python/TreeDisplay/TreeTag.py, line 493, in tpRenderTABLE
    (Object: RoleManager)
    (Info: ([85, []], {'childless_decoration': '', 'id': 'tpId', 'branches': 'tpValues', 'header': 'info', 'url': 'tpURL'}, ([85, []],), ([85, []],)))
  File /usr/local/src/Zope-1.9.0-src/lib/python/TreeDisplay/TreeTag.py, line 310, in tpRenderTABLE
    (Object: ACTIVITY_CODES)
  File lib/python/Products/ZSolidDA/DABase.py, line 183, in tpValues
    (Object: ACTIVITY_CODES)
  File lib/python/Products/ZSolidDA/db.py, line 293, in columns
NameError: error

---------------------------------------------------------

The relevant code is:
---------------------------------------------------------
   def columns(self, table_name):
        stmt=self.stmt
        try: self._apply(SQLExecDirect,
                         (stmt, 'select * from %s where 1=2' % table_name))
293 --> except error, v:
            state, native, mess = v
            raise error, "%s (%s)" % (mess, state)
---------------------------------------------------------

So, error is not defined at this point.  Removing it and leaving v shows that v is not defined here either.  I have an idea what these should be, but I'm certain there's a Zopitista(o) out there that knows for sure..

Thanks

Bill