Internal server error on upgrade to 1.5

[annunakiwww]

Hi all,

 

I'm currently on 1.2.5, and use the "easy update" and/or "1-click upgrade" module to get up to 1.4.9. However, trying to go to 1.5.1/2/3 fails every time – manual update, automatic update, installatron update, ... Each time, after 180 seconds I get a 500 Internal Server Error. My hosting provider says it's due to the 128 MB memory limit. Could that be it? Would there be a way to solve the issue?

 

Many thanks in advance!

[bellini13]

Sounds like it could be any error really, memory issue, time out etc.. Did they review any type of error log to confirm that memory was the issue. Did they increase the memory to 256mb to allow you to proceed?

 

Also taking 180 seconds to perform the upgrade seems extremely excessive, how large is your store? What host are you using?

[annunakiwww]

Thanks for your reply!

- I don't know if they really reviewed a log, and they didn't increase the memory limit

- my store DB is 140MB, of which 70MB is comprised of ps_connections and ps_connections_source, but emptying those tables doesn't help

- my host is oxilion.nl

[bellini13]

i agree that truncating those tables would not have an effect on the upgrade. but still 70MB database size is still pretty large. what is the next largest table or two?

 

you should investigate increasing the memory limit and process execution time. Depending on the hosts restrictions, that is something you may be able to do by adding the entry in the .htaccess or the Prestashop config file.

 

if you cannot increase those, then you might have to duplicate the site on your local desktop, upgrade the site locally, and then upload the upgraded site to your host.

[annunakiwww]

Thanks again, I have

15MB on ps_order_detail (roughly 13.000 orders)

15MB on ps_cart_product (200.000 carts)

11MB on ps_cart

10MB on ps_guest

Are these normal sizes?

 

Anyway, upgrading from a clean 1.4.9 install to 1.5.3 did work, and I found some structural DB differences between my upgraded 1.4.9 install and the clean 1.4.9 install, so I'll eliminate them first and see if that works.

[bellini13]

you certainly have a larger store then I have upgraded previously. And going from v1.4.9 to v1.5.3.1 does include 1 major upgrade and 22 minor upgrades (v1.5.0.1, v1.5.0.2, v1.5.0.3 etc...).

 

Needless to say, that is a lot of database upgrade scripts to execute. I'm curious if you try to upgrade to v1.5.0 first, does it succeed?

[annunakiwww]

Well, I get from 1.2.5 to 1.4.9 in one leap, without problems (takes about 2 minutes I think), but from 1.4.9 to 1.5.0.1 does give the fatal error after 3 minutes. My hosting company increased the memory limit to 256MB, still the same result. I think there is something wrong with my DB, which apparently only causes problems on the 1.5.0 border. I'm trying to isolate that issue...

[annunakiwww]

I've tried about everything to get my DB as identical as I can with a clean 1.4.9 DB, except for the data of course, but still no success. I am able to access the 1.5.3 BO, but I lack 13 tables in mij DB. Frankly, I'm starting to become clueless. What can go wrong?