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
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..
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.
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
[] 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.
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?
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.