Hi,

Can anybody help me? I cannot create 'new' DO or anything else from Incoming products to DO. Everytime I click on 'New', I received this error.

Traceback (most recent call last):
File "/usr/lib/python2.5/site-packages/openerp-server/netsvc.py", line 231, in dispatch
result = LocalService(service_name)(method, *params)
File "/usr/lib/python2.5/site-packages/openerp-server/netsvc.py", line 74, in __call__
return getattr(self, method)(*params)
File "/usr/lib/python2.5/site-packages/openerp-server/service/web_services.py", line 496, in execute
res = service.execute(db, uid, object, method, *args)
File "/usr/lib/python2.5/site-packages/openerp-server/osv/osv.py", line 59, in wrapper
return f(self, dbname, *args, **kwargs)
File "/usr/lib/python2.5/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.5/site-packages/openerp-server/osv/osv.py", line 111, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/usr/lib/python2.5/site-packages/openerp-server/osv/orm.py", line 1825, in default_get
if not obj.search(cr, uid, [('id', '=', field_value)]):
File "/usr/lib/python2.5/site-packages/openerp-server/osv/orm.py", line 2620, 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.5/site-packages/openerp-server/sql_db.py", line 76, in wrapper
return f(self, *args, **kwargs)
File "/usr/lib/python2.5/site-packages/openerp-server/sql_db.py", line 118, in execute
res = self._obj.execute(query, params)
ProgrammingError: invalid input syntax for integer: ""

Please help me coz my client want to start using it..

Thanks
Ismail

restart all the services associated with OpenERP. If still problems try on Web client.


Regards,

Hi,

I have tried both, but still the problem still exist.

check your backed-up database by fresh installing OpenERP on other system/OS, if there any data base related errors.

I have tried what you have stated, but I still had the error. Could it be the error came form the settings in the db?

I am not sure, but this problem may be due to:

1- Dependencies problem in module (check dependencies before install)

2- update module list from Administration after new module install.