c2c-oerpscenario team mailing list archive
-
c2c-oerpscenario team
-
Mailing list archive
-
Message #17038
[Bug 722882] Re: ProgrammingError more than one row returned subquery
Looking at the server log it does show a different trace,
[2011-02-21 09:48:30,549][midwestsupplies] ERROR:db.cursor:Programming error: more than one row returned by a subquery used as an expression
, in query SELECT "account_invoice_report".id FROM "account_invoice_report" WHERE (account_invoice_report.year ilike %s) AND (account_invoice_report.user_id = %s) ORDER BY date desc
[2011-02-21 09:48:30,549][midwestsupplies] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
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
I reported it as a web bug because we didnt change anything and the web
client started returning this error all of the time to the point where
we couldnt use it. We did have possibly a related problem. When updating
modules it would always go back to the chart of accounts screen and ask
us to re-input our company but there is no available options. The
company is properly defined and at first it works as we created it just
fine but then every time we update or add a module it goes to that
screen asking for our company but not letting us input anything. If your
sure it isnt a bug then close this.
--
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
References