c2c-oerpscenario team mailing list archive

["mra \(Open ERP\)" <mra@xxxxxxxxxxx>]

** Changed in: openobject-addons
       Status: Confirmed => In Progress

** Changed in: openobject-addons
    Milestone: None => 6.0-rc2

-- 
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/689656

Title:
  Bug with product margin

Status in OpenObject Addons Modules:
  In Progress

Bug description:
  In the GTK Client,

install product_margin, then open product_margin but without specifying any date

=> you get the following error : 

Environment Information : 
System : Linux-2.6.32-26-generic-i686-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-26-generic
Operating System Version : #48-Ubuntu SMP Wed Nov 24 09:00:03 UTC 2010
Operating System Architecture : 32bit
Operating System Locale : fr_BE.UTF8
Python Version : 2.6.5
OpenERP-Client Version : 6.0.0-rc1-1
Last revision No. & ID :1713 launchpad_translations_on_behalf_of_openerp-20101211044634-hs30hc0l5ufmah4a
Traceback (most recent call last):
  File "/home/openerp/trunk/server/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/home/openerp/trunk/server/bin/service/web_services.py", line 598, in dispatch
    res = fn(db, uid, *params)
  File "/home/openerp/trunk/server/bin/osv/osv.py", line 119, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/openerp/trunk/server/bin/osv/osv.py", line 203, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/openerp/trunk/server/bin/osv/osv.py", line 193, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/openerp/trunk/server/bin/osv/orm.py", line 3019, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/home/openerp/trunk/server/bin/osv/orm.py", line 3130, in _read_flat
    res2 = self._columns[val[0]].get(cr, self, ids, val, user, context=context, values=res)
  File "/home/openerp/trunk/server/bin/osv/fields.py", line 782, in get
    res = self._fnct(obj, cr, user, ids, name, self._arg, context)
  File "/home/openerp/trunk/server/bin/addons/product_margin/product_margin.py", line 70, in _product_margin
    """, (val.id, states, invoice_types, date_from, date_to))
  File "/home/openerp/trunk/server/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/home/openerp/trunk/server/bin/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
ProgrammingError: ERREUR:  operator doesn't exist : date >= boolean
LINE 10: ... (E'in_invoice', E'out_refund') and i.date_invoice>=false an...
                                                              ^
HINT:  No operator corresponds to given name and types of arguments.
We should add explicit types conversion.