c2c-oerpscenario team mailing list archive

[PatrickL <883840@xxxxxxxxxxxxxxxxxx>]

** Changed in: magentoerpconnect
       Status: New => Confirmed

** Changed in: magentoerpconnect
     Assignee: PatrickL (putrwck) => (unassigned)

-- 
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:
  Confirmed

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