as the title above says i have updated our system from 1.5.1 to 1.7 via magento connect manager. everything seemed to have went smoothly at first. I’d like to present all the problems we have already ran into and post their solutions so we can collect somewhat of a lil wiki here.
1. firstly we ran into the “maintainance.flag” problem. if you update to 1.7 and cant go back to the admin panel and instead see the 503 error screen, log into your ftp and remove or rename the file “maintainance.flag” from your magento root directory.
2. the connection still kept timing out. we only could get the shop to answer sporadically every 20mins or so. to check if its a server problem simply try opening another site on your server for example yoururlhere.com/phpmyadmin or a .jpg or something. if that works, your shop has the issue. the problem here was that the file permissions were messed up. you can either google “magento cleanup” and use that tool or do it manually via ftp. once the permissions were set correctly, the shop seemed to be back up and running.
3. one of our plugis, specifically “m2e pro” quit working properly. it still imports ebay orders but does not create “magento orders” anymore. we have seen that m2e released a brand new update today which we installed. things started freakin out again and we had to start from step 1. lets hope this does not happen with every thing you install from now on but if it does, at least now u know what to do.
4. so after goin through step 1 and 2 over again and the now updated plugin still no success with creating orders. every time u try to manually make the system create a magento order from an ebay order it throws the errors:
Magento Order was not created. Reason: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘msql_name.salesrule_customer_group’ doesn’t exist Error 08.05.2012 15:03:32
Magento Order was not created. Reason: Invalid backend model specified: customer_entity/address_attribute_backend_street
we checked if the database was updated correctly and found out that the database did not update at all. we have researched a little bit and found quite a few people online that reported that they cant add products to the shopping cart. we tried doing so, same problem. it doesnt work. therefore we believe a lot of the reported problems can be tracked down to the database not being updated.
another problem that it leads to is not being able to reindex product prices. the indexer just throws the error that it cant be started. which, knowing that the database did not update, makes absolutly sense, since there are about 18 new colums that were added in 1.7 for price indexing and a complete new table. all other indexers work fine.
to see the database changes between the last version and 1.7 u can go to: http://www.magereverse.com/diff-version/magento-database-structure-comparison/version/188.8.131.52.beta
now all we need to know from someone who really does know is, how do we manually update the database. we have researched a lot about the database repair tool but we are not sure if that will work properly with 1.7. (http://www.magentocommerce.com/wiki/1_-_installation_and_configuration/db-repair-tool)
if anyone knows how to get this done, please let us know. we are not sure if we will keep 1.7 on our productive system since all of this, but if a database update solves the presented issues, it wouldnt be so bad after all. it def seems to be a lot faster than 1.5.1.