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.
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): unstable/ 5.0/server/ bin/netsvc. py", line 226, in dispatch service_ name)(method, *params) unstable/ 5.0/server/ bin/netsvc. py", line 74, in __call__ unstable/ 5.0/server/ bin/service/ web_services. py", line 481, in execute unstable/ 5.0/server/ bin/osv/ osv.py" , line 59, in wrapper unstable/ 5.0/server/ bin/osv/ osv.py" , line 119, in execute unstable/ 5.0/server/ bin/osv/ osv.py" , line 111, in execute_cr unstable/ 5.0/server/ bin/osv/ orm.py" , line 2558, in search execute( 'select %s.id from ' % self._table + ','.join(tables) +qu1+' order by '+order_ by+limit_ str+offset_ str, qu2) unstable/ 5.0/server/ bin/sql_ db.py", line 76, in wrapper unstable/ 5.0/server/ bin/sql_ db.py", line 117, in execute execute( query, params) line.create_ date like E'%20...
^
File "/opt/openerp/
result = LocalService(
File "/opt/openerp/
return getattr(self, method)(*params)
File "/opt/openerp/
res = service.execute(db, uid, object, method, *args)
File "/opt/openerp/
return f(self, dbname, *args, **kwargs)
File "/opt/openerp/
res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
File "/opt/openerp/
return getattr(object, method)(cr, uid, *args, **kw)
File "/opt/openerp/
cr.
File "/opt/openerp/
return f(self, *args, **kwargs)
File "/opt/openerp/
res = self._obj.
ProgrammingError: operator does not exist: timestamp without time zone ~~ unknown
LINE 1: ...pos_order_line" where (pos_order_
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.