Upgrade Failure - 500 internal server error everywhere

[madmartian]

So, I managed to get the upgrade to complete. It had one warning but was otherwise successful:

SQL 1.7.6.2 1146 in INSERT INTO `ps_info_lang` SELECT `entity`.`id_info`, 1, `entity`.`id_lang`, `entity`.`text` FROM `ps_info_lang` entity LEFT JOIN `ps_info_lang` entity2 ON `entity2`.`id_shop` = 1 AND `entity`.`id_info` = `entity2`.`id_info` WHERE `entity2`.`id_shop` IS NULL: Table 'prestashopdb1.ps_info_lang' doesn't exist

I can log into the back office just fine. The catalog works. However going to the webpage fails with error 500. I was going to try disabling modules, but trying to go to the module manager results in error 500.

I tried turning friendly URLs off - save - on - save, but that did not help.

Did that DB warning cause this error? Is there a way to fix it? Or am I just wasting my time expecting a prestashop upgrade to work?

 

[madmartian]

Seriously? I get zero help on this?!

[razaro]

Have you tried to turn debug mode on 

on those page you get 500 errors ? There could be some error showing that could  give more details on what is wrong.

Also you could try and check error log on your hosting side.

That error is from module Custom text so after you manage to get to module page you could reinstall module. Should not be a main problem.

You did not mention from what version you upgraded from and how did you upgrade. With native module or some 3rd party one.

If you are maybe upgraded from 1.6 there could be several issues.

 

But try to enable debug mode, if some error appears in connection with some module you can try to just rename main module folder temporarly.

Also do clear PrestaShop cache if you can access page with no issues.

 

[madmartian]

I tried to upgrade from 1.6.1.20 to 1.7.6.x (whatever was current and stable). It went badly with 500 errors everywhere. I reverted to 1.6.1.20. Since then I tried going from 1.6.1.20 to 1.6.1.24. You'd think that would work. Nope. Mostly worked, but category pages all got the 500 error.

It amazes me how bad PrestaShop is at updates. Every "1-click-upgrade" I've done has cost me many hours of troubleshooting to get working and the problem is something different each time. How much time should I devote to trying to get this to work when it could actually take less time to move my data to a new cart that doesn't have constant update issues? I will try using debug before I give up. Thanks for the tip.

[Rhobur]

Another tip: before any upgrade, just disable all third party modules you have and the overrides.

I suppose you know that 1.6 to 1.7 upgrades just the DB, the official modules and the PS files; not the theme or the other modules which are not compatible anymore.

[madmartian]

9 hours ago, Rhobur said:

Another tip: before any upgrade, just disable all third party modules you have and the overrides.

I suppose you know that 1.6 to 1.7 upgrades just the DB, the official modules and the PS files; not the theme or the other modules which are not compatible anymore.

I am using the default theme and no 3rd-party modules - the most basic store you can have. The system wouldn't even let me get to the module screen - error 500. "1-click upgrade" is a kludge that never works the first time.

[Rhobur]

what are the errors when setting Debug on?