How long for Step 4 350b1

[mark@sb.ws]

Seems like this step is not moving along. How long should this step take on a database in the 2Gig range? Thanks for the input.

[Colin F]

The only big things I see is that it alters the attachment table.
If you have a lot of attachments this can potentially take a while.

If the page stops loading, try simply reloading it, if it's still working, let it be.

[mark@sb.ws]

Thanks for the input. When you say "take a while" how long is a while? Thanks again.

[Colin F]

That's hard to say, it depends on the size of your database, and your attachment table.

[mark@sb.ws]

Looks like it just timed out. Page failed to load after about 30-45 minutes. Ideas? I'm going to try it again.

[Colin F]

Try simply reloading the page.
If the same thing happens, you'll have to run the query which is timing out manually from the command line.

[mark@sb.ws]

It did it again at step 4 350b1.

How do I run the query and from where? Myphpadmin like other queries? What would be the exact command?

Thank you very much for the help.

[Colin F]

You'll have to let me know where exactly the script is stalling.
What's the last thing you see on the page?

[mark@sb.ws]

Step 4) Miscellaneous table alterations 4/6

It never displays anything other than this. The page loading status bar at the bottom goes about half way and than the page fails to load after about 30-45 minutes.

[Colin F]

Try running this query manually:
ALTER TABLE subscribeevent DROP PRIMARY KEY;

[mark@sb.ws]

phpmyadmin query error for the above

Error

SQL query:
ALTER TABLE subscribeevent DROP PRIMARY KEY ;


MySQL said:
#1075 - Incorrect table definition; There can only be one auto column and it must be defined as a key

[Colin F]

Hmmm... could you open a support ticket, providing AdminCP, FTP and phpMyAdmin login details, as well as a full description of the problem please?
Thanks.

[mark@sb.ws]

Support ticket created. Thanks

[mark@sb.ws]

OK, past the 3.5.0.

Now the holdup is on step 10 of 11
Step 10) Super Moderator Permission Updates
3.6.0 b1

Any reason why this would take longer than 30-45 minutes

[mark@sb.ws]

Database error in vBulletin :
mysql_connect(): Too many connections
/home/sport/public_html/includes/class_core.php on line 271
MySQL Error :
Error Number :
Date : Thursday, June 29th 2006 @ 02:42:04 PM
Script : http:///install/upgrade.php
Referrer :
IP Address : 68.154.253.151
Username :
Classname : vb_database

[Colin F]

Please keep this discussion either in the ticket or on the forums, but not in both places.

[hornstar6969]

May I ask what version you were upgrading from?

Thanks.