c2c-oerpscenario team mailing list archive

[xrg <xrg@xxxxxxxxx>]

On Tuesday 22 February 2011, you wrote:
> Yes your right, I copy pasted your query and I saw a 2 and a 3. I see
> your point in LIMIT 1 but should I change this to 3, then delete the
> view and it will regenerate? Thanks.

If you change the .py file (to add the "limit 1" at line 92, before the 
parentheses) you can either upgrade the account module (to let it drop and re-
create the view) or simply copy paste that part into the SQL prompt (to avoid 
upgrading the account module).

I am still not sure, however, if the results of a "limt 1" will be correct in 
terms of data representation. Can we have multiple reference UoMs and 
arbitrarily pick one of them for the report?

Some experts on the module may need to comment that..

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/722882

Title:
  ProgrammingError more than one row returned subquery

Status in OpenERP Web Client:
  New

Bug description:
  When I installed the web client about a month ago it worked great. But
  all of the sudden now whenever it gets to a view page it does this

  Traceback (most recent call last):
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/netsvc.py", line 489, in dispatch
      result = ExportService.getService(service_name).dispatch(method, auth, params)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/service/web_services.py", line 599, in dispatch
      res = fn(db, uid, *params)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 122, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 167, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/orm.py", line 1736, in search
      return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/orm.py", line 3990, in _search
      cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 78, in wrapper
      return f(self, *args, **kwargs)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 131, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: more than one row returned by a subquery used as an expression

  I didnt do anything extra or modify anything it does this every single
  time. Right now the web client is not usable to us and we dont know
  why