Upgrading Went Great....until...

[cordigital]

Server Error - Timeout on Database.

 

Now I cannot get into the site admin area, the site has errors in index.php and nothing works.

 

Is there a way to manually upgrade the database to 1.5.3 as the rest of the files said they did great!

[cordigital]

Well, I found the manual and attempted to manually submit to the upgrade process. But, all I get at /install/upgrade/upgrade.php is a white screen. What the...?

[cordigital]

I am hoping that someone can help me tonight. It just does not seem logical that the database upgrades timing out are the only thing that went wrong and someone out there has not ran across this yet!

 

How do we manually upgrade the database?

 

Do we run 1.4.9.sql commands from the upgrade/sql folder in phpmyadmin?

 

Is there a script hidden somewhere to do the database upgrade?

 

Anyone?

[cordigital]

I don't think anyone replies to these things....

[bellini13]

look in the "install\upgrade\sql" folder

[cordigital]

There is a lot of sql in that folder, do I run the 1.4.9 through 1.5.3? Or all of them?

[cordigital]

The update always times out with SQL. I restore from backups and my back office is horrendous. It says "Tab file cannot be found" and has no structure.

 

The menus are just text and vertical. This whole thing has been a disaster. Site is down. I am thinking about leaving this stuff as there is no real support. These things should not happen. Especially when you follow the rules and restore. That should bring the site right back where it was...but it does not.

[railingm]

I ran in to the exact same issue when trying to go from 1.4.8.2 to 1.5.3, one click upgrade failed and timed-out during the database upgrade, and my backup failed... so.

 

1. I logged in to my host and pulled a recent SQL backup (luckily I did it right before everything) so that I had it "untouched" by Prestashop 1-click upgrade, and restored this database to the server.

2. I downloaded 1.4.10 and extracted it to my desktop.

3. I looked at the manual upgrade instructions for 1.4.10 for upgrade, which basically says to backup everything on the FTP site, delete it all from the server, then copy a few key files/folders from the backup to 1.4.10 folder (Themes, modules, config\settings.inc.php, and other customizations) , then copy files back to the server.

4. Once files are back on the server, I ran the "\install\" program on the web, and chose upgrade, and let it do it's thing.

5. It upgraded the site to 1.4.10 (we were on 1.4.8.2) and upgraded the database to 1.4.10.

6. Then I went through the site and almost all my modules were disabled, I had to re-enable them, and the hooks were wrong, so I had to go to the manage hooks page and remove the hooks (modules) from the incorrect sections, and in turn one at a time check to see that each module was in the correct location. Some of them I had issues with, so I deleted them from the system, used the 1.4.10 zip and extracted that module again, restoring the files to the server, choosing to install the module, and thus it put the hooks back in correctly for that module.

 

This got me back to where I was before. A pain in the rear, but at least I am back. I hope this helps you, and hopefully you had a backup of the database prior to the install, because although it said it didn't get to it, it actually did mess up a few of my tables, and I had to do the restore.