c2c-oerpscenario team mailing list archive

[xrg <xrg@xxxxxxxxx>]

On Tuesday 22 February 2011, you wrote:
> No that wasnt it, I created a new company, got past the screen and still
> it happened. Your right, either its a bad database query or there is
> something wrong with my database, but that cant be possible we havent
> changed anything in the database.

It /is/ a faulty query, the traceback shows that clearly. But that path is too 
generic for me to tell you where the bug may possibly lie.

If you open your /var/log/postgres/postgres.log (or whatever is in your 
platform), usually Postgres keeps a log of the queries that have failed. This 
will help us get much closer to the real bug.

-- 
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