no, that didn't fix it. Still getting same error:
[2010-11-24 20:04:55,906][splattest1] ERROR:db.cursor:bad query: insert into
"product_template"
(id,"supply_method","list_price","description","weight_net","standard_price","mes_type","uom_id","description_sale","cost_method","categ_id","name","uos_coeff","sale_delay","procure_method","sale_ok","purchase_ok","company_id","produce_delay","uom_po_id","rental","type",create_uid,create_date)
values (5,E'buy',E'12.95',E'Ahoy there me hearties, do me bidding or I''ll run
ya through wi'' my cutlass - sorry getting a bit carried away, maybe I
shoudn''t watch Pirates of the Caribbean so often! Anyway, this is a fab sword
with a cut out bit for the handle, great with our skull and cross bones and
parrot cutter. Lovely big copper cutter 10cm x
17.5cm',0.1,E'0.00',E'fixed',1,E'Ahoy there me hearties. Lovely big copper
cutter 10cm x 17.5cm',E'standard',NULL,E'Pirate Sword or Cutlass Big Copper
Cookie
Cutter',1.0,7.0,E'make_to_stock',E'True',E'True',1,1.0,1,E'False',E'consu',1,now())
Traceback (most recent call last):
File
"/opt/local/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/openerp-server/sql_db.py",
line 122, in execute
res = self._obj.execute(query, params)
IntegrityError: null value in column "categ_id" violates not-null constraint
MODEL 29 38 categ_id
The product details downloads ok, it seems to choke on adding the
product into OpenERP itself.
I've checked the database, all products have at least one category, and
the category ids are being downloaded. Any ideas?
--
Product Import fails
https://bugs.launchpad.net/bugs/617905
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
Status in Magento Open ERP Connector: Invalid
Bug description:
I'm using current stable (5.0.12) on an Amazon EC2 ubuntu 10.4 instance. I have
installed and configured the openerpconnect module ok and the corresponding
magento module.
In OpenERP, clicking on the referential actions in turn (1 - Import Customer
Groups through to 5 - Import Product Attributes) works fine but when I click on
6 - Import products I get the following error. We have approx 2000 products, is
this a timeout problem, or something else?
Traceback (most recent call last):
File "/usr/local/lib/python2.6/dist-packages/openerp-server/netsvc.py", line
247, in dispatch
result = LocalService(service_name)(method, *params)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/netsvc.py", line
76, in __call__
return getattr(self, method)(*params)
File
"/usr/local/lib/python2.6/dist-packages/openerp-server/service/web_services.py",
line 577, in execute
res = service.execute(db, uid, object, method, *args)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line
58, in wrapper
return f(self, dbname, *args, **kwargs)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line
119, in execute
res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line
111, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File
"/usr/local/lib/python2.6/dist-packages/openerp-server/addons/magentoerpconnect/magerp_core.py",
line 137, in sync_products
list_prods = attr_conn.call('catalog_product.list')
File
"/usr/local/lib/python2.6/dist-packages/openerp-server/addons/magentoerpconnect/magerp_osv.py",
line 53, in call
res = self.ser.call(self.session, method, arguments)
File "/usr/lib/python2.6/xmlrpclib.py", line 1199, in __call__
return self.__send(self.__name, args)
File "/usr/lib/python2.6/xmlrpclib.py", line 1489, in __request
verbose=self.__verbose
File "/usr/lib/python2.6/xmlrpclib.py", line 1253, in request
return self._parse_response(h.getfile(), sock)
File "/usr/lib/python2.6/xmlrpclib.py", line 1392, in _parse_response
return u.close()
File "/usr/lib/python2.6/xmlrpclib.py", line 836, in close
raise ResponseError()
ResponseError: ResponseError()
_______________________________________________
Mailing list: https://launchpad.net/~c2c-oerpscenario
Post to : [email protected]
Unsubscribe : https://launchpad.net/~c2c-oerpscenario
More help : https://help.launchpad.net/ListHelp
