** 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 [email protected]
[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 protected]
[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 protected]
[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 protected]
[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
_______________________________________________
Mailing list: https://launchpad.net/~c2c-oerpscenario
Post to : [email protected]
Unsubscribe : https://launchpad.net/~c2c-oerpscenario
More help : https://help.launchpad.net/ListHelp
