Magento Forum

   
Magento Catalog Rewrite Integrity violation
 
Julio Vedovatto
Member
 
Total Posts:  33
Joined:  2008-06-18
 

I’m using the latest version of Magento (1.4.0 CE), but when I go to create new product I got the following error: “Error saving URL Rewrite”. The product saves normally, but the relationship “category->product” wasn’t saved in the database.

After massive debug, I found the cause of the error, eg:

SQLSTATE[23000]Integrity constraint violation1062 Duplicate entry 'product/14-1-1' for key 3 234

So, I turned off the Catalog Rewrite (Manual Update) in Index Manegement, but every time I need rebuilt the indexes and for each product that I saved in system, magento throws this error.

What should be?

 
Magento Community Magento Community
Magento Community
Magento Community
 
kschaller
Jr. Member
 
Total Posts:  7
Joined:  2009-02-26
 

I’m having the same problem after upgrading from 1.3.2.4 to 1.4.1.0. Anyone out there have a solution?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Julio Vedovatto
Member
 
Total Posts:  33
Joined:  2008-06-18
 

I read that it is a problem in the database, try using OPTIMIZE.

I transferred the database to another host and apparently solved the problem.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Lu Xiao
Jr. Member
 
Avatar
Total Posts:  6
Joined:  2010-04-11
Manchester,NH
 

I ve updated to 1.4.1.0 for 3 days,and which amazing is the search full-text re-index finished,but the catalog index rewrites never finished, it is keep processing ......

Hope someone can give a solution, thanks very much!

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top