*** This bug is a duplicate of bug 728042 ***
https://bugs.launchpad.net/bugs/728042
** This bug has been marked a duplicate of bug 728042
Sales Analysis bad query
* You can subscribe to bug 728042 by following this link:
https://bugs.launchpad.net/openobject-addons/+bug/728042/+subscribe
--
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/723355
Title:
Postgres Views ProgrammingError more than one row returned subquery
Status in OpenERP Modules (addons):
New
Bug description:
In a sample database you would not notice this issue.
Please issue the following query:
SELECT category_id, COUNT(name) FROM product_uom WHERE uom_type='reference'
GROUP BY category_id; -- HAVING count(name) > 1
If it has any row where count(name) > 1, it will return this error
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
To bypass the issue do this
It is in addons/account/report/account_invoice_report.py:92, where a "LIMIT 1"
There is another view with a similar problem in the GTK Client
warehouse views
_______________________________________________
Mailing list: https://launchpad.net/~c2c-oerpscenario
Post to : [email protected]
Unsubscribe : https://launchpad.net/~c2c-oerpscenario
More help : https://help.launchpad.net/ListHelp
