Comment 0 for bug 643802

Revision history for this message
stijnbe (stijnbe) wrote :

When I try to compute a new sales order, save the order or deposit a sales order I get this error:

Environment Information :
System : Linux-2.6.32-24-generic-x86_64-with-Ubuntu-10.04-lucid
OS Name : posix
Distributor ID: Ubuntu
Description: Ubuntu 10.04.1 LTS
Release: 10.04
Codename: lucid
Operating System Release : 2.6.32-24-generic
Operating System Version : #43-Ubuntu SMP Thu Sep 16 14:58:24 UTC 2010
Operating System Architecture : 64bit
Operating System Locale : en_US.UTF8
Python Version : 2.6.5
OpenERP-Client Version : 6.0dev
Last revision No. & ID :1564 <email address hidden>
Traceback (most recent call last):
  File "/home/stijnbe/Testing/openerp/openobject-server/bin/netsvc.py", line 439, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/home/stijnbe/Testing/openerp/openobject-server/bin/service/web_services.py", line 586, in dispatch
    res = fn(db, uid, *params)
  File "/home/stijnbe/Testing/openerp/openobject-server/bin/osv/osv.py", line 57, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/stijnbe/Testing/openerp/openobject-server/bin/osv/osv.py", line 140, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/stijnbe/Testing/openerp/openobject-server/bin/osv/osv.py", line 130, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/stijnbe/Testing/openerp/openobject-addons/sale/sale.py", line 391, in create
    return super(sale_order, self).create(cr, uid, vals, context=context)
  File "/home/stijnbe/Testing/openerp/openobject-server/bin/osv/orm.py", line 3774, in create
    wf_service.trg_create(user, self._name, id_new, cr)
  File "/home/stijnbe/Testing/openerp/openobject-server/bin/workflow/wkf_service.py", line 72, in trg_create
    instance.create(cr, ident, wkf_id)
  File "/home/stijnbe/Testing/openerp/openobject-server/bin/workflow/instance.py", line 30, in create
    cr.execute('insert into wkf_instance (res_type,res_id,uid,wkf_id) values (%s,%s,%s,%s) RETURNING id', (res_type,res_id,uid,wkf_id))
  File "/home/stijnbe/Testing/openerp/openobject-server/bin/sql_db.py", line 75, in wrapper
    return f(self, *args, **kwargs)
  File "/home/stijnbe/Testing/openerp/openobject-server/bin/sql_db.py", line 122, in execute
    res = self._obj.execute(query, params)
ProgrammingError: syntax error at or near "RETURNING"
LINE 1: ...e,res_id,uid,wkf_id) values (E'sale.order',4,1,5) RETURNING ...
                                                             ^