Previous Thread
Next Thread
Print Thread
Rate Thread
#231418 12/31/2002 11:33 PM
Joined: Jul 2002
Posts: 135
Journeyman
Journeyman
Joined: Jul 2002
Posts: 135
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.

Last edited by SchoolScandals; 12/31/2002 11:34 PM.
Sponsored Links
Joined: Aug 2002
Posts: 239
Member
Member
Joined: Aug 2002
Posts: 239
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.....


Some people read their stars..... I choose to write my own
Joined: Jul 2002
Posts: 135
Journeyman
Journeyman
Joined: Jul 2002
Posts: 135
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.

Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
I think rick broke up the altertable. Mine took 45 minutes for 7300 users.

Joined: Jul 2002
Posts: 135
Journeyman
Journeyman
Joined: Jul 2002
Posts: 135
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..

Sponsored Links
Joined: Apr 2002
Posts: 102
Journeyman
Journeyman
Offline
Joined: Apr 2002
Posts: 102
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

Joined: Jul 2002
Posts: 135
Journeyman
Journeyman
Joined: Jul 2002
Posts: 135
And how do you do that?

Joined: Jul 2002
Posts: 135
Journeyman
Journeyman
Joined: Jul 2002
Posts: 135
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

Joined: Oct 2002
Posts: 105
ehm Offline
Journeyman
Journeyman
Offline
Joined: Oct 2002
Posts: 105
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

Joined: Apr 2002
Posts: 1,768
Addict
Addict
Offline
Joined: Apr 2002
Posts: 1,768
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'.

Sponsored Links
Joined: Jul 2002
Posts: 135
Journeyman
Journeyman
Joined: Jul 2002
Posts: 135
Humm In that case I have NO idea why/if it changed anything.

Joined: Oct 2000
Posts: 60
Power User
Power User
Offline
Joined: Oct 2000
Posts: 60
[]
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.
Attachments
63478-altertable-6.1-6.2.zip (0 Bytes, 8 downloads)

Joined: Apr 2002
Posts: 1,768
Addict
Addict
Offline
Joined: Apr 2002
Posts: 1,768
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?


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Posts: 70
Joined: January 2007
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20240430)