Error on Magento database 301 bulk update

[sedamiran]

Hi all,

One of my client has a magento website and I recently received received 404 errors for about 600 links on GWT and I tried to give 301 redirection via bulk upload but i get errors.

It's magento 1.7 and I have following columns on csv file. I included first sample row as well.

<colgroup><col width="120"><col width="71"><col width="120"><col width="402"><col width="253"><col width="120"><col width="120"><col width="120"><col width="120"><col width="120"></colgroup>
| url_rewrite_id | store_id | id_path | request_path | target_path | is_system | options | description | category_id | product_id |
| 125463 | 1 | 22342342_54335 | old_link | new_link | 0 | RP | NULL | NULL | NULL |

|   |   |   |   |   |   |   |   |   |   |

The error msg I receive is below. I was wondering if anyone has tried this before and if you know you how to fix this. Manual redirection works fine but probably this first 600 error is just a start, I'll be getting more 404 errors soon, somehow i need to figure out how to fix this. I appreciate if any one has experience on this and guide me through.

Thanks in advance,

Here is the error:

SQL query:

INSERT INTO 'mgn_core_url_rewrite'
VALUES (

'url_rewrite_id', 'store_id', 'id_path', 'request_path', 'target_path', 'is_system', 'options', 'description', 'category_id', 'product_id'

)MySQL said:

#1452 - Cannot add or update a child row: a foreign key constraint fails ('ayb_mgn2'.'mgn_core_url_rewrite', CONSTRAINT 'FK_101C92B9EEB71CACE176D24D46653EBA' FOREIGN KEY ('category_id') REFERENCES 'mgn_catalog_category_entity' ('entity_id') ON DELETE CASCADE ON)

<colgroup><col width="120"><col width="71"><col width="120"><col width="402"><col width="253"><col width="120"><col width="120"><col width="120"><col width="120"><col width="120"></colgroup>
|   |   |   |   |   |   |   |   |   |   |

[sedamiran]

I didn't think there would be an extension for this but i just found one and it worked perfect for 301 redirection.

http://www.magentocommerce.com/magento-connect/optimise-web-mass-301-redirects-1589.html

In case anyone is interested:)