hda
This problem is back again. I have not done any changes to the system apart
from users using the system for creating sales orders. However, as of this
morning when any user wants to login, the web interface throws this error:
--------------------------//----------------------------------------------------
Traceback (most recent call last):
File "/usr/lib/python2.4/site-packages/openerp-server/netsvc.py", line 235,
in dispatch
result = LocalService(service_name)(method, *params)
File "/usr/lib/python2.4/site-packages/openerp-server/netsvc.py", line 74, in
__call__
return getattr(self, method)(*params)
File
"/usr/lib/python2.4/site-packages/openerp-server/service/web_services.py", line
526, in execute
res = service.execute(db, uid, object, method, *args)
File "/usr/lib/python2.4/site-packages/openerp-server/osv/osv.py", line 59,
in wrapper
return f(self, dbname, *args, **kwargs)
File "/usr/lib/python2.4/site-packages/openerp-server/osv/osv.py", line 119,
in execute
res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
File "/usr/lib/python2.4/site-packages/openerp-server/osv/osv.py", line 111,
in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/usr/lib/python2.4/site-packages/openerp-server/osv/orm.py", line 2624,
in search
cr.execute('select %s.id from ' % self._table + ','.join(tables) +qu1+'
order by '+order_by+limit_str+offset_str, qu2)
File "/usr/lib/python2.4/site-packages/openerp-server/sql_db.py", line 76, in
wrapper
return f(self, *args, **kwargs)
File "/usr/lib/python2.4/site-packages/openerp-server/sql_db.py", line 120,
in execute
res = self._obj.execute(query, params)
ProgrammingError: division by zero
-----------------------------------//---------------------------------------------
I went ahead and checked the last issue we had with this problem having come
from the product_uom table. The table contents look very ok as below:
erp=# select * from product_uom;
id | create_uid | create_date | write_date |
write_uid | active | category_id | name | rounding | factor | factor_inv_data
----+------------+----------------------------+----------------------------+-----------+--------+-------------+------+----------+----------+-----------------
1 | 1 | 2009-05-27 07:19:04.673516 | 2009-07-02 14:00:59.635089 |
19 | t | 1 | PCE | 0.010 | 1.000000 |
2 | 1 | 2009-05-27 07:19:04.673516 | |
| t | 2 | KGM | 0.010 | 1.000000 |
3 | 1 | 2009-05-27 07:19:32.506626 | |
| t | 3 | Hour | 0.010 | 8.000000 |
4 | 1 | 2009-05-27 07:19:32.506626 | |
| t | 3 | Day | 0.010 | 1.000000 |
(4 rows)
Any idea where this error could be originating from?
Thanks
Anthony
-------------------- m2f --------------------
--
http://www.openobject.com/forum/viewtopic.php?p=41534#41534
-------------------- m2f --------------------
_______________________________________________
Tinyerp-users mailing list
http://tiny.be/mailman2/listinfo/tinyerp-users
