c2c-oerpscenario team mailing list archive

[Kyle Waid <688225@xxxxxxxxxxxxxxxxxx>]

Im not sure why, But I keep getting this error

ProgrammingError: column "categ_id" is of type integer but expression is of type boolean
LINE 1: ...product_categ_rel (product_id,categ_id) values (2267, false)

Im assuming this means there is a null value in category_ids.

At first when I looked at the database there was a null in category_ids
so I put a category in there. It got to the next one and did the same
thing even though both products were assigned to the same category. I
changed nothing and ran it again then it got to the next product. Same
thing. Also there were several, mabe even 100 products before that one
that also did not have a category assigned but it didnt give me a
problem like this. Its quite strange.

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

Title:
  Importing products skip if catalog_product_entity = sku crisscross

Status in Magento Open ERP Connector:
  Confirmed

Bug description:
  When we were importing our orders about 500 of our products would not import. We couldnt figure out why. We downloaded what we could and dumped it to a log file

We discovered that when magento was returning the products OpenERP would not add the product to the database if the catalog_entity matched the sku. We are not sure why it happens

Is there any way to fix this?