c2c_budget account_account_rel missing

[Ferdinand]

trying to print orphaned accounts in budget items

Traceback (most recent call last):
  File "/home/terp/OpenERP/branch/server/5.0/bin/netsvc.py", line 244, in dispatch
    result = LocalService(service_name)(method, *params)
  File "/home/terp/OpenERP/branch/server/5.0/bin/netsvc.py", line 73, in __call__
    return getattr(self, method)(*params)
  File "/home/terp/OpenERP/branch/server/5.0/bin/service/web_services.py", line 635, in execute
    return self._execute(db, uid, wiz_id, datas, action, context)
  File "/home/terp/OpenERP/branch/server/5.0/bin/service/web_services.py", line 615, in _execute
    return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context)
  File "/home/terp/OpenERP/branch/server/5.0/bin/wizard/__init__.py", line 177, in execute
    res = self.execute_cr(cr, uid, data, state, context)
  File "/home/terp/OpenERP/branch/server/5.0/bin/wizard/__init__.py", line 82, in execute_cr
    res['action'] = result_def['action'](self, cr, uid, data, context)
  File "/home/terp/OpenERP/branch/server/5.0/bin/addons/c2c_budget/wizard/validate_budget_structure.py", line 97, in _show_result
    self.account_children_map = self._get_children_map(cr, uid, sql_filters+sql_filters_aa2, context=context)
  File "/home/terp/OpenERP/branch/server/5.0/bin/addons/c2c_budget/wizard/validate_budget_structure.py", line 245, in _get_children_map
    self.cr.execute(query)
  File "/home/terp/OpenERP/branch/server/5.0/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/home/terp/OpenERP/branch/server/5.0/bin/sql_db.py", line 125, in execute
    res = self._obj.execute(query, params)
ProgrammingError: relation "account_account_rel" does not exist

[Ferdinand (office-chricar)]

same for accounts linked twice

[gpa(OpenERP) (gpa-openerp)]

Hello Ferdinand,

Would you please apply the attached patch and notify us?

Thank you

[Ferdinand (office-chricar)]

not yet working

Traceback (most recent call last):
  File "/home/terp/OpenERP/branch/server/5.0/bin/netsvc.py", line 244, in dispatch
    result = LocalService(service_name)(method, *params)
  File "/home/terp/OpenERP/branch/server/5.0/bin/netsvc.py", line 73, in __call__
    return getattr(self, method)(*params)
  File "/home/terp/OpenERP/branch/server/5.0/bin/service/web_services.py", line 635, in execute
    return self._execute(db, uid, wiz_id, datas, action, context)
  File "/home/terp/OpenERP/branch/server/5.0/bin/service/web_services.py", line 615, in _execute
    return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context)
  File "/home/terp/OpenERP/branch/server/5.0/bin/wizard/__init__.py", line 177, in execute
    res = self.execute_cr(cr, uid, data, state, context)
  File "/home/terp/OpenERP/branch/server/5.0/bin/wizard/__init__.py", line 82, in execute_cr
    res['action'] = result_def['action'](self, cr, uid, data, context)
  File "/home/terp/OpenERP/branch/server/5.0/bin/addons/c2c_budget/wizard/validate_budget_structure.py", line 97, in _show_result
    self.account_children_map = self._get_children_map(cr, uid, sql_filters+sql_filters_aa2, context=context)
  File "/home/terp/OpenERP/branch/server/5.0/bin/addons/c2c_budget/wizard/validate_budget_structure.py", line 239, in _get_children_map
    self.cr.execute(query)
  File "/home/terp/OpenERP/branch/server/5.0/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/home/terp/OpenERP/branch/server/5.0/bin/sql_db.py", line 125, in execute
    res = self._obj.execute(query, params)
ProgrammingError: missing FROM-clause entry for table "aa2"
LINE 2: ...a.company_id = 1 AND aa.type IN ('expense') AND aa2.compan...
                                                             ^

[gpa(OpenERP) (gpa-openerp)]

Hello Ferdinand,

I apologize for this little mistake.

Would you please apply the another patch and notify us?

Thank you for your time.

[Ferdinand (office-chricar)]

there is no more error

both lists are empty - so I hope I have defined everything correclty

[gpa(OpenERP) (gpa-openerp)]

Thank you for reporting

It has been fix released in following revision no:
4216 <email address hidden>