Invalid parameter number: no parameters were bound

Bug #680503 reported by Marie
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Magento OpenERP Connector
Invalid
Undecided
Unassigned

Bug Description

Hi,

We have a problem with your connector on OpenERP v5 rev 2155

Addons Rev : 2881
Extra Rev : 4881
Magento Rev : 355
Trunk Rev : 5142

Error log :

[2010-11-23 15:35:19,170][test] INFO:ext synchro:Updated in External Ref product.product from OpenERP with external_id 5505 and OpenERP id 744 successfully
[2010-11-23 15:35:20,695][test] INFO:ext synchro:Updated in External Ref product.product from OpenERP with external_id 5506 and OpenERP id 745 successfully
[2010-11-23 15:35:22,235][test] INFO:ext synchro:Updated in External Ref product.product from OpenERP with external_id 5507 and OpenERP id 746 successfully
[2010-11-23 15:35:23,760][test] INFO:ext synchro:Updated in External Ref product.product from OpenERP with external_id 5508 and OpenERP id 747 successfully
[2010-11-23 15:35:25,029][test] ERROR:Magento Call:[01]:
[2010-11-23 15:35:25,029][test] ERROR:Magento Call:[02]: Environment Information :
[2010-11-23 15:35:25,030][test] ERROR:Magento Call:[03]: System : Linux-2.6.35-22-generic-pae-i686-with-Ubuntu-10.10-maverick
[2010-11-23 15:35:25,030][test] ERROR:Magento Call:[04]: OS Name : posix
[2010-11-23 15:35:25,030][test] ERROR:Magento Call:[05]: Distributor ID: Ubuntu
[2010-11-23 15:35:25,030][test] ERROR:Magento Call:[06]: Description: Ubuntu 10.10
[2010-11-23 15:35:25,030][test] ERROR:Magento Call:[07]: Release: 10.10
[2010-11-23 15:35:25,030][test] ERROR:Magento Call:[08]: Codename: maverick
[2010-11-23 15:35:25,030][test] ERROR:Magento Call:[09]: Operating System Release : 2.6.35-22-generic-pae
[2010-11-23 15:35:25,030][test] ERROR:Magento Call:[10]: Operating System Version : #33-Ubuntu SMP Sun Sep 19 22:14:14 UTC 2010
[2010-11-23 15:35:25,030][test] ERROR:Magento Call:[11]: Operating System Architecture : 32bit
[2010-11-23 15:35:25,030][test] ERROR:Magento Call:[12]: Operating System Locale : fr_FR.UTF8
[2010-11-23 15:35:25,030][test] ERROR:Magento Call:[13]: Python Version : 2.6.6
[2010-11-23 15:35:25,030][test] ERROR:Magento Call:[14]: OpenERP-Server Version : 5.0.15
[2010-11-23 15:35:25,031][test] ERROR:Magento Call:[15]: Last revision No. & ID : 2155 <email address hidden>
[2010-11-23 15:35:25,031][test] ERROR:Magento Call:[16]:
[2010-11-23 15:35:25,031][test] ERROR:Magento Call:[17]: Method: product.create
[2010-11-23 15:35:25,031][test] ERROR:Magento Call:[18]: Arguments:[u'simple', 53, u'748', {'weight': 6.7999999999999998, 'type_id': u'simple', 'small_image_label': False, 'cost': 1.0, 'thumbnail_label': False, 'special_from_date': False, 'url_key': False, 'sku_int': u'PDM2332IEC-3P30R-1', 'description': u'<table id="product-attribute-specs-table" class="data-table" cellspacing="0"><tr class="first odd"><td class="label">Connexions de sortie</td><td class="data last">(3) IEC 309 32A </td></tr><tr class="even"><td class="label">Couleur</td><td class="data last">Noir, Bleu</td></tr><tr class="odd"><td class="label">Courant d\'entr\xe9e maximum par phase</td><td class="data last">32 A</td></tr><tr class="even"><td class="label">Dimensions L x P x H</td><td class="data last">432 x 406 x 254 mm</td></tr><tr class="odd"><td class="label">Fr\xe9quence d\'entr\xe9e</td><td class="data last">50 Hz</td></tr><tr class="even"><td class="label">Poids</td><td class="data last">7700 g</td></tr><tr class="odd"><td class="label">Source de donn\xe9es</td><td class="data last">ICEcat.biz</td></tr><tr class="even"><td class="label">Tension nominale \xe0 l\'entr\xe9e</td><td class="data last">400 V</td></tr><tr class="odd"><td class="label">Tension nominale de sortie</td><td class="data last">400 V</td></tr><tr class="last even"><td class="label">Type de connexion d\'entr\xe9e</td><td class="data last"> IEC 309 32A 3P+N+PE</td></tr></table>', 'meta_description': u"APC PDM2332IEC-3P30R-1 : APC PDM2332IEC-3P30R-1. Gestion d'\xe9nergie: 400 V, 50 Hz. Poids et dimensions: 432 x 406 x 254 mm, 7700 g APC PDM2332IEC-3P30R-1 achat et prix comparer discount promotion ", 'minimal_price': False, 'category_ids': [154], 'meta_keyword': u"APC PDM2332IEC-3P30R-1, pas chere PDM2332IEC-3P30R-1, unit\xe9s de distribution d'\xe9nergie, moins cher ", 'custom_design_to': False, 'short_description': u"APC PDM2332IEC-3P30R-1. Gestion d'\xe9nergie: 400 V, 50 Hz. Poids et dimensions: 432 x 406 x 254 mm, 7700 g", 'tax_class_id': u'5', 'status': u'1', 'meta_title': u'APC PDM2332IEC-3P30R-1 achat et prix comparer discount promotion ', 'custom_layout_update': False, 'news_to_date': False, 'price': 605.07000000000005, 'news_from_date': False, 'visibility': u'4', 'updated_at': False, 'manufacturer': u'52', 'required_options': False, 'name': u'PDM2332IEC-3P30R-1', 'created_at': False, 'websites': [1], 'special_to_date': False, 'product_navigation': False, 'custom_design_from': False, 'has_options': False, 'image_label': False}]
[2010-11-23 15:35:25,031][test] ERROR:Magento Call:[19]: Error:<Fault 1: 'SQLSTATE[HY093]: Invalid parameter number: no parameters were bound'>
[2010-11-23 15:35:25,033][test] WARNING:Magento Call:Webservice Failure, sleeping 1 second before next attempt
[2010-11-23 15:35:26,942][test] ERROR:Magento Call:[01]:
[2010-11-23 15:35:26,942][test] ERROR:Magento Call:[02]: Environment Information :
[2010-11-23 15:35:26,942][test] ERROR:Magento Call:[03]: System : Linux-2.6.35-22-generic-pae-i686-with-Ubuntu-10.10-maverick
[2010-11-23 15:35:26,942][test] ERROR:Magento Call:[04]: OS Name : posix
[2010-11-23 15:35:26,942][test] ERROR:Magento Call:[05]: Distributor ID: Ubuntu
[2010-11-23 15:35:26,942][test] ERROR:Magento Call:[06]: Description: Ubuntu 10.10
[2010-11-23 15:35:26,942][test] ERROR:Magento Call:[07]: Release: 10.10
[2010-11-23 15:35:26,942][test] ERROR:Magento Call:[08]: Codename: maverick
[2010-11-23 15:35:26,943][test] ERROR:Magento Call:[09]: Operating System Release : 2.6.35-22-generic-pae
[2010-11-23 15:35:26,943][test] ERROR:Magento Call:[10]: Operating System Version : #33-Ubuntu SMP Sun Sep 19 22:14:14 UTC 2010
[2010-11-23 15:35:26,943][test] ERROR:Magento Call:[11]: Operating System Architecture : 32bit
[2010-11-23 15:35:26,943][test] ERROR:Magento Call:[12]: Operating System Locale : fr_FR.UTF8
[2010-11-23 15:35:26,943][test] ERROR:Magento Call:[13]: Python Version : 2.6.6
[2010-11-23 15:35:26,943][test] ERROR:Magento Call:[14]: OpenERP-Server Version : 5.0.15
[2010-11-23 15:35:26,943][test] ERROR:Magento Call:[15]: Last revision No. & ID : 2155 <email address hidden>
[2010-11-23 15:35:26,943][test] ERROR:Magento Call:[16]:
[2010-11-23 15:35:26,943][test] ERROR:Magento Call:[17]: Method: product.create
[2010-11-23 15:35:26,943][test] ERROR:Magento Call:[18]: Arguments:[u'simple', 53, u'748', {'weight': 6.7999999999999998, 'type_id': u'simple', 'small_image_label': False, 'cost': 1.0, 'thumbnail_label': False, 'special_from_date': False, 'url_key': False, 'sku_int': u'PDM2332IEC-3P30R-1', 'description': u'<table id="product-attribute-specs-table" class="data-table" cellspacing="0"><tr class="first odd"><td class="label">Connexions de sortie</td><td class="data last">(3) IEC 309 32A </td></tr><tr class="even"><td class="label">Couleur</td><td class="data last">Noir, Bleu</td></tr><tr class="odd"><td class="label">Courant d\'entr\xe9e maximum par phase</td><td class="data last">32 A</td></tr><tr class="even"><td class="label">Dimensions L x P x H</td><td class="data last">432 x 406 x 254 mm</td></tr><tr class="odd"><td class="label">Fr\xe9quence d\'entr\xe9e</td><td class="data last">50 Hz</td></tr><tr class="even"><td class="label">Poids</td><td class="data last">7700 g</td></tr><tr class="odd"><td class="label">Source de donn\xe9es</td><td class="data last">ICEcat.biz</td></tr><tr class="even"><td class="label">Tension nominale \xe0 l\'entr\xe9e</td><td class="data last">400 V</td></tr><tr class="odd"><td class="label">Tension nominale de sortie</td><td class="data last">400 V</td></tr><tr class="last even"><td class="label">Type de connexion d\'entr\xe9e</td><td class="data last"> IEC 309 32A 3P+N+PE</td></tr></table>', 'meta_description': u"APC PDM2332IEC-3P30R-1 : APC PDM2332IEC-3P30R-1. Gestion d'\xe9nergie: 400 V, 50 Hz. Poids et dimensions: 432 x 406 x 254 mm, 7700 g APC PDM2332IEC-3P30R-1 achat et prix comparer discount promotion ", 'minimal_price': False, 'category_ids': [154], 'meta_keyword': u"APC PDM2332IEC-3P30R-1, pas chere PDM2332IEC-3P30R-1, unit\xe9s de distribution d'\xe9nergie, moins cher ", 'custom_design_to': False, 'short_description': u"APC PDM2332IEC-3P30R-1. Gestion d'\xe9nergie: 400 V, 50 Hz. Poids et dimensions: 432 x 406 x 254 mm, 7700 g", 'tax_class_id': u'5', 'status': u'1', 'meta_title': u'APC PDM2332IEC-3P30R-1 achat et prix comparer discount promotion ', 'custom_layout_update': False, 'news_to_date': False, 'price': 605.07000000000005, 'news_from_date': False, 'visibility': u'4', 'updated_at': False, 'manufacturer': u'52', 'required_options': False, 'name': u'PDM2332IEC-3P30R-1', 'created_at': False, 'websites': [1], 'special_to_date': False, 'product_navigation': False, 'custom_design_from': False, 'has_options': False, 'image_label': False}]
[2010-11-23 15:35:26,943][test] ERROR:Magento Call:[19]: Error:<Fault 1: 'SQLSTATE[HY093]: Invalid parameter number: no parameters were bound'>
[2010-11-23 15:35:26,945][test] WARNING:Magento Call:Webservice Failure, sleeping 3 second before next attempt
[2010-11-23 15:35:30,955][test] ERROR:Magento Call:[01]:
[2010-11-23 15:35:30,955][test] ERROR:Magento Call:[02]: Environment Information :
[2010-11-23 15:35:30,955][test] ERROR:Magento Call:[03]: System : Linux-2.6.35-22-generic-pae-i686-with-Ubuntu-10.10-maverick
[2010-11-23 15:35:30,956][test] ERROR:Magento Call:[04]: OS Name : posix
[2010-11-23 15:35:30,956][test] ERROR:Magento Call:[05]: Distributor ID: Ubuntu
[2010-11-23 15:35:30,956][test] ERROR:Magento Call:[06]: Description: Ubuntu 10.10
[2010-11-23 15:35:30,956][test] ERROR:Magento Call:[07]: Release: 10.10
[2010-11-23 15:35:30,956][test] ERROR:Magento Call:[08]: Codename: maverick
[2010-11-23 15:35:30,956][test] ERROR:Magento Call:[09]: Operating System Release : 2.6.35-22-generic-pae
[2010-11-23 15:35:30,956][test] ERROR:Magento Call:[10]: Operating System Version : #33-Ubuntu SMP Sun Sep 19 22:14:14 UTC 2010
[2010-11-23 15:35:30,956][test] ERROR:Magento Call:[11]: Operating System Architecture : 32bit
[2010-11-23 15:35:30,956][test] ERROR:Magento Call:[12]: Operating System Locale : fr_FR.UTF8
[2010-11-23 15:35:30,956][test] ERROR:Magento Call:[13]: Python Version : 2.6.6
[2010-11-23 15:35:30,956][test] ERROR:Magento Call:[14]: OpenERP-Server Version : 5.0.15
[2010-11-23 15:35:30,956][test] ERROR:Magento Call:[15]: Last revision No. & ID : 2155 <email address hidden>
[2010-11-23 15:35:30,956][test] ERROR:Magento Call:[16]:
[2010-11-23 15:35:30,957][test] ERROR:Magento Call:[17]: Method: product.create
[2010-11-23 15:35:30,957][test] ERROR:Magento Call:[18]: Arguments:[u'simple', 53, u'748', {'weight': 6.7999999999999998, 'type_id': u'simple', 'small_image_label': False, 'cost': 1.0, 'thumbnail_label': False, 'special_from_date': False, 'url_key': False, 'sku_int': u'PDM2332IEC-3P30R-1', 'description': u'<table id="product-attribute-specs-table" class="data-table" cellspacing="0"><tr class="first odd"><td class="label">Connexions de sortie</td><td class="data last">(3) IEC 309 32A </td></tr><tr class="even"><td class="label">Couleur</td><td class="data last">Noir, Bleu</td></tr><tr class="odd"><td class="label">Courant d\'entr\xe9e maximum par phase</td><td class="data last">32 A</td></tr><tr class="even"><td class="label">Dimensions L x P x H</td><td class="data last">432 x 406 x 254 mm</td></tr><tr class="odd"><td class="label">Fr\xe9quence d\'entr\xe9e</td><td class="data last">50 Hz</td></tr><tr class="even"><td class="label">Poids</td><td class="data last">7700 g</td></tr><tr class="odd"><td class="label">Source de donn\xe9es</td><td class="data last">ICEcat.biz</td></tr><tr class="even"><td class="label">Tension nominale \xe0 l\'entr\xe9e</td><td class="data last">400 V</td></tr><tr class="odd"><td class="label">Tension nominale de sortie</td><td class="data last">400 V</td></tr><tr class="last even"><td class="label">Type de connexion d\'entr\xe9e</td><td class="data last"> IEC 309 32A 3P+N+PE</td></tr></table>', 'meta_description': u"APC PDM2332IEC-3P30R-1 : APC PDM2332IEC-3P30R-1. Gestion d'\xe9nergie: 400 V, 50 Hz. Poids et dimensions: 432 x 406 x 254 mm, 7700 g APC PDM2332IEC-3P30R-1 achat et prix comparer discount promotion ", 'minimal_price': False, 'category_ids': [154], 'meta_keyword': u"APC PDM2332IEC-3P30R-1, pas chere PDM2332IEC-3P30R-1, unit\xe9s de distribution d'\xe9nergie, moins cher ", 'custom_design_to': False, 'short_description': u"APC PDM2332IEC-3P30R-1. Gestion d'\xe9nergie: 400 V, 50 Hz. Poids et dimensions: 432 x 406 x 254 mm, 7700 g", 'tax_class_id': u'5', 'status': u'1', 'meta_title': u'APC PDM2332IEC-3P30R-1 achat et prix comparer discount promotion ', 'custom_layout_update': False, 'news_to_date': False, 'price': 605.07000000000005, 'news_from_date': False, 'visibility': u'4', 'updated_at': False, 'manufacturer': u'52', 'required_options': False, 'name': u'PDM2332IEC-3P30R-1', 'created_at': False, 'websites': [1], 'special_to_date': False, 'product_navigation': False, 'custom_design_from': False, 'has_options': False, 'image_label': False}]
[2010-11-23 15:35:30,957][test] ERROR:Magento Call:[19]: Error:<Fault 1: 'SQLSTATE[HY093]: Invalid parameter number: no parameters were bound'>
[2010-11-23 15:35:30,959][test] WARNING:Magento Call:Webservice Failure, sleeping 6 second before next attempt
[2010-11-23 15:35:37,104][test] ERROR:web-services:[01]:
[2010-11-23 15:35:37,104][test] ERROR:web-services:[02]: Environment Information :
[2010-11-23 15:35:37,104][test] ERROR:web-services:[03]: System : Linux-2.6.35-22-generic-pae-i686-with-Ubuntu-10.10-maverick
[2010-11-23 15:35:37,104][test] ERROR:web-services:[04]: OS Name : posix
[2010-11-23 15:35:37,104][test] ERROR:web-services:[05]: Distributor ID: Ubuntu
[2010-11-23 15:35:37,105][test] ERROR:web-services:[06]: Description: Ubuntu 10.10
[2010-11-23 15:35:37,105][test] ERROR:web-services:[07]: Release: 10.10
[2010-11-23 15:35:37,105][test] ERROR:web-services:[08]: Codename: maverick
[2010-11-23 15:35:37,105][test] ERROR:web-services:[09]: Operating System Release : 2.6.35-22-generic-pae
[2010-11-23 15:35:37,105][test] ERROR:web-services:[10]: Operating System Version : #33-Ubuntu SMP Sun Sep 19 22:14:14 UTC 2010
[2010-11-23 15:35:37,105][test] ERROR:web-services:[11]: Operating System Architecture : 32bit
[2010-11-23 15:35:37,105][test] ERROR:web-services:[12]: Operating System Locale : fr_FR.UTF8
[2010-11-23 15:35:37,105][test] ERROR:web-services:[13]: Python Version : 2.6.6
[2010-11-23 15:35:37,105][test] ERROR:web-services:[14]: OpenERP-Server Version : 5.0.15
[2010-11-23 15:35:37,105][test] ERROR:web-services:[15]: Last revision No. & ID : 2155 <email address hidden>
[2010-11-23 15:35:37,105][test] ERROR:web-services:[16]:
[2010-11-23 15:35:37,105][test] ERROR:web-services:[17]: Traceback (most recent call last):
[2010-11-23 15:35:37,106][test] ERROR:web-services:[18]: File "/opt/openerp/server/bin/osv/osv.py", line 58, in wrapper
[2010-11-23 15:35:37,106][test] ERROR:web-services:[19]: return f(self, dbname, *args, **kwargs)
[2010-11-23 15:35:37,106][test] ERROR:web-services:[20]: File "/opt/openerp/server/bin/osv/osv.py", line 119, in execute
[2010-11-23 15:35:37,106][test] ERROR:web-services:[21]: res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
[2010-11-23 15:35:37,106][test] ERROR:web-services:[22]: File "/opt/openerp/server/bin/osv/osv.py", line 111, in execute_cr
[2010-11-23 15:35:37,106][test] ERROR:web-services:[23]: return getattr(object, method)(cr, uid, *args, **kw)
[2010-11-23 15:35:37,106][test] ERROR:web-services:[24]: File "/opt/openerp/addons/base_sale_multichannels/sale.py", line 169, in export_catalog
[2010-11-23 15:35:37,106][test] ERROR:web-services:[25]: self.export_products(cr, uid, shop, context)
[2010-11-23 15:35:37,106][test] ERROR:web-services:[26]: File "/opt/openerp/addons/base_sale_multichannels/sale.py", line 160, in export_products
[2010-11-23 15:35:37,106][test] ERROR:web-services:[27]: self.export_products_collection(cr, uid, shop, shop.exportable_product_ids, context)
[2010-11-23 15:35:37,106][test] ERROR:web-services:[28]: File "/opt/openerp/addons/base_sale_multichannels/sale.py", line 157, in export_products_collection
[2010-11-23 15:35:37,106][test] ERROR:web-services:[29]: self.pool.get('product.product').ext_export(cr, uid, [product.id for product in shop.exportable_product_ids] , [shop.referential_id.id], {}, context)
[2010-11-23 15:35:37,107][test] ERROR:web-services:[30]: File "/opt/openerp/addons/magento/product.py", line 970, in ext_export
[2010-11-23 15:35:37,107][test] ERROR:web-services:[31]: temp_result = super(magerp_osv.magerp_osv, self).ext_export(cr, uid, [id], external_referential_ids, defaults, context_storeview)
[2010-11-23 15:35:37,107][test] ERROR:web-services:[32]: File "/opt/openerp/addons/base_external_referentials/external_osv.py", line 326, in ext_export
[2010-11-23 15:35:37,107][test] ERROR:web-services:[33]: crid = self.ext_create(cr, uid, exp_data, conn, mapping_rec['external_create_method'], record_data['id'], context)
[2010-11-23 15:35:37,107][test] ERROR:web-services:[34]: File "/opt/openerp/addons/magento/product.py", line 875, in ext_create
[2010-11-23 15:35:37,107][test] ERROR:web-services:[35]: res = super(magerp_osv.magerp_osv, self).ext_create(cr, uid, [product_type, attr_set_id, sku, data], conn, method, oe_id, context)
[2010-11-23 15:35:37,107][test] ERROR:web-services:[36]: File "/opt/openerp/addons/base_external_referentials/external_osv.py", line 346, in ext_create
[2010-11-23 15:35:37,107][test] ERROR:web-services:[37]: return conn.call(method, data)
[2010-11-23 15:35:37,107][test] ERROR:web-services:[38]: File "/opt/openerp/addons/magento/magerp_osv.py", line 53, in call
[2010-11-23 15:35:37,107][test] ERROR:web-services:[39]: res = self.ser.call(self.session, method, arguments)
[2010-11-23 15:35:37,107][test] ERROR:web-services:[40]: File "/usr/lib/python2.6/xmlrpclib.py", line 1199, in __call__
[2010-11-23 15:35:37,107][test] ERROR:web-services:[41]: return self.__send(self.__name, args)
[2010-11-23 15:35:37,108][test] ERROR:web-services:[42]: File "/usr/lib/python2.6/xmlrpclib.py", line 1489, in __request
[2010-11-23 15:35:37,108][test] ERROR:web-services:[43]: verbose=self.__verbose
[2010-11-23 15:35:37,108][test] ERROR:web-services:[44]: File "/usr/lib/python2.6/xmlrpclib.py", line 1253, in request
[2010-11-23 15:35:37,108][test] ERROR:web-services:[45]: return self._parse_response(h.getfile(), sock)
[2010-11-23 15:35:37,108][test] ERROR:web-services:[46]: File "/usr/lib/python2.6/xmlrpclib.py", line 1392, in _parse_response
[2010-11-23 15:35:37,108][test] ERROR:web-services:[47]: return u.close()
[2010-11-23 15:35:37,108][test] ERROR:web-services:[48]: File "/usr/lib/python2.6/xmlrpclib.py", line 838, in close
[2010-11-23 15:35:37,108][test] ERROR:web-services:[49]: raise Fault(**self._stack[0])
[2010-11-23 15:35:37,108][test] ERROR:web-services:[50]: Fault: <Fault 1: 'SQLSTATE[HY093]: Invalid parameter number: no parameters were bound'>

Thank you

Revision history for this message
Sébastien BEAU - http://www.akretion.com (sebastien.beau) wrote :

Do you still have the bug with the last version?

Changed in magentoerpconnect:
status: New → Incomplete
Changed in magentoerpconnect:
status: Incomplete → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.