Trunk: Unlink fails for single record!

[Michael Dubois]

Hi,

the action 'delete' in resource reports errors msg:
[2010-04-01 14:42:13,823] ERROR:web-services:[01]: Traceback (most recent call last):
[2010-04-01 14:42:13,824] ERROR:web-services:[02]: File "/home/mdu/trunk/openobject-server/bin/osv/osv.py", line 57, in wrapper
[2010-04-01 14:42:13,824] ERROR:web-services:[03]: return f(self, dbname, *args, **kwargs)
[2010-04-01 14:42:13,824] ERROR:web-services:[04]: File "/home/mdu/trunk/openobject-server/bin/osv/osv.py", line 120, in execute
[2010-04-01 14:42:13,825] ERROR:web-services:[05]: res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
[2010-04-01 14:42:13,825] ERROR:web-services:[06]: File "/home/mdu/trunk/openobject-server/bin/osv/osv.py", line 110, in execute_cr
[2010-04-01 14:42:13,826] ERROR:web-services:[07]: return getattr(object, method)(cr, uid, *args, **kw)
[2010-04-01 14:42:13,826] ERROR:web-services:[08]: File "/home/mdu/trunk/openobject-server/bin/osv/orm.py", line 2787, in unlink
[2010-04-01 14:42:13,826] ERROR:web-services:[09]: 'where id in %s', sub_ids)
[2010-04-01 14:42:13,827] ERROR:web-services:[10]: File "/home/mdu/trunk/openobject-server/bin/sql_db.py", line 74, in wrapper
[2010-04-01 14:42:13,827] ERROR:web-services:[11]: return f(self, *args, **kwargs)
[2010-04-01 14:42:13,829] ERROR:web-services:[12]: File "/home/mdu/trunk/openobject-server/bin/sql_db.py", line 119, in execute
[2010-04-01 14:42:13,829] ERROR:web-services:[13]: res = self._obj.execute(query, params)
[2010-04-01 14:42:13,830] ERROR:web-services:[14]: ProgrammingError: ERREUR: erreur de syntaxe sur ou près de « 9 »
[2010-04-01 14:42:13,830] ERROR:web-services:[15]: LIGNE 1 : delete from resource_resource where id in 9
[2010-04-01 14:42:13,830] ERROR:web-services:[16]: ^

thx, mike

[Mustufa Rangwala (Open ERP) (mra-tinyerp)]

Hello Mike,

Its not problem from project/resource module .. its problem occured from openobject-server => orm

[Paul J Stevens (paul-nfg)]

Attached patch fixes the broken unlinking of records

[Jay Vora (Serpent Consulting Services) (jayvora)]

It has been fixed by revision 2176 <email address hidden>.
Thank you for reporting Michael.
Thank you for your interest Paul.