openerp-india team mailing list archive

["Jignesh Rathod\(OpenERP\)" <1005867@xxxxxxxxxxxxxxxxxx>]

Hello Fekete Mihai ,

I have checked this issue again with trunk and stable.
Currently Its working fine with trunk. it fixed from revision : 6633 lp: 909124.
But It producible with  6.1. So I assigning this issue to opw team.

Thanks for reporting.

** Changed in: openobject-addons
   Importance: Undecided => Low

** Changed in: openobject-addons
       Status: Incomplete => Confirmed

** Changed in: openobject-addons
     Assignee: (unassigned) => OpenERP Publisher's Warranty Team (openerp-opw)

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1005867

Title:
  update account module

Status in OpenERP Addons (modules):
  Confirmed

Bug description:
  Hi there,

  i have a problem when starting the server with --update=account, when
  doing this the server will create a new column journal_id in
  account_bank_statement_line called journal_id_moved0, and on every
  update the iteratir will grow...and the type of the field is different
  from update to update...from integer to char, and back....

  can you give a solution how to get rid of this because is inconvenient
  and when is doing this i can't post moves from vouchers and pos
  receipt in journal..

  details of server log:

  ERROR demo openerp.sql_db: bad query: update "account_bank_statement_line" set "journal_id"='Numerar' where id = 2
  Traceback (most recent call last):
    File "/usr/local/lib/python2.7/dist-packages/openerp-6.1-py2.7.egg/openerp/sql_db.py", line 212, in execute
      res = self._obj.execute(query, params)
  DataError: invalid input syntax for integer: "Numerar"
  LINE 1: ...te "account_bank_statement_line" set "journal_id"='Numerar' ...
                                                               ^

  2012-05-29 11:46:37,310 14750 ERROR demo openerp.osv.osv: Uncaught exception
  Traceback (most recent call last):
    File "/usr/local/lib/python2.7/dist-packages/openerp-6.1-py2.7.egg/openerp/osv/osv.py", line 121, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/usr/local/lib/python2.7/dist-packages/openerp-6.1-py2.7.egg/openerp/osv/osv.py", line 196, in exec_workflow
      res = self.exec_workflow_cr(cr, uid, obj, method, *args)
    File "/usr/local/lib/python2.7/dist-packages/openerp-6.1-py2.7.egg/openerp/addons/audittrail/audittrail.py", line 501, in exec_workflow_cr
      return fct_src(cr, uid, model, method, *args)
    File "/usr/local/lib/python2.7/dist-packages/openerp-6.1-py2.7.egg/openerp/osv/osv.py", line 189, in exec_workflow_cr
      return wf_service.trg_validate(uid, obj, args[0], method, cr)
    File "/usr/local/lib/python2.7/dist-packages/openerp-6.1-py2.7.egg/openerp/workflow/wkf_service.py", line 124, in trg_validate
      res2 = instance.validate(cr, id, ident, signal)
    File "/usr/local/lib/python2.7/dist-packages/openerp-6.1-py2.7.egg/openerp/workflow/instance.py", line 48, in validate
      workitem.process(cr, witem, ident, signal, force_running, stack=stack)
    File "/usr/local/lib/python2.7/dist-packages/openerp-6.1-py2.7.egg/openerp/workflow/workitem.py", line 61, in process
      ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
    File "/usr/local/lib/python2.7/dist-packages/openerp-6.1-py2.7.egg/openerp/workflow/workitem.py", line 176, in _split_test
      _join_test(cr, t[0], t[1], ident, stack)
    File "/usr/local/lib/python2.7/dist-packages/openerp-6.1-py2.7.egg/openerp/workflow/workitem.py", line 184, in _join_test
      create(cr,[activity], inst_id, ident, stack)
    File "/usr/local/lib/python2.7/dist-packages/openerp-6.1-py2.7.egg/openerp/workflow/workitem.py", line 41, in create
      process(cr, res, ident, stack=stack)
    File "/usr/local/lib/python2.7/dist-packages/openerp-6.1-py2.7.egg/openerp/workflow/workitem.py", line 53, in process
      result = _execute(cr, workitem, activity, ident, stack)
    File "/usr/local/lib/python2.7/dist-packages/openerp-6.1-py2.7.egg/openerp/workflow/workitem.py", line 107, in _execute
      returned_action = wkf_expr.execute(cr, ident, workitem, activity)
    File "/usr/local/lib/python2.7/dist-packages/openerp-6.1-py2.7.egg/openerp/workflow/wkf_expr.py", line 68, in execute
      return _eval_expr(cr, ident, workitem, activity['action'])
    File "/usr/local/lib/python2.7/dist-packages/openerp-6.1-py2.7.egg/openerp/workflow/wkf_expr.py", line 58, in _eval_expr
      ret = eval(line, env, nocopy=True)
    File "/usr/local/lib/python2.7/dist-packages/openerp-6.1-py2.7.egg/openerp/tools/safe_eval.py", line 241, in safe_eval
      return eval(test_expr(expr,_SAFE_OPCODES, mode=mode), globals_dict, locals_dict)
    File "", line 1, in <module>
    File "/usr/local/lib/python2.7/dist-packages/openerp-6.1-py2.7.egg/openerp/osv/orm.py", line 368, in function_proxy
      return attr(self._cr, self._uid, [self._id], *args, **kwargs)
    File "/usr/local/lib/python2.7/dist-packages/openerp-6.1-py2.7.egg/openerp/addons/account_voucher/account_voucher.py", line 761, in proforma_voucher
      self.action_move_line_create(cr, uid, ids, context=context)
    File "/usr/local/lib/python2.7/dist-packages/openerp-6.1-py2.7.egg/openerp/addons/account_l10n_ro/account_voucher.py", line 110, in action_move_line_create
      move_id = move_pool.create(cr, uid, self.account_move_get(cr, uid, voucher.id, context=context), context=context)
    File "/usr/local/lib/python2.7/dist-packages/openerp-6.1-py2.7.egg/openerp/addons/account_l10n_ro/account_voucher.py", line 213, in account_move_get
      statement_line_obj.create(cr, uid, args, context=context)
    File "/usr/local/lib/python2.7/dist-packages/openerp-6.1-py2.7.egg/openerp/osv/orm.py", line 4224, in create
      self.pool.get(object)._store_set_values(cr, user, ids, fields2, context)
    File "/usr/local/lib/python2.7/dist-packages/openerp-6.1-py2.7.egg/openerp/osv/orm.py", line 4386, in _store_set_values
      '"'+f+'"='+self._columns[f]._symbol_set[0] + ' where id = %s', (self._columns[f]._symbol_set[1](value), id))
    File "/usr/local/lib/python2.7/dist-packages/openerp-6.1-py2.7.egg/openerp/sql_db.py", line 152, in wrapper
      return f(self, *args, **kwargs)
    File "/usr/local/lib/python2.7/dist-packages/openerp-6.1-py2.7.egg/openerp/sql_db.py", line 212, in execute
      res = self._obj.execute(query, params)
  DataError: invalid input syntax for integer: "Numerar"
  LINE 1: ...te "account_bank_statement_line" set "journal_id"='Numerar' ...
                                                               ^

  2012-05-29 11:46:37,318 14750 ERROR demo openerp.netsvc: invalid input syntax for integer: "Numerar"
  LINE 1: ...te "account_bank_statement_line" set "journal_id"='Numerar' ...

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1005867/+subscriptions