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 ?
I'm on Magento 1.4 and openerp 6