Hello to all..
I am writing here because I need some help.. Please :(
I have a client who has a magento 1.4 website.
The website has more than 5K items, 7K customers and almost 2K orders that includes test orders.
The live/current website is fully customized from the front page to product pages.
The client wanted to upgrade the site to 220.127.116.11 and so here are the things I did.
First, I have copied the dump SQL from phpmyadmin and uploaded it to my own hosting account.
By the way, I have a VPS so I can simply do whatever I want there.
Then I have registered a .tk domain for the test site.
After importing the 4GB dump SQL, I have downloaded the archive 18.104.22.168 magento installation and have installed it for the test.
I have upgraded the site through shell from 22.214.171.124 to 1.4.2 as I cannot upgrade directly to 1.7 due to database structure changes.
Then after the successful upgrade to 126.96.36.199, I logged in to the admin area and checked is everything is ok.
It seemed that it was good. Everything was fine so I can go ahead and upgrade to 1.7.
So I logged in to the downloader (http://www.domain/downloader) and upgraded everything.
Check for updates > Commit changes
After upgrade, I changed file permissions as I was not able to visit the site after.
After the successful upgrade, everything seem to be ok except for these problems.
1.) I cannot reindex Product Prices for some reason, it just doesn’t reindex. I don’t know any turn around for this but I know I need to reindex it.
2.) The site always gets a 504 gateway error and the log says, “SQL has gone away”.
Basically I know what 504 means however I tried maximizing the packet and timeout on php.ini but I still get the same thing. I cannot visit the site anymore. I can visit the admin and the downloader page but not the site frontend.
These are just two problems I have encountered.. Just these…
Please help me. If more info is needed, I’d be more than happy to add it here..