c2c-oerpscenario team mailing list archive

[PatrickL <883840@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Hello
I'm using magento 1.5.1.° and openerp 5.0.15
Unable to import within Openerp New products created on magento
Unable to import New oders from magento if these orders have new products, not existing in Openerp

When importing new orders from mageto to openerp I have below results,
any idea ?

Traceback (most recent call last):
  File "/opt/5.0.15-0_openerp/server/bin/netsvc.py", line 299, in dispatch
    result = LocalService(service_name)(method, *params)
  File "/opt/5.0.15-0_openerp/server/bin/netsvc.py", line 77, in __call__
    return getattr(self, method)(*params)
  File "/opt/5.0.15-0_openerp/server/bin/service/web_services.py", line 577, in execute
    res = service.execute(db, uid, object, method, *args)
  File "/opt/5.0.15-0_openerp/server/bin/osv/osv.py", line 58, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/opt/5.0.15-0_openerp/server/bin/osv/osv.py", line 119, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/5.0.15-0_openerp/server/bin/osv/osv.py", line 111, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/openerp/server/bin/addons/base_sale_multichannels/sale.py", line 215, in import_orders
    self.import_shop_orders(cr, uid, shop, defaults, context)
  File "/opt/openerp/server/bin/addons/magentoerpconnect/sale.py", line 117, in import_shop_orders
    context=context))
  File "/opt/openerp/server/bin/addons/magentoerpconnect/magerp_osv.py", line 236, in mage_import_base
    rec_result = self.ext_import(cr, uid, rec_data, external_referential_id, defaults, context)
  File "/opt/openerp/server/bin/addons/base_external_referentials/external_osv.py", line 167, in ext_import
    vals = self.oevals_from_extdata(cr, uid, external_referential_id, each_row, for_key_field, mapping_lines, defaults, context)
  File "/opt/openerp/server/bin/addons/magentoerpconnect/sale.py", line 379, in oevals_from_extdata
    payment_settings = self.payment_code_to_payment_settings(cr, uid, data_record['payment']['method'], context)
  File "/opt/openerp/server/bin/addons/base_sale_multichannels/sale.py", line 301, in payment_code_to_payment_settings
    payment_setting_ids = self.pool.get('base.sale.payment.type').search(cr, uid, [['name', 'ilike', payment_code]])
  File "/opt/5.0.15-0_openerp/server/bin/osv/orm.py", line 3076, in search
    cr.execute('select %s.id from ' % self._table + ','.join(tables) +qu1+' order by '+order_by+limit_str+offset_str, qu2)
  File "/opt/5.0.15-0_openerp/server/bin/sql_db.py", line 78, in wrapper
    return f(self, *args, **kwargs)
  File "/opt/5.0.15-0_openerp/server/bin/sql_db.py", line 123, in execute
    res = self._obj.execute(query, params)
InternalError: ERREUR:  la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc
de la transaction

** Affects: magentoerpconnect
     Importance: Undecided
         Status: New

-- 
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/883840

Title:
  Can't import new products from magento 1.5 to openerp 5.

Status in Magento OpenERP Connector:
  New

Bug description:
  Hello
  I'm using magento 1.5.1.° and openerp 5.0.15
  Unable to import within Openerp New products created on magento
  Unable to import New oders from magento if these orders have new products, not existing in Openerp

  When importing new orders from mageto to openerp I have below results,
  any idea ?

  Traceback (most recent call last):
    File "/opt/5.0.15-0_openerp/server/bin/netsvc.py", line 299, in dispatch
      result = LocalService(service_name)(method, *params)
    File "/opt/5.0.15-0_openerp/server/bin/netsvc.py", line 77, in __call__
      return getattr(self, method)(*params)
    File "/opt/5.0.15-0_openerp/server/bin/service/web_services.py", line 577, in execute
      res = service.execute(db, uid, object, method, *args)
    File "/opt/5.0.15-0_openerp/server/bin/osv/osv.py", line 58, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/opt/5.0.15-0_openerp/server/bin/osv/osv.py", line 119, in execute
      res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/opt/5.0.15-0_openerp/server/bin/osv/osv.py", line 111, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/opt/openerp/server/bin/addons/base_sale_multichannels/sale.py", line 215, in import_orders
      self.import_shop_orders(cr, uid, shop, defaults, context)
    File "/opt/openerp/server/bin/addons/magentoerpconnect/sale.py", line 117, in import_shop_orders
      context=context))
    File "/opt/openerp/server/bin/addons/magentoerpconnect/magerp_osv.py", line 236, in mage_import_base
      rec_result = self.ext_import(cr, uid, rec_data, external_referential_id, defaults, context)
    File "/opt/openerp/server/bin/addons/base_external_referentials/external_osv.py", line 167, in ext_import
      vals = self.oevals_from_extdata(cr, uid, external_referential_id, each_row, for_key_field, mapping_lines, defaults, context)
    File "/opt/openerp/server/bin/addons/magentoerpconnect/sale.py", line 379, in oevals_from_extdata
      payment_settings = self.payment_code_to_payment_settings(cr, uid, data_record['payment']['method'], context)
    File "/opt/openerp/server/bin/addons/base_sale_multichannels/sale.py", line 301, in payment_code_to_payment_settings
      payment_setting_ids = self.pool.get('base.sale.payment.type').search(cr, uid, [['name', 'ilike', payment_code]])
    File "/opt/5.0.15-0_openerp/server/bin/osv/orm.py", line 3076, in search
      cr.execute('select %s.id from ' % self._table + ','.join(tables) +qu1+' order by '+order_by+limit_str+offset_str, qu2)
    File "/opt/5.0.15-0_openerp/server/bin/sql_db.py", line 78, in wrapper
      return f(self, *args, **kwargs)
    File "/opt/5.0.15-0_openerp/server/bin/sql_db.py", line 123, in execute
      res = self._obj.execute(query, params)
  InternalError: ERREUR:  la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc
  de la transaction

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