Upgrade hang....

[Bulent Tekcan]

In /install/upgrade_350b1.php?step=5

Hang on Altering pmtext Table (1 of 1) wait maybe 20 min.load high..I'm already max time set to 16 before starting upgrade.


Step 5) Miscellaneous table alterations 5/5

• Altering deletionlog Table (1 of 1)
• Altering editlog Table (1 of 1)
• Altering forum Table (1 of 1)
• Altering pmreceipt Table (1 of 1)
• Altering pmtext Table (1 of 1)

Any idea.....My board is very big..

[Steve Machol]

How long have you waited? How large are your forums?

[Bulent Tekcan]

20 min...than my load is high mysql stop...

My database backup is 700MB without attachment,attachment is in filesystem.And also 1.500.000 message and 135.000 member

[Steve Machol]

It may require longer time to get through this step.

[Bulent Tekcan]

I tried 3 times...evertime hang and high load this step...What is the Altering pmtext Table ? Can I pass this step ?

[Steve Machol]

No, you can't bypass this step. I'll see if one of the Devs has any ideas.

[Bulent Tekcan]

I'm waiting...because realy bad feel now

[Steve Machol]

Did you make a backup of the database before attempting this upgrade?

[Freddie Bingham]

It is dieing on this query:

$query[] = "ALTER TABLE " . TABLE_PREFIX . "post CHANGE username username VARCHAR (100) NOT NULL";

Remove it from the script and start step 5 again. You can run this query manually later as it is not important.

[Bulent Tekcan]

Yes but deleted my faulty command Only last day backup we have

[Bulent Tekcan]

I find that in upgrade_350b1.php is it correct ? Move 1 line or both line ?


$query[] = "ALTER TABLE " . TABLE_PREFIX . "post CHANGE username username VARCHAR (100) NOT NULL";
$explain[] = sprintf($upgrade_phrases['upgrade_300b3.php']['altering_x_table'], 'post', 1, 1);

[Freddie Bingham]

Both

You should never abort a step unless your browser changes to a page not found error.

[Bulent Tekcan]

Updating Version Number to 3.5.0 Beta 1... done

Can I continue ?

[Freddie Bingham]

Sure, why not?

[Bulent Tekcan]

Now in install/upgrade_350rc3.php?step=3
Step 3) Post table alterations

waiting again...