Public bug reported:
I did a manual bzr pull on all 3 repos, then:
- create db
- install MRP
- install Sales
- click Sales-Products-Products
2014-02-18 19:48:14,101 51195 ERROR test3 openerp.sql_db: Programming error:
column "stock_move__product_id.name_template" must appear in the GROUP BY
clause or be used in an aggregate function
LINE 1: ...RDER BY "stock_move__product_id"."default_code" ,"stock_mov...
^
, in query SELECT min(stock_move.id) AS id, count(stock_move.id) AS
product_id_count,"stock_move"."product_id" FROM "stock_move" LEFT JOIN
"product_product" as "stock_move__product_id" ON ("stock_move"."product_id" =
"stock_move__product_id"."id") WHERE ((("stock_move"."product_id" in (%s)) AND
FALSE) AND ("stock_move"."state" in (%s,%s,%s))) GROUP BY
"stock_move"."product_id","stock_move__product_id"."default_code" ORDER BY
"stock_move__product_id"."default_code"
,"stock_move__product_id"."name_template"
bzr branch nick: openobject-server revno: 5230
bzr branch nick: openobject-addons revno: 9840
bzr branch nick: web-7 revno: 4137
** Affects: openobject-addons
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1281762
Title:
SQL server error on products
Status in OpenERP Addons (modules):
New
Bug description:
I did a manual bzr pull on all 3 repos, then:
- create db
- install MRP
- install Sales
- click Sales-Products-Products
2014-02-18 19:48:14,101 51195 ERROR test3 openerp.sql_db: Programming error:
column "stock_move__product_id.name_template" must appear in the GROUP BY
clause or be used in an aggregate function
LINE 1: ...RDER BY "stock_move__product_id"."default_code" ,"stock_mov...
^
, in query SELECT min(stock_move.id) AS id, count(stock_move.id) AS
product_id_count,"stock_move"."product_id" FROM "stock_move" LEFT JOIN
"product_product" as "stock_move__product_id" ON ("stock_move"."product_id" =
"stock_move__product_id"."id") WHERE ((("stock_move"."product_id" in (%s)) AND
FALSE) AND ("stock_move"."state" in (%s,%s,%s))) GROUP BY
"stock_move"."product_id","stock_move__product_id"."default_code" ORDER BY
"stock_move__product_id"."default_code"
,"stock_move__product_id"."name_template"
bzr branch nick: openobject-server revno: 5230
bzr branch nick: openobject-addons revno: 9840
bzr branch nick: web-7 revno: 4137
To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1281762/+subscriptions
_______________________________________________
Mailing list: https://launchpad.net/~openerp-india
Post to : [email protected]
Unsubscribe : https://launchpad.net/~openerp-india
More help : https://help.launchpad.net/ListHelp
