5.2 Upgrade Problem
 

I was running 5.14 and ran the upgrade.php file and got this:

http://xxxxxxxxxxxxxxxx.com/upgrade....ade=511&step=1

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Can you check your database and see if the cache table was created?

(Please don't cross post, it's unnecessary)

Yes, it's created.

I didn't know which section to put it in so I was going to delete this one and keep the other but you got here before I did...

Okay, so appears that the first part was done; does the cache table have data in it (is there code in the record #1)?

It's all "Null". I can give you login info if that'll help.

Sure, PM me your admin and ftp info and I'll check it out.

The problem appears to be related to the building of the cache. I wonder what saving this to a php file and then running this script would to - would it build the cache for us?

You're the developer... you tell me.... shouldn't this have been tested prior to being released?

If you don't want my help, don't ask for it.

If you don't want 17 licenses and the 10 more or so we plan on getting soon, don't treat me with disrespect.

Works both ways, Steve; works both ways.

We also updated the upgrade.php script yesterday afternoon, if you don't have the latest copy you might want to try it.

I did not disrespect you...

I tried the code and get the same error. I'll just send you the server login and hope for the best.

Thank you for your support.

I downloaded that build last night about 2:00 am EST.

The problem is that because of your "supersized" category structure your "max_allow_packet" setting of 1mb is insufficent to save the category caching data (your max_allowed_packet is set to 1mb and we are just a couple kb over that; a setting of 2mb should suffice to get past this issue).

On my systems, in my.cnf, I have:

max_allowed_packet = 16M

Unfortunately it's not that easy with an Ensim server. Please provide the process needed as with Ensim, you cannot just change the setting and restart MySQL.

You may need to have your host assist with this.

The above change Michael notes should work but you would need access to edit the my.cnf file and be able to restart the mysql

We have dedicated servers and our Network Engineer cannot get it to work. We make the change, MySQL will not restart. He says an server with Ensim is not as forgiving as others when it comes to those changes.

Okay well your host would probally be able to assist you. The issue is as Michael states

"max_allow_packet" setting of 1mb is insufficent

Thus you need to increase this to allow the cache data to be written