UBB.Dev
Posted By: SchoolScandals Proceed to step1 for 25 min? - 01/01/2003 6:33 AM
I see it says it could take a while but does that mean 2 min or half a hour? I only have like 3100 users.

Edit: I'm talking about the altertables for 6.2 by the way. Forgot to mention that.
Posted By: Storm_dup1 Re: Proceed to step1 for 25 min? - 01/01/2003 6:57 AM
Nope, shouldn't take that long... No more than a couple minutes really even with that many users.... Test it and see if it worked. I had to reinstall the files and run the alter table twice... ~note~ Don't run the alter table twice unless you know what yer doing.....
Posted By: SchoolScandals Re: Proceed to step1 for 25 min? - 01/01/2003 7:06 AM
it doesn't seem to be doing anything at all. I coppied everything so i'm on a backup server and backup board and everything but nothings happening.
Posted By: JoshPet Re: Proceed to step1 for 25 min? - 01/01/2003 8:01 AM
I think rick broke up the altertable. Mine took 45 minutes for 7300 users.
Posted By: SchoolScandals Re: Proceed to step1 for 25 min? - 01/01/2003 10:41 PM
Am I doing something wrong? i'm going to the file altertable-6.1-6.2.php and clicking the link ...but nothing happens. I've re-uploaded it, re-coppied the database... I don't know what else to do..
Posted By: 3DSHROOM_dup1 Re: Proceed to step1 for 25 min? - 01/01/2003 10:46 PM
After running my altertable the first time and not having it work..... I also had to break up the script and run it pretty much one section at a time. Reaaaaaaally sucks with you have 17,000 users, 120,000 PMs, and 967,824 threads/replies. smirk
Posted By: SchoolScandals Re: Proceed to step1 for 25 min? - 01/01/2003 10:56 PM
And how do you do that?
Posted By: SchoolScandals Re: Proceed to step1 for 25 min? - 01/01/2003 11:57 PM
okay I found that I needed to add "$step = get_input("step","get");" after main.inc.php

I'm not sure if it worked though, it "finished" step 10 with this message. Seems to me there was one more table that needed to be altered but I have no idea:

Changing the method in which sticky posts are tracked...
Adding a table for storing a que of display name changes...
SQL ERROR: Unable to do_query: CREATE TABLE w3t_DisplayNames ( D_Entry INT(9) NOT NULL AUTO_INCREMENT PRIMARY KEY, D_Uid INT(9), D_DisplayName VARCHAR(255) )
Table 'w3t_displaynames' already existsDone
Posted By: ehm Re: Proceed to step1 for 25 min? - 01/03/2003 8:56 AM
Hi,
I'm having the same problem...
Where did you add that $step = get_input("step","get");" ?

You sad something about "after main.inc.php" but since I'm zero at .php, I have no clue where it should be add.
Thank you
Elton
Posted By: Dave_L_dup1 Re: Proceed to step1 for 25 min? - 01/03/2003 9:54 AM
Are you talking about altertable-6.1-6.2.php or install.php?

altertable-6.1-6.2.php doesn't use "step", so I don't see why that would matter.

install.php uses 'step', and already has a get_input() for it, but it's missing the second parameter 'get'.
Posted By: SchoolScandals Re: Proceed to step1 for 25 min? - 01/03/2003 11:26 AM
Humm In that case I have NO idea why/if it changed anything.
Posted By: powerlord Re: Proceed to step1 for 25 min? - 01/03/2003 3:12 PM
[]
altertable-6.1-6.2.php doesn't use "step", so I don't see why that would matter.
[/]

That would be incorrect. Lines 26-28 of altertable-6.1-6.2.php are:
if ($step) {
${$step()};
}

This also happens to be the first place $step is mentioned in this file, so if you have register_globals off, it fails (unless you add the code provided in the posts above).

P.S. For convenience, I've attached altertable-6.1-6.2.php to this post.

Attached File
Posted By: Dave_L_dup1 Re: Proceed to step1 for 25 min? - 01/03/2003 3:50 PM
Thanks for the correction. I did some checking, and evidently there was a "second version" of 6.2 uploaded to the members area around Dec 30, which included some bug fixes, as well as the "step" stuff in altertable.

It's good that the bugs were fixed, but releasing a new version without bumping the version number is poor configuration management. Was there even an announcement about the "second" 6.2?
© UBB.Developers