Magento 1.6 Upgrade Errors with Solutions

Jan 12

Magento 1.6 Upgrade Errors with Solutions

Magento 1.6 Upgrade Errors with Solutions


After upgrading to Magento 1.6, You may face some problems like Integrity constraint violation: 1062 Duplicate entry or Error 404 after installation(while home page is OK).

1- “Integrity constraint violation: 1062 Duplicate entry “
Solution:
This error can be solved by disabling the unique indexes check.

In the app/etc/config.xml, change this

SET NAMES utf8

to this

SET NAMES utf8; SET FOREIGN_KEY_CHECKS=0; SET UNIQUE_CHECKS=0;

2. Error 404 after installation(while home page is OK)

Solution:
You will need to do one of two things:
-Refresh catalog rewrites – Admin > System > Cache > Refresh catalog rewrites. If this doesn’t work then >
-Turn off URL Rewrites – Admin > System > Web > SEO > NO

3. 500 internal error after upgraded

Solution:

CHMOD 755 the following:

- magento/index.php
- magento/downloader/
- magento/js/*

Login to Magento and clear your cache

Source: http://www.expertmagentodevelopers.com/blog/magento-1-6-upgrade-errors-with-solutions/

468 ad

7 comments

  1. Great Post
    It helped me and saved my time

    Thanks

  2. Thanks for posting

  3. Brett /

    This fix seems applicable after an upgrade when the home page is OK. Any ideas on how to work around the issue of duplicate entries causing the upgrade to fail? I’ve tried this fix and it doesn’t seem to make any difference.

  4. Meet2teju /

    Hi,

    I have to change in config.xml in

    SET NAMES utf8
    to
    SET NAMES utf8; SET FOREIGN_KEY_CHECKS=0; SET UNIQUE_CHECKS=0;

    But error will display in magneto 1.3.2.1

    Error:-SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ’4′ for key 2

    How to Solved this Error

    Plz Help Me.

    Thanks.

  5. Neetesh Vishwakarma /

    thanks its really help me

  6. Might work in the short term, but disabling foreign key checks can cause major issues down the road. There should be a better solution for that problem…

  7. thanks, a great help.. it works

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>