Hello, Indeed there was a special case we had not considered on the read_group while doing the fix at revision 5237. This is now fixed at the following revision.
revno: 5239 [merge] revision-id: [email protected] Thanks for the report ** Changed in: openobject-addons Status: Confirmed => Fix Released -- 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: [7.0]SQL server error on products Status in OpenERP Addons (modules): Fix Released 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
