Hi,
I have installed the Magento OpenERP connector on the following system
Ubuntu
Magento 16.1.
OpenERP 6.1
It is working great on products etc but when I go to import orders or partners I get the following error:
Server Traceback (most recent call last):
File "/opt/openerp/server/openerp/addons/web/common/http.py", line 592, in send
result = openerp.netsvc.dispatch_rpc(service_name, method, args)
File "/opt/openerp/server/openerp/netsvc.py", line 360, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File "/opt/openerp/server/openerp/service/web_services.py", line 572, in dispatch
res = fn(db, uid, *params)
File "/opt/openerp/server/openerp/osv/osv.py", line 167, in execute_kw
return self.execute(db, uid, obj, method, *args, **kw or {})
File "/opt/openerp/server/openerp/osv/osv.py", line 121, in wrapper
return f(self, dbname, *args, **kwargs)
File "/opt/openerp/server/openerp/osv/osv.py", line 176, in execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/opt/openerp/server/openerp/osv/osv.py", line 164, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/opt/openerp/server/openerp/addons/base_sale_multichannels/sale.py", line 280, in import_orders
self.import_shop_orders(cr, uid, shop, defaults, context)
File "/opt/openerp/server/openerp/addons/magentoerpconnect/sale.py", line 154, in import_shop_orders
context=ctx)
File "/opt/openerp/server/openerp/addons/magentoerpconnect/sale.py", line 743, in mage_import_base
result = self.mage_import_one_by_one(cr, uid, conn, external_referential_id, mapping_id[0], order_ids_filtred, defaults, context)
File "/opt/openerp/server/openerp/addons/magentoerpconnect/magerp_osv.py", line 279, in mage_import_one_by_one
rec_result = self.ext_import(cr, uid, rec_data, external_referential_id, defaults, context)
File "/opt/openerp/server/openerp/addons/magentoerpconnect/sale.py", line 690, in ext_import
res = super(sale_order, self).ext_import(order_cr, uid, data, external_referential_id, defaults=defaults, context=context)
File "/opt/openerp/server/openerp/addons/base_external_referentials/external_osv.py", line 366, 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/openerp/addons/magentoerpconnect/sale.py", line 584, in oevals_from_extdata
defaults = self.get_order_addresses(cr, uid, defaults, external_referential_id, data_record, key_field, mapping_lines, defaults, context)
File "/opt/openerp/server/openerp/addons/magentoerpconnect/sale.py", line 316, in get_order_addresses
res['partner_id'] = self.pool.get('res.partner').extid_to_oeid(cr, uid, data_record['customer_id'], external_referential_id)
File "/opt/openerp/server/openerp/addons/base_external_referentials/external_osv.py", line 193, in extid_to_oeid
result = self.get_external_data(cr, uid, conn , external_referential_id, {}, {'id':id})
File "/opt/openerp/server/openerp/addons/magentoerpconnect/magerp_osv.py", line 287, in get_external_data
return self.mage_import_base(cr, uid, conn, external_referential_id, defaults, context)#TODO refactor mage_import_base calls to this interface
File "/opt/openerp/server/openerp/addons/magentoerpconnect/magerp_osv.py", line 255, in mage_import_base
result = self.ext_import(cr, uid, data, external_referential_id, defaults, context)
File "/opt/openerp/server/openerp/addons/base_external_referentials/external_osv.py", line 383, in ext_import
existing_rec_id = self.oe_create(cr, uid, vals, each_row, external_referential_id, defaults, context=context)
File "/opt/openerp/server/openerp/addons/base_external_referentials/external_osv.py", line 415, in oe_create
return self.create(cr, uid, vals, context)
File "/opt/openerp/server/openerp/osv/orm.py", line 4154, in create
cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
File "/opt/openerp/server/openerp/sql_db.py", line 152, in wrapper
return f(self, *args, **kwargs)
File "/opt/openerp/server/openerp/sql_db.py", line 212, in execute
res = self._obj.execute(query, params)
DataError: date/time field value out of range: "0000-00-00 00:00:00"
LINE 1: ...34',E'UK',E'True',E'Test Test',E'True',2,E'False',E'0000-00-...
Has anyone else had this problem? if so what was the solution?
Thanks
Tony
Hello,
Which branch are you using?
Do you still see this bug?