5.2 Upgrade Problem

Steve_C · September 30th, 2005, 09:49 AM

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.

Michael P · September 30th, 2005, 10:02 AM

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

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

Steve_C · September 30th, 2005, 10:12 AM

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...

Michael P · September 30th, 2005, 10:35 AM

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

Steve_C · September 30th, 2005, 10:45 AM

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

Michael P · September 30th, 2005, 10:50 AM

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

Michael P · September 30th, 2005, 01:23 PM

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?

Code:

Content visible to verified customers only.

Steve_C · September 30th, 2005, 01:36 PM

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

Michael P · September 30th, 2005, 01:40 PM

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

Steve_C · September 30th, 2005, 01:46 PM

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

Michael P · September 30th, 2005, 01:51 PM

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.

Steve_C · September 30th, 2005, 02:09 PM

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.

Steve_C · September 30th, 2005, 02:19 PM

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

Michael P · September 30th, 2005, 02:46 PM

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

Steve_C · October 1st, 2005, 03:03 PM

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.

Chuck S · October 1st, 2005, 03:06 PM

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

Steve_C · October 1st, 2005, 06:03 PM

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.

Chuck S · October 1st, 2005, 07:32 PM

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