c2c-oerpscenario team mailing list archive

[Raphaël Valyi - http://www.akretion.com <688225@xxxxxxxxxxxxxxxxxx>]

May be something like your Magento product belongs to a category that you
have deleted on Magento? Could you check?
Magento enforces nearly 0 data integrity control, in Magento you can delete
a category a product belongs to or delete a product that belongs to some
orders and we cannot do much about it (just import the record and flag it
properly for manual correction later), as when we ask Magento for the linked
resource it simply says it doesn't exist (we cannot put guards everywhere).
Could you ensure it's not such a case (an easy way to check is to do XML/RPC
request in a Python console using xmlrpclib).

On Sun, Dec 12, 2010 at 7:00 AM, Kyle Waid
<688225@xxxxxxxxxxxxxxxxxx>wrote:

> 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 subscribed to Magento
> Open ERP Connector.
> 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?
>
>
>

-- 
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?