← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 863444] [NEW] can not create an internal move with move lines

 

Public bug reported:

Warehouse > Warehouse Management > Internal Moves , create a new move, save it (if you skip this step it works) then add a new move line (fill the required fields).
Save your line then try to save the internal move > exception.
Tested in the gtk client, it worked.


Server Traceback (most recent call last):
  File "/home/niv/sharedrepo/server/openerp/wsgi.py", line 71, in xmlrpc_return
    result = openerp.netsvc.dispatch_rpc(service, method, params)
  File "/home/niv/sharedrepo/server/openerp/netsvc.py", line 328, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/home/niv/sharedrepo/server/openerp/service/web_services.py", line 568, in dispatch
    res = fn(db, uid, *params)
  File "/home/niv/sharedrepo/server/openerp/osv/osv.py", line 116, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/niv/sharedrepo/server/openerp/osv/osv.py", line 170, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/niv/sharedrepo/server/openerp/osv/osv.py", line 161, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/niv/sharedrepo/server/openerp/osv/orm.py", line 3735, in write
    result += self._columns[field].set(cr, self, id, field, vals[field], user, context=rel_context) or []
  File "/home/niv/sharedrepo/server/openerp/osv/fields.py", line 448, in set
    id_new = obj.create(cr, user, act[2], context=context)
  File "/home/niv/sharedrepo/server/openerp/osv/orm.py", line 3957, in create
    cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
  File "/home/niv/sharedrepo/server/openerp/sql_db.py", line 153, in wrapper
    return f(self, *args, **kwargs)
  File "/home/niv/sharedrepo/server/openerp/sql_db.py", line 215, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column "create_date" specified more than once
LINE 1: ...g_id","product_packaging","picking_id",create_uid,create_dat...
                                                             ^

** Affects: openerp-web
     Importance: High
     Assignee: OpenERP R&D Web Team (openerp-dev-web)
         Status: Confirmed

** Changed in: openerp-web
   Importance: Undecided => High

** Changed in: openerp-web
       Status: New => Confirmed

** Changed in: openerp-web
     Assignee: (unassigned) => OpenERP R&D Web Team (openerp-dev-web)

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

Title:
  can not create an internal move with move lines

Status in OpenERP Web:
  Confirmed

Bug description:
  Warehouse > Warehouse Management > Internal Moves , create a new move, save it (if you skip this step it works) then add a new move line (fill the required fields).
  Save your line then try to save the internal move > exception.
  Tested in the gtk client, it worked.

  
  Server Traceback (most recent call last):
    File "/home/niv/sharedrepo/server/openerp/wsgi.py", line 71, in xmlrpc_return
      result = openerp.netsvc.dispatch_rpc(service, method, params)
    File "/home/niv/sharedrepo/server/openerp/netsvc.py", line 328, in dispatch_rpc
      result = ExportService.getService(service_name).dispatch(method, params)
    File "/home/niv/sharedrepo/server/openerp/service/web_services.py", line 568, in dispatch
      res = fn(db, uid, *params)
    File "/home/niv/sharedrepo/server/openerp/osv/osv.py", line 116, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/niv/sharedrepo/server/openerp/osv/osv.py", line 170, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/niv/sharedrepo/server/openerp/osv/osv.py", line 161, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/niv/sharedrepo/server/openerp/osv/orm.py", line 3735, in write
      result += self._columns[field].set(cr, self, id, field, vals[field], user, context=rel_context) or []
    File "/home/niv/sharedrepo/server/openerp/osv/fields.py", line 448, in set
      id_new = obj.create(cr, user, act[2], context=context)
    File "/home/niv/sharedrepo/server/openerp/osv/orm.py", line 3957, in create
      cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
    File "/home/niv/sharedrepo/server/openerp/sql_db.py", line 153, in wrapper
      return f(self, *args, **kwargs)
    File "/home/niv/sharedrepo/server/openerp/sql_db.py", line 215, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: column "create_date" specified more than once
  LINE 1: ...g_id","product_packaging","picking_id",create_uid,create_dat...
                                                               ^

To manage notifications about this bug go to:
https://bugs.launchpad.net/openerp-web/+bug/863444/+subscriptions


Follow ups

References