Comment 2 for bug 321512

Revision history for this message
Tanel Kurvits (tanel-kurvits) wrote :

I really do not know its dublicate or not but that bug still there!

1. fresh install
2. "manufacturing industry profile" and add Pos in vizard (no demo data and no chart of accounts)
3. Navigate "Point of Sale" -> "Pos Lines" -> "Pos Lines of the day"
4. crash:

Traceback (most recent call last):
  File "/opt/openerp/unstable/5.0/server/bin/netsvc.py", line 226, in dispatch
    result = LocalService(service_name)(method, *params)
  File "/opt/openerp/unstable/5.0/server/bin/netsvc.py", line 74, in __call__
    return getattr(self, method)(*params)
  File "/opt/openerp/unstable/5.0/server/bin/service/web_services.py", line 481, in execute
    res = service.execute(db, uid, object, method, *args)
  File "/opt/openerp/unstable/5.0/server/bin/osv/osv.py", line 59, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/opt/openerp/unstable/5.0/server/bin/osv/osv.py", line 119, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/openerp/unstable/5.0/server/bin/osv/osv.py", line 111, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/openerp/unstable/5.0/server/bin/osv/orm.py", line 2558, in search
    cr.execute('select %s.id from ' % self._table + ','.join(tables) +qu1+' order by '+order_by+limit_str+offset_str, qu2)
  File "/opt/openerp/unstable/5.0/server/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/opt/openerp/unstable/5.0/server/bin/sql_db.py", line 117, in execute
    res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: timestamp without time zone ~~ unknown
LINE 1: ...pos_order_line" where (pos_order_line.create_date like E'%20...
                                                             ^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.