← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 700953] Re: Column account_journal_period.company_id missing

 

I comfirm that I have the same problem. I get this error code when I try
to confirm a supplier invoce.

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/700953

Title:
  Column account_journal_period.company_id missing

Status in OpenObject Addons Modules:
  Invalid

Bug description:
  1)
  Freshly installed the openobject-server 6.0 rc2 revision 3204, openobject-client-web 6.0 rc2 revision 4236, openobject-addons revision 4175
  2) Created a new database
  3) Tried to validate a expected incoming invoice
  4) Recieved error stating that account_journal_period.company_id is missing in the database

  Traceback (most recent call last):
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/netsvc.py", line 489, in dispatch
      result = ExportService.getService(service_name).dispatch(method, auth, params)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/service/web_services.py", line 598, in dispatch
      res = fn(db, uid, *params)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/audittrail/audittrail.py", line 538, in exec_workflow
      return super(audittrail_objects_proxy, self).exec_workflow(db, uid, model, method, *args, **argv)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 122, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 196, in exec_workflow
      res = self.exec_workflow_cr(cr, uid, obj, method, *args)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/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.6/dist-packages/openerp-server/workflow/wkf_service.py", line 80, in trg_validate
      res2 = instance.validate(cr, id, ident, signal)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/workflow/instance.py", line 48, in validate
      workitem.process(cr, witem, ident, signal, force_running, stack=stack)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/workflow/workitem.py", line 61, in process
      ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/workflow/workitem.py", line 174, in _split_test
      _join_test(cr, t[0], t[1], ident, stack)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/workflow/workitem.py", line 182, in _join_test
      create(cr,[activity], inst_id, ident, stack)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/workflow/workitem.py", line 41, in create
      process(cr, res, ident, stack=stack)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/workflow/workitem.py", line 53, in process
      result = _execute(cr, workitem, activity, ident, stack)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/workflow/workitem.py", line 107, in _execute
      wkf_expr.execute(cr, ident, workitem, activity)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/workflow/wkf_expr.py", line 68, in execute
      return _eval_expr(cr, ident, workitem, activity['action'])
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/workflow/wkf_expr.py", line 58, in _eval_expr
      ret = eval(line, env, nocopy=True)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/tools/safe_eval.py", line 281, 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.6/dist-packages/openerp-server/osv/orm.py", line 181, in <lambda>
      return lambda *args, **argv: attr(self._cr, self._uid, [self._id], *args, **argv)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/account/invoice.py", line 937, in action_move_create
      move_id = self.pool.get('account.move').create(cr, uid, move, context=context)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/account/account.py", line 1265, in create
      result = super(account_move, self).create(cr, uid, vals, c)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/orm.py", line 3637, in create
      result += self._columns[field].set(cr, self, id_new, field, vals[field], user, rel_context) or []
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/fields.py", line 492, in set
      id_new = obj.create(cr, user, act[2], context=context)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/account/account_move_line.py", line 1150, in create
      self._update_journal_check(cr, uid, context['journal_id'], context['period_id'], context)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/account/account_move_line.py", line 1109, in _update_journal_check
      'period_id': period.id
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/account/account.py", line 988, in create
      return super(account_journal_period, self).create(cr, uid, vals, context)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/orm.py", line 3602, in create
      self.check_access_rule(cr, user, [id_new], 'create', context=context)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/orm.py", line 3163, in check_access_rule
      [sub_ids] + where_params)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 76, in wrapper
      return f(self, *args, **kwargs)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 129, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: column account_journal_period.company_id does not exist
  LINE 1: ...l_period.journal_id in (6,7,8,5,3,2,4,1))))  OR  (account_jo...
                                                               ^

  Don't really know if this belongs to the server or to the accounting-
  module.

  Thanks for your advise in advance.





References