Simple Machines Community Forum

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:

$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:

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

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 (http://www.aslanclub.com/forum) can you help me how can i solve this

You will need to run "upgrade.php".

Will

Quote from: Grudge on January 02, 2006, 06:02:11 AM
Although we will endevour to fix this in 1.1 Final[...]

Is this problem fixed in 1.1 RC3?

Thanks

Quote from: Changelog! 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!)

Quote from: Zenigata on August 23, 2006, 02:01:34 PM

Quote from: Grudge on January 02, 2006, 06:02:11 AM
Although we will endevour to fix this in 1.1 Final[...]

Is this problem fixed in 1.1 RC3?

Thanks

nope

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

This issue only affects some servers.

Will

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

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.

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

Will

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

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  :(

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.

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!

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.

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.

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

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%

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`

QuoteRows 7923174

Finally i change:

Quotevar countdown = 3;

for:

Quotevar countdown = 1;

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.

Stuck @ 93.29%.. tried restarting and increasing the #.. still no go. Any ideas?

yes very very slow. stuck at

  Upgrading...

probably 1 hour now.

<sigh>

Having serious problems trying to upgrade and any help would be greatly appreciated.

I am upgrading from 1.0.8 to 1.1 and have around 265,000 posts on the forum. The forum is running on a dedicated server so I can take as many cycles as necessary to get this done.

The problem occurs very quickly, when I run the update.php script within the first few steps I just get "Internet Explorer cannot display the webpage". I have no idea if the server is still updating or not (I presume I have to run and complete the update.php script in order to update the server).

I have tried adding one to the "substep=" number in the URL but that doesn't work.

I tried changing the "$timeLimitThreshold = 1;" but that doesn't work.

I tried running the script in Firefox and IE7, but I get the same timeout error.

I have run out of ideas here and I really need to get my forum back up and running soon. Remember, this entire forum is running on a dedicated server so I shouldn't have any timeout issues at all, and I will change the settings to whatever I need to get this done (like if I can do this entire update in one shot without having to continuously see "update" button every 3 seconds).

Please help me!!! :'(

Is there anything in the Apache error log?

Quote from: BeoR on December 09, 2006, 02:35:44 PM
Stuck @ 93.29%.. tried restarting and increasing the #.. still no go. Any ideas?

@BeoR restore your smf php and database from the backup, go enter your forum, go maintenance and "clear unimporant logs", "solve errors", etcetera. Then try to upgrade again. I've seen something similar.. a lot of trash in logfiles may cause the last steps to time out.

:)
Lx

Quote from: projectwinback on September 18, 2006, 07:51:19 PM
I am currently not having this problem, reset your server?

yeah,you have to try it to reset that!

Thanks

thanks

thanks

thanks

I have problem about this
Column 'logTime' cannot be null
line 2543
and they want to upgrade to 1.1.3
now I already use 1.1.3
So where is upgrade.php file, I can not found it.

It is in the upgrade and update packages in our download section.

This issue only affects some servers.

I can't solve this problem. Pleae help me.

idezmax: please start a new topic in Install and Upgrade Help (http://www.simplemachines.org/community/index.php?board=10.0)