Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email

Magento Forum

Upgrade from to - Table already exists exception
Jr. Member
Total Posts:  21
Joined:  2010-09-10

I tried to upgrade my Magento installation from to using every way I could imagine, but still running into the “table or view already exists” exception. So what is happening here?

My first view into the upgrade process shows me, that there is a table in Magento keeping track of the data and entity_version, called core_config_data. The system checks the entries here with the current version of the modules installed. No matter what you did, at one point Magento descides to upgrade your system with this mechanism.

If I looked into the upgrade files, for example app/code/core/Mage/Sales/sql/sales_setup/mysql4-upgrade- that ran into the problem, I regconized that there must be a mistake, maybe a bug. The script tries to create table that are still exists. This is not the only update script that runs into this problem.

Someone can hack it by replacing CREATE TABLE with CREATE TABLE IF NOT EXISTS, if the table structure would be the same.

I wonder why this error occurs.

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