upgrade.php freezes (>1.1b3)

[Armada]

I'm trying to upgrade our forum (from 1.0.5 to 1.1b3) - but when it just gets stuck - pressing the "continue" button does nothing.

Upgrading...
Updating Settings.php... Successful.
Creating new tables and inserting default data... Incomplete.
Not quite done yet!
This upgrade has been paused to avoid overloading your server. Don't worry, nothing's wrong - simply click the continue button below to keep going.

Any ideas anyone?

[[Unknown]]

How long did you let it continue?  Are you sure it wasn't just taking a very long time?

You should wait at least 300 seconds before clicking "continue".

-[Unknown]

[[Unknown]]

Can you upload this file in the same directory as upgrade.php, please?

-[Unknown]

[Armada]

I've waited all night and now clicked the continue button - no joy.

Some bits out of my phpinfo:
(hey, [unknown] - phpinfo.php is in the root of the url I sent you)


PHP Version 4.3.2
max_execution_time   3600   3600
max_input_time   3600   3600


I upped these two values hoping it would help. 

Thanks,
Trystan

[[Unknown]]

I'm running the upgrader right now.  It's currently at:

Converting attachments, topics, and messages...
    Updating columns on "messages" (part 3)... done.
Incomplete.

Edit: at part 4 now.

Which means it's about one third through the longest of the modifications.  These modifications are being run only to make sure everything is okay for the 1.1 upgrade - after you get to 1.1, future updates will never have to do these again... so you won't have to deal with this more than just once.

-[Unknown]

[[Unknown]]

There you go - upgrade complete.

-[Unknown]

[Armada]

Ok - I've installed status.php there too now 

[Armada]

Blimey! You're the best!

Thank you     

So what was the problem?

Trystan

[[Unknown]]

Nothing, I just sat and waited.  Nice load averages, by the way .

-[Unknown]

[Armada]

Hmm, ok - well that's good.   

I'll need to do the upgrade again when I "go live" (the current test is the database a few days ago).  I wonder what's up with my machine in my office then - it's running Firefox on Ubuntu (Linux)?

[[Unknown]]

Well, it should be fine... it's got good ram and a nice cpu.  It's just that it takes a long time to modify the messages table.  If you want, I can give you an upgrade_1-0.sql which will take much less time (and be fine for your database) - most of the things it does are "just in case" as I said above.

-[Unknown]

[Armada]

Hiya [unknown],

Sorry for my slow reply!

Yes, I'd be very grateful for a upgrade_1-0.sql (and some instruction on how to use it please    )

- I tested a trial-run upgrade again last night, but it didn't work (tried it on a WinXP machine too).

Thanks ever so much again!
Trystan

[aerkins]

I have a similar problem - it gets as far as

'Converting attachments, topics, and messages...
    Updating columns on "messages" (part 4)... done.
Incomplete.'

and then sits there chugging away before giving me a 'page cannot be displayed'

[[Unknown]]

Sorry, I lost this topic.  Just remove these lines from the file:

Code Select Expand

---# Updating columns on "messages" (part 1)...
ALTER TABLE {$db_prefix}messages
DROP PRIMARY KEY,
CHANGE COLUMN ID_MSG ID_MSG int(10) unsigned NOT NULL auto_increment PRIMARY KEY;
---#

---# Updating columns on "messages" (part 2)...
ALTER TABLE {$db_prefix}messages
CHANGE COLUMN ID_TOPIC ID_TOPIC mediumint(8) unsigned NOT NULL default '0';
ALTER TABLE {$db_prefix}messages
CHANGE COLUMN smiliesEnabled smileysEnabled tinyint(4) NOT NULL default '1';
---#

---# Updating columns on "messages" (part 3)...
ALTER TABLE {$db_prefix}messages
CHANGE COLUMN posterTime posterTime int(10) unsigned NOT NULL default '0',
CHANGE COLUMN modifiedTime modifiedTime int(10) unsigned NOT NULL default '0';

ALTER TABLE {$db_prefix}messages
ADD INDEX participation (ID_MEMBER, ID_TOPIC);
ALTER TABLE {$db_prefix}messages
ADD INDEX ipIndex (posterIP(15), ID_TOPIC);
---#

---# Updating columns on "messages" (part 4)...
ALTER TABLE {$db_prefix}messages
CHANGE COLUMN ID_MEMBER ID_MEMBER mediumint(8) unsigned NOT NULL default '0',
CHANGE COLUMN icon icon varchar(16) NOT NULL default 'xx';

ALTER TABLE {$db_prefix}messages
ADD INDEX ID_MEMBER (ID_MEMBER);
ALTER TABLE {$db_prefix}messages
ADD UNIQUE INDEX topic (ID_TOPIC, ID_MSG);
---#

-[Unknown]