[Erp5-dev] ERP5 - delete object

[pavel lstiburek]

hi,

I am trying to delete some events objects in my erp5 site, but when i
select few events and clkck on delete button. I get error message:
"*Error Type: ValueError *
*Error Value: Cannot remap a column to another table. column_map[(None,
'start_date')] = 'delivery', new = 'listbox_delivery' *"

Anyone know, how to fix this problem, or what caused this?

Exception traceback

Time2012/03/26 11:14:26.952014 GMT+2User Name (User Id)zope
(zope)Exception TypeValueErrorException ValueCannot remap a column to
another table. column_map[(None, 'start_date')] = 'delivery', new =
'listbox_delivery'

Traceback (innermost last):

- Module ZPublisher.Publish, line 127, in publish
- Module ZPublisher.mapply, line 77, in mapply
- Module ZPublisher.Publish, line 47, in call_object
- Module Shared.DC.Scripts.Bindings, line 324, in __call__
- Module Shared.DC.Scripts.Bindings, line 361, in _bindAndExec
- Module Products.PythonScripts.PythonScript, line 344, in _exec
- Module script, line 28, in Folder_deleteObjectList
*<PythonScript at /erp5/Folder_deleteObjectList used for /erp5/event_module>*
*Line 28*
- Module Products.ERP5Form.Form, line 651, in __call__
- Module Products.PageTemplates.ZopePageTemplate, line 432, in pt_render
- Module Products.PageTemplates.PageTemplate, line 80, in pt_render
- Module zope.pagetemplate.pagetemplate, line 113, in pt_render
*Warning: Macro expansion failed*
*Warning: <type 'exceptions.NameError'>: name 'page_template' is not defined*
- Module zope.tal.talinterpreter, line 271, in __call__
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 533, in do_optTag_tal
- Module zope.tal.talinterpreter, line 518, in do_optTag
- Module zope.tal.talinterpreter, line 513, in no_tag
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 858, in do_defineMacro
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 533, in do_optTag_tal
- Module zope.tal.talinterpreter, line 518, in do_optTag
- Module zope.tal.talinterpreter, line 513, in no_tag
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 888, in do_useMacro
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 533, in do_optTag_tal
- Module zope.tal.talinterpreter, line 518, in do_optTag
- Module zope.tal.talinterpreter, line 513, in no_tag
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 533, in do_optTag_tal
- Module zope.tal.talinterpreter, line 518, in do_optTag
- Module zope.tal.talinterpreter, line 513, in no_tag
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 888, in do_useMacro
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 533, in do_optTag_tal
- Module zope.tal.talinterpreter, line 518, in do_optTag
- Module zope.tal.talinterpreter, line 513, in no_tag
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 533, in do_optTag_tal
- Module zope.tal.talinterpreter, line 518, in do_optTag
- Module zope.tal.talinterpreter, line 513, in no_tag
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 888, in do_useMacro
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 533, in do_optTag_tal
- Module zope.tal.talinterpreter, line 518, in do_optTag
- Module zope.tal.talinterpreter, line 513, in no_tag
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 533, in do_optTag_tal
- Module zope.tal.talinterpreter, line 518, in do_optTag
- Module zope.tal.talinterpreter, line 513, in no_tag
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 954, in do_defineSlot
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 533, in do_optTag_tal
- Module zope.tal.talinterpreter, line 518, in do_optTag
- Module zope.tal.talinterpreter, line 513, in no_tag
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 946, in do_defineSlot
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 533, in do_optTag_tal
- Module zope.tal.talinterpreter, line 518, in do_optTag
- Module zope.tal.talinterpreter, line 513, in no_tag
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 946, in do_defineSlot
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 533, in do_optTag_tal
- Module zope.tal.talinterpreter, line 518, in do_optTag
- Module zope.tal.talinterpreter, line 513, in no_tag
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 946, in do_defineSlot
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 533, in do_optTag_tal
- Module zope.tal.talinterpreter, line 518, in do_optTag
- Module zope.tal.talinterpreter, line 513, in no_tag
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 533, in do_optTag_tal
- Module zope.tal.talinterpreter, line 518, in do_optTag
- Module zope.tal.talinterpreter, line 513, in no_tag
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 852, in do_condition
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 821, in do_loop_tal
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 533, in do_optTag_tal
- Module zope.tal.talinterpreter, line 518, in do_optTag
- Module zope.tal.talinterpreter, line 513, in no_tag
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 531, in do_optTag_tal
- Module zope.tal.talinterpreter, line 513, in no_tag
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 742, in do_insertStructure_tal
- Module Products.PageTemplates.Expressions, line 220, in evaluateStructure
- Module zope.tales.tales, line 696, in evaluate
*URL: /erp5/form_dialog*
*Line 105, Column 14*
*Expression: <PythonExpr field.render(value, request)>*
*Names:*

{'container': <ERP5Site at /erp5>,
'context': <Event Module at /erp5/event_module>,
'default': <object object at 0x7fa4bba734a0>,
'form': <ERP5Form at /erp5/Folder_viewDeleteDialog used for
/erp5/event_module>,
'here': <Event Module at /erp5/event_module>,
'key_prefix': None,
'loop': {u'field':
<Products.PageTemplates.Expressions.PathIterator object at
0x7fa4a24d5450>},
'nothing': None,
'options': {'REQUEST': <HTTPRequest,
URL=.../erp5/event_module/Folder_deleteObjectList>,
'args': (),
'uids': [23420, 22798]},
'repeat': <Products.PageTemplates.Expressions.SafeMapping object
at 0x7fa48c6bee10>,
'request': <HTTPRequest, URL=.../erp5/event_module/Folder_deleteObjectList>,
'root': <Application at >,
'template': <ERP5Form at /erp5/Folder_viewDeleteDialog used for
/erp5/event_module>}

- Module Products.PageTemplates.ZRPythonExpr, line 49, in __call__
__traceback_info__: field.render(value, request)
- Module PythonExpr, line 1, in <expression>
- Module Products.Formulator.Field, line 279, in render
- Module Products.Formulator.Field, line 208, in _render_helper
__traceback_info__: key=field_listbox value=None
- Module Products.ERP5Form.ProxyField, line 82, in __call__
- Module Products.ERP5Form.ListBox, line 485, in render
- Module Products.ERP5Form.ListBox, line 2093, in __call__
- Module Products.ERP5Form.ListBox, line 2652, in render
- Module Shared.DC.Scripts.Bindings, line 324, in __call__
- Module Shared.DC.Scripts.Bindings, line 361, in _bindAndExec
- Module Products.PageTemplates.ZopePageTemplate, line 335, in _exec
- Module Products.PageTemplates.ZopePageTemplate, line 432, in pt_render
- Module Products.PageTemplates.PageTemplate, line 80, in pt_render
- Module zope.pagetemplate.pagetemplate, line 113, in pt_render
*Warning: Macro expansion failed*
*Warning: <type 'exceptions.NameError'>: name 'real_context' is not
defined*
- Module zope.tal.talinterpreter, line 271, in __call__
- Module zope.tal.talinterpreter, line 343, in interpret
- Module zope.tal.talinterpreter, line 583, in do_setLocal_tal
- Module zope.tales.tales, line 696, in evaluate
*URL: /erp5/ListBox_asHTML*
*Line 1, Column 0*
*Expression: <PathExpr standard:u'here/query'>*
*Names:*

{'container': <ERP5Site at /erp5>,
'context': <Products.ERP5Form.ListBox.ListBoxRendererContext
object at 0x7fa4a24d5210>,
'default': <object object at 0x7fa4bba734a0>,
'here': <Products.ERP5Form.ListBox.ListBoxRendererContext object
at 0x7fa4a24d5210>,
'loop': {},
'nothing': None,
'options': {'args': ()},
'repeat': <Products.PageTemplates.Expressions.SafeMapping object
at 0x7fa4920061b0>,
'request': <HTTPRequest, URL=.../erp5/event_module/Folder_deleteObjectList>,
'root': <Application at >,
'template': <ZopePageTemplate at /erp5/ListBox_asHTML used for
/erp5/Folder_viewDeleteDialog/listbox>,
'traverse_subpath': [],
'user': <User 'zope'>}

- Module zope.tales.expressions, line 217, in __call__
- Module Products.PageTemplates.Expressions, line 157, in _eval
- Module Products.PageTemplates.Expressions, line 119, in render
- Module Products.ERP5Form.ListBox, line 2014, in query
- Module Products.ERP5Form.ListBox, line 1977, in getReportSectionList
- Module Products.ERP5Form.Selection, line 238, in __call__
- Module Shared.DC.Scripts.Bindings, line 324, in __call__
- Module Shared.DC.Scripts.Bindings, line 361, in _bindAndExec
- Module Products.PythonScripts.PythonScript, line 344, in _exec
- Module script, line 12, in Folder_getDeleteObjectList
*<PythonScript at /erp5/Folder_getDeleteObjectList used for
/erp5/event_module>*
*Line 12*
- Module AccessControl.ZopeGuards, line 358, in guarded_apply
- Module AccessControl.ZopeGuards, line 380, in builtin_guarded_apply
- Module Products.ERP5Catalog.CatalogTool, line 642, in searchResults
- Module Products.ZSQLCatalog.ZSQLCatalog, line 1067, in searchResults
- Module Products.ZSQLCatalog.SQLCatalog, line 2453, in searchResults
- Module Products.ZSQLCatalog.SQLCatalog, line 2447, in queryResults
- Module Products.ZSQLCatalog.SQLCatalog, line 2427, in _queryResults
- Module Products.ZSQLCatalog.SQLCatalog, line 2355, in buildSQLQuery
- Module Products.ZSQLCatalog.Query.EntireQuery, line 101, in
asSQLExpression
- Module Products.ZSQLCatalog.Query.ComplexQuery, line 207, in
registerColumnMap
- Module Products.ZSQLCatalog.ColumnMap, line 118, in registerColumn
- Module Products.ZSQLCatalog.ColumnMap, line 461, in resolveColumn

ValueError: Cannot remap a column to another table. column_map[(None,
'start_date')] = 'delivery', new = 'listbox_delivery'