trunk 5.0 "Pos Lines of the day" crash

[Tanel Kurvits]

Hi again.

Hit menu "Pos Lines of the day"

server runs in terminal and output is:

[Mon Jan 26 2009 18:18:33] ERROR:sql:bad query: select pos_order_line.id from "pos_order_line" where (pos_order_line.create_date like E'%2009-01-26%') order by id limit 80
[Mon Jan 26 2009 18:18:33] ERROR:web-services:[01]: Traceback (most recent call last):
[Mon Jan 26 2009 18:18:33] ERROR:web-services:[02]: File "/opt/openerp/unstable/5.0/server/bin/osv/osv.py", line 59, in wrapper
[Mon Jan 26 2009 18:18:33] ERROR:web-services:[03]: return f(self, dbname, *args, **kwargs)
[Mon Jan 26 2009 18:18:33] ERROR:web-services:[04]: File "/opt/openerp/unstable/5.0/server/bin/osv/osv.py", line 119, in execute
[Mon Jan 26 2009 18:18:33] ERROR:web-services:[05]: res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
[Mon Jan 26 2009 18:18:33] ERROR:web-services:[06]: File "/opt/openerp/unstable/5.0/server/bin/osv/osv.py", line 111, in execute_cr
[Mon Jan 26 2009 18:18:33] ERROR:web-services:[07]: return getattr(object, method)(cr, uid, *args, **kw)
[Mon Jan 26 2009 18:18:33] ERROR:web-services:[08]: File "/opt/openerp/unstable/5.0/server/bin/osv/orm.py", line 2558, in search
[Mon Jan 26 2009 18:18:33] ERROR:web-services:[09]: cr.execute('select %s.id from ' % self._table + ','.join(tables) +qu1+' order by '+order_by+limit_str+offset_str, qu2)
[Mon Jan 26 2009 18:18:33] ERROR:web-services:[10]: File "/opt/openerp/unstable/5.0/server/bin/sql_db.py", line 76, in wrapper
[Mon Jan 26 2009 18:18:33] ERROR:web-services:[11]: return f(self, *args, **kwargs)
[Mon Jan 26 2009 18:18:33] ERROR:web-services:[12]: File "/opt/openerp/unstable/5.0/server/bin/sql_db.py", line 117, in execute
[Mon Jan 26 2009 18:18:33] ERROR:web-services:[13]: res = self._obj.execute(query, params)
[Mon Jan 26 2009 18:18:33] ERROR:web-services:[14]: ProgrammingError: operator does not exist: timestamp without time zone ~~ unknown
[Mon Jan 26 2009 18:18:33] ERROR:web-services:[15]: LINE 1: ...pos_order_line" where (pos_order_line.create_date like E'%20...
[Mon Jan 26 2009 18:18:33] ERROR:web-services:[16]: ^
[Mon Jan 26 2009 18:18:33] ERROR:web-services:[17]: HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

And in client:

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.

Regards,
Tanel

[Christophe CHAUVET (christophe-chauvet)]

This bug was fixed in the latest trunk
please update.

[Tanel Kurvits (tanel-kurvits)]

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.

[Naresh(OpenERP) (nch-openerp)]

Hello,
Please update your addons . I tested it at revision no addons(2157), server(1651), client(912) and it is working absolutely fine.

[Tanel Kurvits (tanel-kurvits)]

Can you give me hint what i do wrong? Downloaded again and installed again but still crashing!
addons(2165), server(1650), client(912)
you server 1651! Just downloaded and i got 1650! How i can track what is my problem? Hints please.

i use command for download :
bzr checkout --lightweight lp:~openerp/openobject-addons/trunk addons

Also maked new database (manufacturing profile) and used vizard (added extra module pos)

[Tanel Kurvits (tanel-kurvits)]

Helps if i attach some my files?

[Tanel Kurvits (tanel-kurvits)]

Notice yesterday 26 jan i installed new linux and also trunk in there and there was also that issue. Really i do not know bzr versions right now but i downloaded it 26 jan. Ma by bug in wizard and my pos crashes because wizard generating something wrong? I try make test and no use Wizard and install that module buy hand.

[Tanel Kurvits (tanel-kurvits)]

Test result failure.
Installed Manufacturing profile & manually POS - crash
Installed Service profile & manually POS - crash
What next?

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

Fixed in trunk

Thank you

[Tanel Kurvits (tanel-kurvits)]

Ouch! I already installed in Virtualbox new Linux for testing what strange bug is that what only i have! I was already almost done with that process. Hurts.

[Tanel Kurvits (tanel-kurvits)]

I can confirm its fixed now!
Needed migrate old database and bug gone.

Thank you!
Sorry for trouble.