Unable to upgrade 1.5.2.1 to 1.5.6.1

I've been having issues with our main website OC 1.5.2.1 causing slow loading times and page time out pages.
So I've made a second website in a sub directory and installed the same version of OC as I have on the main website, imported the database over and nothing else and the same is happening with the clean OC version. So I tried to upgrade to the latest 1.5.6.1 version and I go onto the install page and click continue and I get the same time out error as before. The page does not load and I have tried it a number of times.

"The connection to the server was reset while the page was loading."

Or I get this: Help!

I tried using 1.5.5.1 to update and the same thing again. A timeout so I can't upgrade.

Also, this is what my hosting company sent me as error logs their end.

My error is

Notice: Error: Can't DROP 'product_id'; check that column/key exists
Error No: 1091
ALTER TABLE `order_product` DROP INDEX `product_id` in /home/reddrago/public_html/system/database/mysql.php on line 50

any help here?

MayfairFurniture wrote:I tried using 1.5.5.1 to update and the same thing again. A timeout so I can't upgrade.

Also, this is what my hosting company sent me as error logs their end.

Code: Select all

[Tue Mar 11 17:06:33 2014] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request function

I think you've hit a PHP limit with your web host. By default FastCGI processes exit after 500 requests. See if they can raise this for you.

rdvapors wrote:My error is

Notice: Error: Can't DROP 'product_id'; check that column/key exists
Error No: 1091
ALTER TABLE `order_product` DROP INDEX `product_id` in /home/reddrago/public_html/system/database/mysql.php on line 50

any help here?

This error is saying MySQL can't find the column product_id in the product table order_product in your database. Have you tried running this upgrade more than once, ie did it crash out half way through? That would explain why the upgrade script is crashing out, it's already partially run. You could add this column back into the table manually to overcome the issue (via phpMyAdmin).

See if you can get a full copy backup of your database (or even better, ask your web host to restore it to a time before you attempted the upgrade). Then run the script again, assuming you have addressed the original reason it crashed out.

HTH