← Back to team overview

openerp-india team mailing list archive

[Bug 987242] [NEW] Gives error when adding new products on openerp 6.0.4

 

Public bug reported:

Can someone help me out on this error below and on how to sort it


Environment Information : 
System : Windows-post2008Server-6.1.7600
OS Name : nt
Operating System Release : post2008Server
Operating System Version : 6.1.7600
Operating System Architecture : 32bit
Operating System Locale : en_US.cp1252
Python Version : 2.6.5
OpenERP-Client Version : 6.1.1
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
  File "/opt/openerp/openerp-server-6.0.4/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/opt/openerp/openerp-server-6.0.4/bin/service/web_services.py", line 599, in dispatch
    res = fn(db, uid, *params)
  File "/opt/openerp/server/bin/addons/audittrail/audittrail.py", line 522, in execute
    res = my_fct(db, uid, model, method, *args)
  File "/opt/openerp/server/bin/addons/audittrail/audittrail.py", line 506, in my_fct
    return fct_src(db, uid_orig, model, method, *args)
  File "/opt/openerp/openerp-server-6.0.4/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/opt/openerp/openerp-server-6.0.4/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/openerp/openerp-server-6.0.4/bin/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/openerp/openerp-server-6.0.4/bin/osv/orm.py", line 1014, in default_get
    if not obj.search(cr, uid, [('id', '=', field_value or False)]):
  File "/opt/openerp/server/bin/addons/account/account.py", line 215, in search
    order, context=context, count=count)
  File "/opt/openerp/openerp-server-6.0.4/bin/osv/orm.py", line 1747, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/opt/openerp/openerp-server-6.0.4/bin/osv/orm.py", line 4030, in _search
    cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
  File "/opt/openerp/openerp-server-6.0.4/bin/sql_db.py", line 78, in wrapper
    return f(self, *args, **kwargs)
  File "/opt/openerp/openerp-server-6.0.4/bin/sql_db.py", line 131, in execute
    res = self._obj.execute(query, params)
DataError: invalid input syntax for integer: "false"
LINE 1: ...account.active = 'True') AND account_account.id = 'false' OR...
                                                             ^

** Affects: openerp-india
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP India.
https://bugs.launchpad.net/bugs/987242

Title:
  Gives error when adding new products on openerp 6.0.4

Status in OpenERP India:
  New

Bug description:
  Can someone help me out on this error below and on how to sort it

  
  Environment Information : 
  System : Windows-post2008Server-6.1.7600
  OS Name : nt
  Operating System Release : post2008Server
  Operating System Version : 6.1.7600
  Operating System Architecture : 32bit
  Operating System Locale : en_US.cp1252
  Python Version : 2.6.5
  OpenERP-Client Version : 6.1.1
  Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
    File "/opt/openerp/openerp-server-6.0.4/bin/netsvc.py", line 489, in dispatch
      result = ExportService.getService(service_name).dispatch(method, auth, params)
    File "/opt/openerp/openerp-server-6.0.4/bin/service/web_services.py", line 599, in dispatch
      res = fn(db, uid, *params)
    File "/opt/openerp/server/bin/addons/audittrail/audittrail.py", line 522, in execute
      res = my_fct(db, uid, model, method, *args)
    File "/opt/openerp/server/bin/addons/audittrail/audittrail.py", line 506, in my_fct
      return fct_src(db, uid_orig, model, method, *args)
    File "/opt/openerp/openerp-server-6.0.4/bin/osv/osv.py", line 122, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/opt/openerp/openerp-server-6.0.4/bin/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/opt/openerp/openerp-server-6.0.4/bin/osv/osv.py", line 167, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/opt/openerp/openerp-server-6.0.4/bin/osv/orm.py", line 1014, in default_get
      if not obj.search(cr, uid, [('id', '=', field_value or False)]):
    File "/opt/openerp/server/bin/addons/account/account.py", line 215, in search
      order, context=context, count=count)
    File "/opt/openerp/openerp-server-6.0.4/bin/osv/orm.py", line 1747, in search
      return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
    File "/opt/openerp/openerp-server-6.0.4/bin/osv/orm.py", line 4030, in _search
      cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
    File "/opt/openerp/openerp-server-6.0.4/bin/sql_db.py", line 78, in wrapper
      return f(self, *args, **kwargs)
    File "/opt/openerp/openerp-server-6.0.4/bin/sql_db.py", line 131, in execute
      res = self._obj.execute(query, params)
  DataError: invalid input syntax for integer: "false"
  LINE 1: ...account.active = 'True') AND account_account.id = 'false' OR...
                                                               ^

To manage notifications about this bug go to:
https://bugs.launchpad.net/openerp-india/+bug/987242/+subscriptions


Follow ups

References