Upgrade script timing out?

[Grudge]

All,

A few users have been trouble with the upgrade script failing when they attempt to upgrade. There are two different reasons for this, both of which can be fixed easily.

Firstly, for some people, upgrade is failing as soon as they hit continue. This is because the timeout protection in upgrade.php is set too high for their server. To fix this, open up upgrade.php in any text application, and at the top where it says:

Code Select Expand


$timeLimitThreshold = 10;


Change it to a lower amount, such as 3. (This is the time in seconds before the script pauses)

Secondly, some users with *huge* forums may be having trouble with the script timing out on the "MySQL STRICT compatibility" section. Although we will endevour to fix this in 1.1 Final, if this happens the easiest way to continue upgrade is to change the URL to point at the next step in the upgrade process. So, if upgrade.php fails when doing the STRICT changes, simply look at the URL bar in your browser, somewhere in it you will have:

Code Select Expand


strict_step=#

Where # is a number. Simply increase this number by one, and reload the page from there, this will move it on to the next item.

Regards,

Simple Machines

[kursat]

but i have diffrent problem. i upgrade my forum from 1.07 to 1.1rc2 but after i put the files in to ftp i got a database problem. i cant sing with my password and user name. my site is www.aslanclub.com/forum can you help me how can i solve this

[gamesmad]

You will need to run "upgrade.php".

Will

[Zenigata]

Although we will endevour to fix this in 1.1 Final[...]

Is this problem fixed in 1.1 RC3?

Thanks

[H]

! Try do a better job of protecting against upgrade timeouts for index changes. (upgrade_1-1.sql)

Yes(, if the entry I have quoted is the correct issue!)

[Overseer]

Although we will endevour to fix this in 1.1 Final[...]

Is this problem fixed in 1.1 RC3?

Thanks

nope

[projectwinback]

I am currently not having this problem, reset your server?

[gamesmad]

This issue only affects some servers.

Will

[LaurieC]

I don't see where it says secure_step=#;

This is what I have:

http://mydomain/forum/upgrade.php?step=2;maint=1;debug=1;substep=113;s=1;bdi=412

[sledgeweb]

Trying to update from RC2 to RC3. I'm stuck here: upgrade.php?step=2;maint=1;substep=40;s=1

I've been trying to get through this for 7 hours now, this is ridiculous. This whole upgrade process needs to be replaced with something that works.

First, I was getting the regular progress bar screens. Then it started prompting me to open the file in dreamweaver (using FireFox - just server error page in IE). Kept canceling that and refreshing. That locked the server up after a while (gave me a 500 message). Now, try to refresh (server is back up), and I get the firefox dialogue asking me to open the file again. This is so frustrating... I was really hesitant to update, because I was worried something like this would happen, so I waited a bit, but, those warning about the security whole in RC2 made me decide to go ahead and upgrade. I wish I hadn't... seems like the biggest flaw is in the upgrade script itself.

And neither of the two solutions here work for me.

[gamesmad]

I will have a go at upgrading for you if you like, PM me your cPanel details.  Do you have a backup?

Will

[sledgeweb]

Yes, I have a backup, and just restored everything to RC2. What would you do differently to get the upgrade to work? Or, what would you need to do in CPANEL?

After about 20 hours of trying, I gave up. I had to use shell access to restore my database because it was too large for PHPMyAdmin. I had backed up all the files that RC3 overwrites, so, I put all the RC2 files back in place - so, I'm back to where I was before I attempted the upgrade. I'd really like to get updated to RC3, but I don't want to go through another 20 hours of hades to do it.

[LaurieC]

I'm in the same exact boat as you to include having to use shell to restore the database because it was too large for PHPMyAdmin. I am interested in any advice on upgrading, please share 

[sledgeweb]

Sorry lace, I haven't had any luck. I'm not exactly sure how to get any support help on this, I've posted my problem to a couple places here, but haven't had anyone provide a working solution. It's been a few days now, and as far as I can tell, if you have a large forum, you are pretty much screwed when it comes to updating to RC3, and there doesn't seem to be any support working to provide a solution. If you figure something out, let me know, and I'll do the same for you.

[mrclean]

I am having the same issue and now that the upgrade script keeps stalling I can't even see my website. I just get this: Don't worry, we will be back shortly with an updated forum. It will only be a minute .

I see this throughout my entire joomla site, so I'm guessing that I need a server reboot. I had to upgrade after my forums got the hell hacked out of them and was redirecting people to a virus-ridden paradise.

Come on guys, if your going to make us upgrade please make it work!

[LaurieC]

I tried upgrading several times and it locks up so hard that my whole server goes down. If there is anyone that knows what to do to get this to work I would greatly appreciate the help. I have tried the suggestions listed in this thread and none of them seem to work.

[mohawktj]

Im having the same problem, just tried to upgrade to rc3 from 1.0.8 and now Im getting a "we are upgrading" screen, and cant do anything.

[Pure80s]

Having similar problem to sledgeweb where it started prompting me to open the update file in dreamweaver Kept canceling and pressing continue, this is happening approx every 5Min's.

No error messages as yet. Is it upgrading or just locking out and I'm wasting my time keep pressing continue

[el-brujo]

wow, same problem.

upgrade.php?step=2;maint=1;substep=113;s=1;prep_lt=5;m=0


Current Step ("Preparing log table update") Progress:

11,11%

Code Select Expand

ALTER TABLE xxx_log_topics
ADD COLUMN ID_MSG int(10) unsigned NOT NULL default '0';

Upgrading 1.0.9 to 1.1 (550.000 topics).

¿How can i put a limit or something?

   select count(*) from `xxxx_log_topics`

Rows 7923174

Finally i change:

var countdown = 3;

for:

var countdown = 1;

[Pure80s]

Has anyone made any progress with the problems a few of us have experienced.

I have had this problem when trying to upgrade to all the RC, was hoping the final version would solve the problem.