← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 680503] Re: Invalid parameter number: no parameters were bound

 

** Changed in: magentoerpconnect
       Status: Incomplete => Invalid

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to OpenERP Project Group.
https://bugs.launchpad.net/bugs/680503

Title:
  Invalid parameter number: no parameters were bound

Status in Magento OpenERP Connector:
  Invalid

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 jvo@xxxxxxxxxxx-20101116215440-yj9fihpd4nk1bahx
  [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 jvo@xxxxxxxxxxx-20101116215440-yj9fihpd4nk1bahx
  [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 jvo@xxxxxxxxxxx-20101116215440-yj9fihpd4nk1bahx
  [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 jvo@xxxxxxxxxxx-20101116215440-yj9fihpd4nk1bahx
  [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

To manage notifications about this bug go to:
https://bugs.launchpad.net/magentoerpconnect/+bug/680503/+subscriptions


References