[Zope] Deleted product breaks SQL_Method Advanced tab - How to fix?

[Brad Clements]

Zope 2.2.2 binary on Linux (also shows up on Windows version)

I'm looking for suggestions on how to fix this, I can't access the 
advanced tab of any of my SQL_Methods.

I had played with some products, deleted them from the file system and 
removed them from the products list in Zope (is order important here?)

Now when I choose Advanced on any SQL Method, I get this:

ImportError

Sorry, a Zope error occurred.

Traceback (innermost last):
  File /home/bkc/door2door/lib/python/ZPublisher/Publish.py, line 222, in publish_module
  File /home/bkc/door2door/lib/python/ZPublisher/Publish.py, line 187, in publish
  File /home/bkc/door2door/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook
    (Object: SQL_GetOrgList)
  File /home/bkc/door2door/lib/python/ZPublisher/Publish.py, line 171, in publish
  File /home/bkc/door2door/lib/python/ZPublisher/mapply.py, line 160, in mapply
    (Object: manage_advancedForm)
  File /home/bkc/door2door/lib/python/ZPublisher/Publish.py, line 112, in call_object
    (Object: manage_advancedForm)
  File /home/bkc/door2door/lib/python/App/special_dtml.py, line 120, in __call__
    (Object: manage_advancedForm)
    (Info: /home/bkc/door2door/lib/python/Shared/DC/ZRDB/advanced.dtml)
  File /home/bkc/door2door/lib/python/DocumentTemplate/DT_String.py, line 528, in __call__
    (Object: manage_advancedForm)
  File /home/bkc/door2door/lib/python/Shared/DC/ZRDB/DA.py, line 508, in manage_product_zclass_info
    (Object: SQL_GetOrgList)
  File /home/bkc/door2door/lib/python/ZODB/Connection.py, line 447, in setstate
ImportError: No module named ZamlBase

And this appears from the python process

2000-11-14T14:42:42 ERROR(200) ZODB Couldn't load state for '\000\000\000\000\000\000\036\031'
Traceback (innermost last):
  File /home/bkc/door2door/lib/python/ZODB/Connection.py, line 447, in setstate
ImportError: No module named ZamlBase

How can I remove this object from the zodb? How do I find it?

Any idea why SQL_Method even cares about this?

Thanks for any suggestions

Brad Clements,                bkc@murkworks.com   (315)268-1000
http://www.murkworks.com                          (315)268-9812 Fax
netmeeting: ils://ils.murkworks.com               AOL-IM: BKClements