Deleted product breaks SQL_Method Advanced tab - How to fix?
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
How can I remove this object from the zodb? How do I find it?
Any idea why SQL_Method even cares about this?
there was a longish thread about this recently (search for something like 'Data.fs corrupted?!'). the upshot was, i think, that products that haven't been written carefully can cause problems like this because they don't get cleaned up from the DB when they're erased. seemingly random relationships between products (like yours) are often reported but rarely investigated. the possible solutions suggested were: 1) truncate your FileStorage (yuk) 2) reinstall the offending product, then go into the ZODB via the debugger, and do some surgery (yuk) 3) export all your objects, get a fresh Data.fs, reimport them (yuk)
participants (2)
-
Brad Clements -
seb bacon