← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 784510] Re: Import order : null value violate constraint not-null of column « name »

 

Hello,

I have seen this bug. You see from the log it is citing a null value in
column "NAME". This indicates that the products imported with the sale
order do not have the name filled in. Look at your last imported order.
Either the very next one or one after you should see that in your
magento admin the order will show skus but no names for the products. It
is a magento bug. I have had this problem randomly. You can skip the
order with an increment_id: 'eq' statement.

-- 
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/784510

Title:
  Import order : null value violate constraint not-null of column « name
  »

Status in Magento Open ERP Connector:
  New

Bug description:
  Hello everybody,

  i get this error when i import order from magentoerpconnect :

  [2011-05-18 12:20:37,645][tng_concepts] ERROR:db.cursor:bad query: insert into "sale_order_line" (id,"product_uos_qty","product_id","product_uom","sequence","order_id","price_unit","product_uom_qty","name","delay","discount","state","product_packaging","layout_type","type","invoiced",create_uid,create_date) values (8,1.0,1,1,10,4,E'5.00',1.0,NULL,0.0,0.0,E'draft',NULL,E'article',E'make_to_stock',E'False',1,now())
  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)
  IntegrityError: ERREUR:  une valeur NULL viole la contrainte NOT NULL de la colonne « name »

  
  Did someone get the same, and could you give a fix please ?

  Openerp 6.0.2
  Magento : 1.5.1

  Magentoerpconnector : branch lp:~gbaconnier-
  c2c/magentoerpconnect/magentoerpconnectv6-c2c

  thanks for help.

  Regards,


Follow ups

References