c2c-oerpscenario team mailing list archive

[Guilleret Florian <732074@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

When I try to import Order  I have this error message:

[2011-03-09 16:53:23,524][new_new_erp] ERROR:db.cursor:Programming error: ERREUR:  la colonne sale_shop.sale_journal n'existe pas
LIGNE 1 : SELECT sale_shop.sale_journal,sale_shop.is_tax_included,sale...
                 ^
, in query SELECT sale_shop.sale_journal,sale_shop.is_tax_included,sale_shop.warehouse_id,sale_shop.allow_magento_notification,sale_shop.shop_group_id,sale_shop.magento_root_category,sale_shop.last_update_order_export_date,sale_shop.name,sale_shop.last_images_export_date,sale_shop.allow_magento_order_status_push,sale_shop.last_products_export_date,sale_shop.default_storeview_integer_id,sale_shop.auto_import,sale_shop.company_id,sale_shop.magento_shop,sale_shop.last_inventory_export_date,sale_shop.pricelist_id,sale_shop.project_id,sale_shop.root_category_id,sale_shop.payment_default_id,sale_shop.id FROM "sale_shop" WHERE sale_shop.id IN %s ORDER BY id
[2011-03-09 16:53:23,525][new_new_erp] ERROR:db.cursor:bad query: SELECT sale_shop.sale_journal,sale_shop.is_tax_included,sale_shop.warehouse_id,sale_shop.allow_magento_notification,sale_shop.shop_group_id,sale_shop.magento_root_category,sale_shop.last_update_order_export_date,sale_shop.name,sale_shop.last_images_export_date,sale_shop.allow_magento_order_status_push,sale_shop.last_products_export_date,sale_shop.default_storeview_integer_id,sale_shop.auto_import,sale_shop.company_id,sale_shop.magento_shop,sale_shop.last_inventory_export_date,sale_shop.pricelist_id,sale_shop.project_id,sale_shop.root_category_id,sale_shop.payment_default_id,sale_shop.id FROM "sale_shop" WHERE sale_shop.id IN (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19) ORDER BY id
Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 131, 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


2011-03-09 16:53:23,555][new_new_erp] ERROR:netsvc.agent:Job call of self.pool.get('sale.shop').run_import_orders_scheduler(cr, uid, *()) failed
Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/base/ir/ir_cron.py", line 94, in _callback
    f(cr, uid, *args)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/magentoerpconnect/sale.py", line 256, in run_import_orders_scheduler
    self._sale_shop(cr, uid, self.import_orders, context=context)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/magentoerpconnect/sale.py", line 248, in _sale_shop
    callback(cr, uid, ids, context=context)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/base_sale_multichannels/sale.py", line 177, in import_orders
    context['conn_obj'] = self.external_connection(cr, uid, shop.referential_id)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/magentoerpconnect/magerp_osv.py", line 84, in external_connection
    attr_conn = Connection(referential.location, referential.apiusername, referential.apipass, DEBUG)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/magentoerpconnect/magerp_osv.py", line 14, in __init__
    if not location[-1] == '/':
TypeError: 'NoneType' object is unsubscriptable


I said me that column sale_shop.sale_journal  doesn't existe but it's very strange cause base_sale_multichannels is installed my server.

Do you know why ?

** Affects: magentoerpconnect
     Importance: Undecided
         Status: New

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

Title:
  Import Order Failed

Status in Magento Open ERP Connector:
  New

Bug description:
  When I try to import Order  I have this error message:

  [2011-03-09 16:53:23,524][new_new_erp] ERROR:db.cursor:Programming error: ERREUR:  la colonne sale_shop.sale_journal n'existe pas
  LIGNE 1 : SELECT sale_shop.sale_journal,sale_shop.is_tax_included,sale...
                   ^
  , in query SELECT sale_shop.sale_journal,sale_shop.is_tax_included,sale_shop.warehouse_id,sale_shop.allow_magento_notification,sale_shop.shop_group_id,sale_shop.magento_root_category,sale_shop.last_update_order_export_date,sale_shop.name,sale_shop.last_images_export_date,sale_shop.allow_magento_order_status_push,sale_shop.last_products_export_date,sale_shop.default_storeview_integer_id,sale_shop.auto_import,sale_shop.company_id,sale_shop.magento_shop,sale_shop.last_inventory_export_date,sale_shop.pricelist_id,sale_shop.project_id,sale_shop.root_category_id,sale_shop.payment_default_id,sale_shop.id FROM "sale_shop" WHERE sale_shop.id IN %s ORDER BY id
  [2011-03-09 16:53:23,525][new_new_erp] ERROR:db.cursor:bad query: SELECT sale_shop.sale_journal,sale_shop.is_tax_included,sale_shop.warehouse_id,sale_shop.allow_magento_notification,sale_shop.shop_group_id,sale_shop.magento_root_category,sale_shop.last_update_order_export_date,sale_shop.name,sale_shop.last_images_export_date,sale_shop.allow_magento_order_status_push,sale_shop.last_products_export_date,sale_shop.default_storeview_integer_id,sale_shop.auto_import,sale_shop.company_id,sale_shop.magento_shop,sale_shop.last_inventory_export_date,sale_shop.pricelist_id,sale_shop.project_id,sale_shop.root_category_id,sale_shop.payment_default_id,sale_shop.id FROM "sale_shop" WHERE sale_shop.id IN (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19) ORDER BY id
  Traceback (most recent call last):
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 131, 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

  
  2011-03-09 16:53:23,555][new_new_erp] ERROR:netsvc.agent:Job call of self.pool.get('sale.shop').run_import_orders_scheduler(cr, uid, *()) failed
  Traceback (most recent call last):
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/base/ir/ir_cron.py", line 94, in _callback
      f(cr, uid, *args)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/magentoerpconnect/sale.py", line 256, in run_import_orders_scheduler
      self._sale_shop(cr, uid, self.import_orders, context=context)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/magentoerpconnect/sale.py", line 248, in _sale_shop
      callback(cr, uid, ids, context=context)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/base_sale_multichannels/sale.py", line 177, in import_orders
      context['conn_obj'] = self.external_connection(cr, uid, shop.referential_id)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/magentoerpconnect/magerp_osv.py", line 84, in external_connection
      attr_conn = Connection(referential.location, referential.apiusername, referential.apipass, DEBUG)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/magentoerpconnect/magerp_osv.py", line 14, in __init__
      if not location[-1] == '/':
  TypeError: 'NoneType' object is unsubscriptable

  
  I said me that column sale_shop.sale_journal  doesn't existe but it's very strange cause base_sale_multichannels is installed my server.

  Do you know why ?