Invoice from Repair Module fail in 5.0.14

[luis tobar]

Module mrp_repair.

invoice from repair module with Operations and/or Fees fail in 5.0.14 , (run successfully in 5.0.9)

I was testing, with operatios and/or fees added similar in both versions and over debian SO but in all cases the 5.014 result is :

[2010-09-23 23:16:22,141][HotelSurazo] ERROR:orm:[01]:
[2010-09-23 23:16:22,141][HotelSurazo] ERROR:orm:[02]: Environment Information :
[2010-09-23 23:16:22,142][HotelSurazo] ERROR:orm:[03]: System : Linux-2.6.28-19-server-i686-with-Ubuntu-9.04-jaunty
[2010-09-23 23:16:22,142][HotelSurazo] ERROR:orm:[04]: OS Name : posix
[2010-09-23 23:16:22,143][HotelSurazo] ERROR:orm:[05]: Distributor ID: Ubuntu
[2010-09-23 23:16:22,143][HotelSurazo] ERROR:orm:[06]: Description: Ubuntu 9.04
[2010-09-23 23:16:22,143][HotelSurazo] ERROR:orm:[07]: Release: 9.04
[2010-09-23 23:16:22,144][HotelSurazo] ERROR:orm:[08]: Codename: jaunty
[2010-09-23 23:16:22,144][HotelSurazo] ERROR:orm:[09]: Operating System Release : 2.6.28-19-server
[2010-09-23 23:16:22,144][HotelSurazo] ERROR:orm:[10]: Operating System Version : #65-Ubuntu SMP Thu Sep 16 15:15:59 UTC 2010
[2010-09-23 23:16:22,145][HotelSurazo] ERROR:orm:[11]: Operating System Architecture : 32bit
[2010-09-23 23:16:22,145][HotelSurazo] ERROR:orm:[12]: Operating System Locale : es_CL.UTF8
[2010-09-23 23:16:22,146][HotelSurazo] ERROR:orm:[13]: Python Version : 2.6.2
[2010-09-23 23:16:22,146][HotelSurazo] ERROR:orm:[14]: OpenERP-Server Version : 5.0.14
[2010-09-23 23:16:22,146][HotelSurazo] ERROR:orm:[15]: Last revision No. & ID :
[2010-09-23 23:16:22,147][HotelSurazo] ERROR:orm:[16]: Programming error: field '__conform__' does not exist in object 'account.account' !
sh: bzr: not found
[2010-09-23 23:16:22,257][HotelSurazo] ERROR:orm:[01]:
[2010-09-23 23:16:22,258][HotelSurazo] ERROR:orm:[02]: Environment Information :
[2010-09-23 23:16:22,258][HotelSurazo] ERROR:orm:[03]: System : Linux-2.6.28-19-server-i686-with-Ubuntu-9.04-jaunty
[2010-09-23 23:16:22,258][HotelSurazo] ERROR:orm:[04]: OS Name : posix
[2010-09-23 23:16:22,259][HotelSurazo] ERROR:orm:[05]: Distributor ID: Ubuntu
[2010-09-23 23:16:22,259][HotelSurazo] ERROR:orm:[06]: Description: Ubuntu 9.04
[2010-09-23 23:16:22,259][HotelSurazo] ERROR:orm:[07]: Release: 9.04
[2010-09-23 23:16:22,259][HotelSurazo] ERROR:orm:[08]: Codename: jaunty
[2010-09-23 23:16:22,260][HotelSurazo] ERROR:orm:[09]: Operating System Release : 2.6.28-19-server
[2010-09-23 23:16:22,260][HotelSurazo] ERROR:orm:[10]: Operating System Version : #65-Ubuntu SMP Thu Sep 16 15:15:59 UTC 2010
[2010-09-23 23:16:22,260][HotelSurazo] ERROR:orm:[11]: Operating System Architecture : 32bit
[2010-09-23 23:16:22,260][HotelSurazo] ERROR:orm:[12]: Operating System Locale : es_CL.UTF8
[2010-09-23 23:16:22,260][HotelSurazo] ERROR:orm:[13]: Python Version : 2.6.2
[2010-09-23 23:16:22,261][HotelSurazo] ERROR:orm:[14]: OpenERP-Server Version : 5.0.14
[2010-09-23 23:16:22,261][HotelSurazo] ERROR:orm:[15]: Last revision No. & ID :
[2010-09-23 23:16:22,261][HotelSurazo] ERROR:orm:[16]: Programming error: field '__conform__' does not exist in object 'account.account' !
sh: bzr: not found
[2010-09-23 23:16:22,343][HotelSurazo] ERROR:web-services:[01]:
[2010-09-23 23:16:22,344][HotelSurazo] ERROR:web-services:[02]: Environment Information :
[2010-09-23 23:16:22,344][HotelSurazo] ERROR:web-services:[03]: System : Linux-2.6.28-19-server-i686-with-Ubuntu-9.04-jaunty
[2010-09-23 23:16:22,345][HotelSurazo] ERROR:web-services:[04]: OS Name : posix
[2010-09-23 23:16:22,345][HotelSurazo] ERROR:web-services:[05]: Distributor ID: Ubuntu
[2010-09-23 23:16:22,346][HotelSurazo] ERROR:web-services:[06]: Description: Ubuntu 9.04
[2010-09-23 23:16:22,346][HotelSurazo] ERROR:web-services:[07]: Release: 9.04
[2010-09-23 23:16:22,346][HotelSurazo] ERROR:web-services:[08]: Codename: jaunty
[2010-09-23 23:16:22,346][HotelSurazo] ERROR:web-services:[09]: Operating System Release : 2.6.28-19-server
[2010-09-23 23:16:22,347][HotelSurazo] ERROR:web-services:[10]: Operating System Version : #65-Ubuntu SMP Thu Sep 16 15:15:59 UTC 2010
[2010-09-23 23:16:22,347][HotelSurazo] ERROR:web-services:[11]: Operating System Architecture : 32bit
[2010-09-23 23:16:22,347][HotelSurazo] ERROR:web-services:[12]: Operating System Locale : es_CL.UTF8
[2010-09-23 23:16:22,347][HotelSurazo] ERROR:web-services:[13]: Python Version : 2.6.2
[2010-09-23 23:16:22,348][HotelSurazo] ERROR:web-services:[14]: OpenERP-Server Version : 5.0.14
[2010-09-23 23:16:22,348][HotelSurazo] ERROR:web-services:[15]: Last revision No. & ID :
[2010-09-23 23:16:22,348][HotelSurazo] ERROR:web-services:[16]: Traceback (most recent call last):
[2010-09-23 23:16:22,348][HotelSurazo] ERROR:web-services:[17]: File "/home/luis/openerp-server-5.0.14/bin/osv/osv.py", line 58, in wrapper
[2010-09-23 23:16:22,349][HotelSurazo] ERROR:web-services:[18]: return f(self, dbname, *args, **kwargs)
[2010-09-23 23:16:22,349][HotelSurazo] ERROR:web-services:[19]: File "/home/luis/openerp-server-5.0.14/bin/osv/osv.py", line 137, in exec_workflow
[2010-09-23 23:16:22,349][HotelSurazo] ERROR:web-services:[20]: res = self.exec_workflow_cr(cr, uid, obj, method, *args)
[2010-09-23 23:16:22,349][HotelSurazo] ERROR:web-services:[21]: File "/home/luis/openerp-server-5.0.14/bin/osv/osv.py", line 130, in exec_workflow_cr
[2010-09-23 23:16:22,350][HotelSurazo] ERROR:web-services:[22]: return wf_service.trg_validate(uid, obj, args[0], method, cr)
[2010-09-23 23:16:22,350][HotelSurazo] ERROR:web-services:[23]: File "/home/luis/openerp-server-5.0.14/bin/workflow/wkf_service.py", line 81, in trg_validate
[2010-09-23 23:16:22,350][HotelSurazo] ERROR:web-services:[24]: res2 = instance.validate(cr, id, ident, signal)
[2010-09-23 23:16:22,350][HotelSurazo] ERROR:web-services:[25]: File "/home/luis/openerp-server-5.0.14/bin/workflow/instance.py", line 50, in validate
[2010-09-23 23:16:22,351][HotelSurazo] ERROR:web-services:[26]: workitem.process(cr, witem, ident, signal, force_running, stack=stack)
[2010-09-23 23:16:22,351][HotelSurazo] ERROR:web-services:[27]: File "/home/luis/openerp-server-5.0.14/bin/workflow/workitem.py", line 62, in process
[2010-09-23 23:16:22,351][HotelSurazo] ERROR:web-services:[28]: ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
[2010-09-23 23:16:22,352][HotelSurazo] ERROR:web-services:[29]: File "/home/luis/openerp-server-5.0.14/bin/workflow/workitem.py", line 175, in _split_test
[2010-09-23 23:16:22,352][HotelSurazo] ERROR:web-services:[30]: _join_test(cr, t[0], t[1], ident, stack)
[2010-09-23 23:16:22,352][HotelSurazo] ERROR:web-services:[31]: File "/home/luis/openerp-server-5.0.14/bin/workflow/workitem.py", line 183, in _join_test
[2010-09-23 23:16:22,352][HotelSurazo] ERROR:web-services:[32]: create(cr,[activity], inst_id, ident, stack)
[2010-09-23 23:16:22,353][HotelSurazo] ERROR:web-services:[33]: File "/home/luis/openerp-server-5.0.14/bin/workflow/workitem.py", line 42, in create
[2010-09-23 23:16:22,353][HotelSurazo] ERROR:web-services:[34]: process(cr, res, ident, stack=stack)
[2010-09-23 23:16:22,353][HotelSurazo] ERROR:web-services:[35]: File "/home/luis/openerp-server-5.0.14/bin/workflow/workitem.py", line 54, in process
[2010-09-23 23:16:22,353][HotelSurazo] ERROR:web-services:[36]: result = _execute(cr, workitem, activity, ident, stack)
[2010-09-23 23:16:22,353][HotelSurazo] ERROR:web-services:[37]: File "/home/luis/openerp-server-5.0.14/bin/workflow/workitem.py", line 108, in _execute
[2010-09-23 23:16:22,354][HotelSurazo] ERROR:web-services:[38]: wkf_expr.execute(cr, ident, workitem, activity)
[2010-09-23 23:16:22,356][HotelSurazo] ERROR:web-services:[39]: File "/home/luis/openerp-server-5.0.14/bin/workflow/wkf_expr.py", line 69, in execute
[2010-09-23 23:16:22,357][HotelSurazo] ERROR:web-services:[40]: return _eval_expr(cr, ident, workitem, activity['action'])
[2010-09-23 23:16:22,357][HotelSurazo] ERROR:web-services:[41]: File "/home/luis/openerp-server-5.0.14/bin/workflow/wkf_expr.py", line 59, in _eval_expr
[2010-09-23 23:16:22,357][HotelSurazo] ERROR:web-services:[42]: ret = eval(line, env, nocopy=True)
[2010-09-23 23:16:22,357][HotelSurazo] ERROR:web-services:[43]: File "/home/luis/openerp-server-5.0.14/bin/tools/safe_eval.py", line 267, in safe_eval
[2010-09-23 23:16:22,358][HotelSurazo] ERROR:web-services:[44]: return eval(test_expr(expr,_SAFE_OPCODES, mode=mode), globals_dict, locals_dict)
[2010-09-23 23:16:22,358][HotelSurazo] ERROR:web-services:[45]: File "", line 1, in <module>
[2010-09-23 23:16:22,358][HotelSurazo] ERROR:web-services:[46]: File "/home/luis/openerp-server-5.0.14/bin/osv/orm.py", line 168, in <lambda>
[2010-09-23 23:16:22,358][HotelSurazo] ERROR:web-services:[47]: return lambda *args, **argv: getattr(self._table, name)(self._cr, self._uid, [self._id], *args, **argv)
[2010-09-23 23:16:22,359][HotelSurazo] ERROR:web-services:[48]: File "/home/luis/openerp-server-5.0.14/bin/addons/mrp_repair/mrp_repair.py", line 253, in wkf_invoice_create
[2010-09-23 23:16:22,359][HotelSurazo] ERROR:web-services:[49]: return self.action_invoice_create(cr, uid, ids)
[2010-09-23 23:16:22,359][HotelSurazo] ERROR:web-services:[50]: File "/home/luis/openerp-server-5.0.14/bin/addons/mrp_repair/mrp_repair.py", line 346, in action_invoice_create
[2010-09-23 23:16:22,359][HotelSurazo] ERROR:web-services:[51]: 'price_subtotal': fee.product_uom_qty*fee.price_unit
[2010-09-23 23:16:22,359][HotelSurazo] ERROR:web-services:[52]: File "/home/luis/openerp-server-5.0.14/bin/addons/membership.zip/membership/membership.py", line 691, in create
[2010-09-23 23:16:22,360][HotelSurazo] ERROR:web-services:[53]: result = super(account_invoice_line, self).create(cr, uid, vals, context)
[2010-09-23 23:16:22,360][HotelSurazo] ERROR:web-services:[54]: File "/home/luis/openerp-server-5.0.14/bin/osv/orm.py", line 2869, in create
[2010-09-23 23:16:22,360][HotelSurazo] ERROR:web-services:[55]: cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
[2010-09-23 23:16:22,360][HotelSurazo] ERROR:web-services:[56]: File "/home/luis/openerp-server-5.0.14/bin/sql_db.py", line 78, in wrapper
[2010-09-23 23:16:22,361][HotelSurazo] ERROR:web-services:[57]: return f(self, *args, **kwargs)
[2010-09-23 23:16:22,361][HotelSurazo] ERROR:web-services:[58]: File "/home/luis/openerp-server-5.0.14/bin/sql_db.py", line 123, in execute
[2010-09-23 23:16:22,361][HotelSurazo] ERROR:web-services:[59]: res = self._obj.execute(query, params)
[2010-09-23 23:16:22,361][HotelSurazo] ERROR:web-services:[60]: ProgrammingError: can't adapt

Regards

Luis Tobar

[luis tobar (ltobar)]

More information,

The invoice_id fields must be integer but the system assign wrong 28L in this case.

Regards.
Luis

/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py(123)execute()
-> res = self._obj.execute(query, params)
(Pdb) query
'insert into "account_invoice_line" (id,"origin","uos_id","name","invoice_id","price_unit","price_subtotal","account_id","discount","product_id","quantity",create_uid,create_date) values (22,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,now())'
(Pdb) params
('RMA00002', 2, 'Palta', 28L, 1450.8499999999999, 290.17000000000002, browse_record(account.account, 38), 0.0, 21, 0.20000000000000001, 1)
(Pdb)

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

Thanks for reporting.

Fixed in
stable : 2858 <email address hidden>
trunk : 5001 <email address hidden>

[luis tobar (ltobar)]

We can now say " The Repair Module was repaired".

Thanks a lots

On 27-09-2010, at 7:53, Jay (OpenERP) wrote:

> Thanks for reporting.
>
> Fixed in
> stable : 2858 <email address hidden>
> trunk : 5001 <email address hidden>
>
> ** Changed in: openobject-addons/5.0
> Status: Confirmed => Fix Released
>
> ** Changed in: openobject-addons/trunk
> Status: Confirmed => Fix Released
>
> --
> Invoice from Repair Module fail in 5.0.14
> https://bugs.launchpad.net/bugs/646551
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in OpenObject Addons Modules: Fix Released
> Status in OpenObject Addons 5.0 series: Fix Released
> Status in OpenObject Addons trunk series: Fix Released
>
> Bug description:
> Module mrp_repair.
>
>
> invoice from repair module with Operations and/or Fees fail in
> 5.0.14 , (run successfully in 5.0.9)
>
> I was testing, with operatios and/or fees added similar in both
> versions and over debian SO but in all cases the 5.014 result is :
>
>
> [2010-09-23 23:16:22,141][HotelSurazo] ERROR:orm:[01]:
> [2010-09-23 23:16:22,141][HotelSurazo] ERROR:orm:[02]: Environment
> Information :
> [2010-09-23 23:16:22,142][HotelSurazo] ERROR:orm:[03]: System :
> Linux-2.6.28-19-server-i686-with-Ubuntu-9.04-jaunty
> [2010-09-23 23:16:22,142][HotelSurazo] ERROR:orm:[04]: OS Name : posix
> [2010-09-23 23:16:22,143][HotelSurazo] ERROR:orm:[05]: Distributor
> ID: Ubuntu
> [2010-09-23 23:16:22,143][HotelSurazo] ERROR:orm:[06]: Description:
> Ubuntu 9.04
> [2010-09-23 23:16:22,143][HotelSurazo] ERROR:orm:[07]: Release: 9.04
> [2010-09-23 23:16:22,144][HotelSurazo] ERROR:orm:[08]: Codename:
> jaunty
> [2010-09-23 23:16:22,144][HotelSurazo] ERROR:orm:[09]: Operating
> System Release : 2.6.28-19-server
> [2010-09-23 23:16:22,144][HotelSurazo] ERROR:orm:[10]: Operating
> System Version : #65-Ubuntu SMP Thu Sep 16 15:15:59 UTC 2010
> [2010-09-23 23:16:22,145][HotelSurazo] ERROR:orm:[11]: Operating
> System Architecture : 32bit
> [2010-09-23 23:16:22,145][HotelSurazo] ERROR:orm:[12]: Operating
> System Locale : es_CL.UTF8
> [2010-09-23 23:16:22,146][HotelSurazo] ERROR:orm:[13]: Python
> Version : 2.6.2
> [2010-09-23 23:16:22,146][HotelSurazo] ERROR:orm:[14]: OpenERP-
> Server Version : 5.0.14
> [2010-09-23 23:16:22,146][HotelSurazo] ERROR:orm:[15]: Last revision
> No. & ID :
> [2010-09-23 23:16:22,147][HotelSurazo] ERROR:orm:[16]: Programming
> error: field '__conform__' does not exist in object
> 'account.account' !
> sh: bzr: not found
> [2010-09-23 23:16:22,257][HotelSurazo] ERROR:orm:[01]:
> [2010-09-23 23:16:22,258][HotelSurazo] ERROR:orm:[02]: Environment
> Information :
> [2010-09-23 23:16:22,258][HotelSurazo] ERROR:orm:[03]: System :
> Linux-2.6.28-19-server-i686-with-Ubuntu-9.04-jaunty
> [2010-09-23 23:16:22,258][HotelSurazo] ERROR:orm:[04]: OS Name : posix
> [2010-09-23 23:16:22,259][HotelSurazo] ERROR:orm:[05]: Distributor
> ID: Ubuntu
> [2010-09-23 23:16:22,259][HotelSurazo] ERROR:orm:[06]: Description:
> Ubuntu 9.04
> [2010-09-23 23:16:22,259][HotelSurazo] ERROR:orm:[07]: Release: 9.04
> [20...