Future stock forecast error

[nel]

Hi,

please check the report Future stock forecast, it gives that error:

[mer jan 28 2009 10:10:18] ERROR:web-services:[05]: Traceback (most recent call last):
[mer jan 28 2009 10:10:18] ERROR:web-services:[06]: File "/home/nel/terp/trunk/bin/service/web_services.py", line 585, in go
[mer jan 28 2009 10:10:18] ERROR:web-services:[07]: (result, format) = obj.create(cr, uid, ids, datas, context)
[mer jan 28 2009 10:10:18] ERROR:web-services:[08]: File "/home/nel/terp/2/trunk/bin/addons/stock/report/product_stock.py", line 69, in create
[mer jan 28 2009 10:10:18] ERROR:web-services:[09]: cr.execute("select sum(r.product_qty * u.factor), r.date_planned, r.product_id from stock_move r left join product_uom u on (r.product_uom=u.id) where state in ('confirmed','assigned','waiting') and location_id in ("+loc_ids_s+") and product_id in ("+prod_ids_s+") group by date_planned,product_id")
[mer jan 28 2009 10:10:18] ERROR:web-services:[10]: File "/home/nel/terp/trunk/bin/sql_db.py", line 76, in wrapper
[mer jan 28 2009 10:10:18] ERROR:web-services:[11]: return f(self, *args, **kwargs)
[mer jan 28 2009 10:10:18] ERROR:web-services:[12]: File "/home/nel/terp/trunk/bin/sql_db.py", line 117, in execute
[mer jan 28 2009 10:10:18] ERROR:web-services:[13]: res = self._obj.execute(query, params)
[mer jan 28 2009 10:10:18] ERROR:web-services:[14]: ProgrammingError: ERREUR: erreur de syntaxe sur ou près de « ) »
[mer jan 28 2009 10:10:18] ERROR:web-services:[15]: LINE 1: ...firmed','assigned','waiting') and location_id in () and prod...

[Priyesh (OpenERP) (pso-openerp)]

hello,

With latest revision, it works fine here.

[Stephane Wirtel (OpenERP) (stephane-openerp)]

Fixed.

Improve the query and check if the locations or the products are not empties