ApplicationError in POS / Reporting /Sales of the Month

[Thorsten Vocks (OpenBig.org)]

openerp 5rc3

Point of Sales->Reporting->Sales of the Month

something like "operator does not exist", see details below. It is the same for language english or german.

traceback (most recent call last):
  File "/home/vockst/openerp/server/bin/netsvc.py", line 421, in run
    result_from_method = method(*msg[2:])
  File "/home/vockst/openerp/server/bin/service/web_services.py", line 427, in execute
    res = service.execute(db, uid, object, method, *args)
  File "/home/vockst/openerp/server/bin/osv/osv.py", line 59, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/vockst/openerp/server/bin/osv/osv.py", line 120, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/vockst/openerp/server/bin/osv/osv.py", line 112, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/vockst/openerp/server/bin/osv/orm.py", line 2549, in search
    cr.execute('select %s.id from ' % self._table + ','.join(tables) +qu1+' order by '+order_by+limit_str+offset_str, qu2)
  File "/home/vockst/openerp/server/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/home/vockst/openerp/server/bin/sql_db.py", line 114, in execute
    res = self._obj.execute(query, params)
ProgrammingError: FEHLER: Operator existiert nicht: date ~~ unknown
LINE 1: ...on_pos" where (report_transaction_pos.date_create like E'%20...
                                                             ^
HINT: Kein Operator stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen.

[Stephane Wirtel (OpenERP) (stephane-openerp)]

Fixed in trunk,

Thanks

[Christophe CHAUVET (christophe-chauvet)]

Sorry but i dislike this patch, i prepare a branch and ask to merge

Christophe