I'm trying to upgrade my magento 1.3.2.4 database to 1.4.0.1 by using "Magento database repair tool", but it's not working. When I enter the details launch the script it takes ages and still nothing happens (once I waited about and hour) and I have a decent server (dual Xeons, 16 GB RAM, 2xSAS RAID).
When I get fed up waiting and refresh the page, or launch the script from the beginning, it gives me this error message:
Error #1005: Can't create table 'temp.#sql-b4a_26b' (errno: 150) on SQL:
ALTER TABLE `magento_wishlist_item`
ADD CONSTRAINT `FK_WISHLIST_ITEM_STORE`
FOREIGN KEY (`store_id`)
REFERENCES `magento_core_store` (`store_id`)
ON DELETE SET NULL
ON UPDATE CASCADE
Is there a way to solve this?
You are doing it slightly wrong as repair tool is not meant for upgrading but repairing existing state
for a successful upgrade do as follows: