2

I tried to upgrade from 1.9.0 to 1.9.1 a long time ago. Unfortunatly there were some bugs in 1.9.1 which forced me to go back to 1.9.0. Today I tried to upgrade from 1.9.0 to 1.9.1.1 which failed (internal server error due to existing tables).

I think my mistake was that i didnt restore my database too, so now i already have these tables of 1.9.1, causing an error.

Is there any way to solve that issue? Or is there any way to get my data (or at least parts of it) into a new magento installation? Exporting and importing products, customers, etc using magento functions would be lots of work.

EDIT: here is the error message (first three lines)
a:5:{i:0;s:1064:"Error in file: "/var/www/vhosts/austrokamin.at/httpdocs/app/code/core/Mage/Core/sql/core_setup/upgrade-1.6.0.5-1.6.0.6.php" - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'core_email_queue' already exists, query was: CREATE TABLE core_email_queue (

Improve this question
2
  • Can you paste here the errors you are getting? My suggestion is to try to clean the new tables you didn’t roll back when you downgraded the version.
    – mbalparda
    Commented May 18, 2015 at 1:34
  • My idea is that there are a lot more existing tables, after the first error the installation is aborted. I have no idea which tables to delete.
    – Reinsch
    Commented May 18, 2015 at 7:43

1 Answer 1

Reset to default
1

The problem is that you have already made an attempt to upgrade once and left the old upgraded database. You original upgrade added or modified the tables so those "NEW" tables now exist and when you go to upgrade again Magento doesn't know they exist and it tries to create them.

You will need to walk through the upgrade and skip or modify the tables in question.

Improve this answer
2
  • 1
    Have you got an idea how to do this?
    – Reinsch
    Commented May 18, 2015 at 14:47
  • you can just remove core_email_queue and core_email_queue_recipients two tables and refresh your home page to take it work
    – Shiro
    Commented Nov 25, 2015 at 5:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.