One interesting thing that Allen and I discovered the other night....

If your browser times out....
the process seems to continue on the server. Don't try again, or it gets corrupted.

If you have something like phpMyAdmin, you can watch the processes.... and watch them go until they all finish.. .then move on to the next step.

I think all the trouble comes from running the altertable more than once... then it'll lose who the PMs belong to.

Now the "official" word from Infopop is to disgard extra PMs before upgrade. I typically ditched everything older than 30 days prior to upgrades... and beyond the initial release... I never lost a PM with the updated altertable.

That said... 100,000 PMs is alot. Maybe your browser times out... and the server should conintue.. unless PHP times out on the server.
What it's doing at that point is looking at the name that was associated with the Message... looking up it's user number. Then assiging all the messages by user number.

It has to do this for sender and recipient for each private message.

<img border="0" title="" alt="[Eek!]" src="images/icons/shocked.gif" /> Wish there were a better answer.

My advice would be to let it do it's thing, and try to monitor for when it finishes.

I think if it can sucessfully run once (and only once) even if it times out in the browser... all will be fine. <img border="0" title="" alt="[Wink]" src="images/icons/wink.gif" />

Josh
www.joshuapettit.com
ThreadsDev.com Administrator | InfoPop Community Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
My threads 'tweaking' abilities are for hire for upgrades, tweaks and modifications.