Ok, I’ve been working on this upgrade literally all day to try and get it to work. I haven’t even touched the templates as of yet and I know there will be a lot of issues to sort out on those as it’s a fairly major upgrade. I just want to get the admin panel working and the Magento Connect working first on the latest issue so that I know I can actually upgrade.
Basically, our store is on 18.104.22.168, I created a duplicate along with a duplicate database and upgraded it initially to 22.214.171.124 so that I had a ‘fairly’ clean install that I could then upgrade in patches. I then managed to upgrade to 1.4.2 and hit a few problems around that point. I was getting conflict issues which looks like an issue many people have been having when upgrading to above 1.4.2.
I managed to get SSH access and force the upgrades and after battling with numerous errors (some files needed replacing, certain permissions, forcing updates and removing the_find plugin) I’ve managed to get everything showing as updated to 1.6.2.
I can connect to Magento Connect and I can see that literally everything is running on the latest version, however, I cannot access the admin or the frontend. It loads for about 5 or 10 minutes and then eventually, I get the following error:
Error in file: "/chroot/home/glowsti1/glowstickcity.co.uk/html/upgrade/app/code/core/Mage/Catalog/sql/catalog_setup/mysql4-upgrade-126.96.36.199-188.8.131.52.php" - Column "date" does not exists on table "catalog_product_index_website"
#0 /chroot/home/glowsti1/glowstickcity.co.uk/html/upgrade/app/code/core/Mage/Core/Model/Resource/Setup.php(645): Mage::exception('Mage_Core', 'Error in file: ...')
#1 /chroot/home/glowsti1/glowstickcity.co.uk/html/upgrade/app/code/core/Mage/Core/Model/Resource/Setup.php(437): Mage_Core_Model_Resource_Setup->_modifyResourceDb('upgrade', '184.108.40.206.44', '220.127.116.11.8')
#2 /chroot/home/glowsti1/glowstickcity.co.uk/html/upgrade/app/code/core/Mage/Core/Model/Resource/Setup.php(320): Mage_Core_Model_Resource_Setup->_upgradeResourceDb('18.104.22.168.44', '22.214.171.124.8')
#3 /chroot/home/glowsti1/glowstickcity.co.uk/html/upgrade/app/code/core/Mage/Core/Model/Resource/Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /chroot/home/glowsti1/glowstickcity.co.uk/html/upgrade/app/code/core/Mage/Core/Model/App.php(412): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /chroot/home/glowsti1/glowstickcity.co.uk/html/upgrade/app/code/core/Mage/Core/Model/App.php(338): Mage_Core_Model_App->_initModules()
#6 /chroot/home/glowsti1/glowstickcity.co.uk/html/upgrade/app/Mage.php(640): Mage_Core_Model_App->run(Array)
#7 /chroot/home/glowsti1/glowstickcity.co.uk/html/upgrade/index.php(80): Mage::run('', 'store')
I feel I’m extremely close to getting things working again (I may be completely wrong) but this looks to me like a database upgrade issue? Or maybe it’s a collection of files I need to reupload.
Any help would be absolutely fantastic. If I can get the latest version of magento running on this store, I believe it will help us a lot!