I am running 6.2.3 after switching to a new server. The old installation was version 6.1 The new server is an Apache server, and beyond that, I don't know what its running.
I started from scratch and used backup files created with the myPHPadmin tool provided by my host.
After installation, I restored those backup files, ran the altertables, and uploaded my stylesheets and went through the config settings.
The error that is being given is that "We cannot proceed. All required fields are not filled in"
Now, when I go click on a username and then "send PM" it shows up with a number, I assume this is the new "member #" feature.
When I go to backup my dbases, the following error occurs for the "DisplayNames" one: ------------------------------------------------------ Warning: stat failed for /home/virtual/site112/fst/var/www/html/boards/ubbthreads/backup/w3t_DisplayNames.sql (errno=2 - No such file or directory) in /home/virtual/site112/fst/var/www/html/boards/ubbthreads/admin/dodbbackup.php on line 78 w3t_DisplayNames.sql is 0 bytes or did not get created. --------------------------------------------------------
The dbase file is there, but does have a size of 0 bytes.
I assume the PM problem is related to this issue.
Also, if you look at my boards, the forums all have different column widths! Which template or part of the .css file needs to be edited and to what? The rows are also a bit tall for my liking, so if anyone can give me some quick pointers (or if I can pay a nominal fee to have these changes made) please let me know. Thanks!!!!
the New Icons are not used in 6.2 The post icons no longer change color. New posts are indicated by the row highlighting instead.
If you are using any custom stylesheets, you'll need to add a few new classes to the stylesheets to indicate new posts. See the upgrading.html document for that.
Per your database problem.
How did you restore things? Did you restore your old database and run the altertables. Or did you run the createtable script with the install.php document.
I'm wondering if you tried to import 6.1 data into a 6.2 table structure and the altertables never got to do their changes to the data.
If so, I'm thinking you don't want to run the createtable script. You want to import the 6.1 data, and let the altertable scripts do the changes to the database. Those alter some of the various columns to store numbers now instead of names, and also goes through and changes all the names to numbers in all the various tables.
This sounds like this didn't quite happen, or something went wrong at that point.
Ok, what I did was run through the entire installation process (including letting the createtable.php do its thing) and then uploaded my backups via the mySQL tool (not the UBBT restore function) and then I ran the altertables. There was an error related to the DisplayNames dbase when this happened.
Tried running the altertable again and got this message at step 1. Should I continue?
-------------------------------------------- Converting old poll votes from username to usernumber.. Alter the Boards table to drop the Bo_Moderators field... SQL ERROR: Fri, Apr 18 2003 00:32:58 -0400 Unable to do_query: ALTER TABLE w3t_Boards DROP Bo_Moderators Can't DROP 'Bo_Moderators'. Check that column/key existsSQL ERROR: Fri, Apr 18 2003 00:32:58 -0400 Unable to do_query: ALTER TABLE w3t_Users DROP U_Post_Format Can't DROP 'U_Post_Format'. Check that column/key existsProceed to step 2 -----------------------------------------
[This message was edited by MBSL on April 17, 2003 at 09:36 PM.]
Yeah, I'm thinking that you probably shouldnt' have done it that way. You ended up importing 6.1 data into a 6.2 table. Then you tried to alter it, but I'm thinking that you were already missing stuff.
I'm not sure how to go about fixing it at this point. The changes from 6.1 to 6.2 were Major database wise. Every table structure was changed because of the change to user number.
What I would try is (backup your current DB just in case). Then drop all the database tables, so you have an empty database. Restore your 6.1 database into it. Then run the altertable and let it alter the data and make the changes in the table to the 6.2 format. I expect that will fix the issue.
Okay, tried doing that and it did not work. Here's what I did and what happened:
- Dropped all tables. - Uploaded all tables from 6.1 - Ran altertable and got error messages for all steps except 1 - Restored my 6.2 backup - At no point did a replacement DisplayNames dbase appear.
I am currently missing that dbase, but my boards still seem to run ok except for the PM issue.
What would you recommend next, or do you think this is something I need to pay InfoPop to fix?
Would I have any luck starting from scratch (delete the entire mySQL dbase, installation, and redo everything)? I'm really dreading having to do this.
I guess the main problem I had is that since I needed to move to a new server, I had to redo everything. Since I started with a copy of 6.2 instead of 6.1, I had to run the install file for it correct? That then created the tables that my uploaded 6.1 tables were not compatible with. If my understanding of this is correct, I would need to start with a copy of 6.1, get everything up and running, then do the upgrade to 6.2 and run altertables from there and then redo all my stylesheets, formatting etc.
If you can think of an easier way around this (like somehow making a DisplayNames table or fixing whatever the issue is) please let me know.
That's what I tried doing. I dropped all the tables, uploaded the old ones, and ran the altertables. During each step of running the altertables, there were error messages for almost all the steps.
As you can see, step 2 is the only one that completes successfully. Hope this information helps!
------------------------------------------------ Converting old poll votes from username to usernumber.. Alter the Boards table to drop the Bo_Moderators field... SQL ERROR: Fri, Apr 18 2003 23:14:03 -0400 Unable to do_query: ALTER TABLE w3t_Boards DROP Bo_Moderators Can't DROP 'Bo_Moderators'. Check that column/key existsSQL ERROR: Fri, Apr 18 2003 23:14:03 -0400 Unable to do_query: ALTER TABLE w3t_Users DROP U_Post_Format Can't DROP 'U_Post_Format'. Check that column/key existsProceed to step 2
Alter the address book to use the uid instead of username... Proceed to step 3
Alter the Messages table to use the uid instead of username... You may get an error about an index not being able to be dropped. This is ok... SQL ERROR: Fri, Apr 18 2003 23:15:26 -0400 Unable to do_query: ALTER TABLE w3t_Messages DROP INDEX Messindx1 Can't DROP 'Messindx1'. Check that column/key existsSQL ERROR: Fri, Apr 18 2003 23:15:26 -0400 Unable to do_query: SELECT DISTINCT M_Username FROM w3t_Messages Unknown column 'M_Username' in 'field list' Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site112/fst/var/www/html/boards/ubbthreads/mysql.inc.php on line 130 SQL ERROR: Fri, Apr 18 2003 23:15:26 -0400 Unable to do_query: ALTER TABLE w3t_Messages CHANGE M_Username M_Uid INT(9) NOT NULL, ADD INDEX Uid_ndx (M_Uid,M_Status) Unknown column 'M_Username' in 'w3t_Messages'Proceed to step 4
Alter the Favorites to use the uid instead of username... Now alter the Last table to work off of Uid instead of Username... SQL ERROR: Fri, Apr 18 2003 23:15:38 -0400 Unable to do_query: ALTER TABLE w3t_Last ADD L_Uid INT(9) NOT NULL Duplicate column name 'L_Uid'SQL ERROR: Fri, Apr 18 2003 23:15:38 -0400 Unable to do_query: SELECT DISTINCT L_Username FROM w3t_Last Unknown column 'L_Username' in 'field list' Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site112/fst/var/www/html/boards/ubbthreads/mysql.inc.php on line 130 SQL ERROR: Fri, Apr 18 2003 23:15:38 -0400 Unable to do_query: ALTER TABLE w3t_Last DROP L_Username, ADD INDEX Luid_ndx (L_Uid) Can't DROP 'L_Username'. Check that column/key existsProceed to step 5
Now alter the Subscribe table to work off of Uid instead of Username... SQL ERROR: Fri, Apr 18 2003 23:15:51 -0400 Unable to do_query: ALTER TABLE w3t_Subscribe ADD S_Uid INT(9) NOT NULL Duplicate column name 'S_Uid'SQL ERROR: Fri, Apr 18 2003 23:15:51 -0400 Unable to do_query: SELECT DISTINCT S_Username FROM w3t_Subscribe Unknown column 'S_Username' in 'field list' Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site112/fst/var/www/html/boards/ubbthreads/mysql.inc.php on line 130 SQL ERROR: Fri, Apr 18 2003 23:15:51 -0400 Unable to do_query: ALTER TABLE w3t_Subscribe DROP S_Username, ADD INDEX Suid_ndx (S_Uid) Can't DROP 'S_Username'. Check that column/key existsNow alter the Ratings table to work off of Uid instead of Username... Proceed to step 6
Dropping some unneeded indexes... Note:You may get an error on some of these that the key does not exist but that is ok SQL ERROR: Fri, Apr 18 2003 23:16:07 -0400 Unable to do_query: ALTER TABLE w3t_Posts DROP INDEX w3t_Postsindex4 Can't DROP 'w3t_Postsindex4'. Check that column/key existsSQL ERROR: Fri, Apr 18 2003 23:16:07 -0400 Unable to do_query: ALTER TABLE w3t_Moderators ADD Mod_Uid INT(9) NOT NULL Duplicate column name 'Mod_Uid'SQL ERROR: Fri, Apr 18 2003 23:16:07 -0400 Unable to do_query: SELECT DISTINCT Mod_Username FROM w3t_Moderators Unknown column 'Mod_Username' in 'field list' Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site112/fst/var/www/html/boards/ubbthreads/mysql.inc.php on line 130 SQL ERROR: Fri, Apr 18 2003 23:16:07 -0400 Unable to do_query: ALTER TABLE w3t_Moderators DROP Mod_Username, ADD INDEX Moduid_ndx (Mod_Uid) Can't DROP 'Mod_Username'. Check that column/key existsProceed to step 7
SQL ERROR: Fri, Apr 18 2003 23:16:19 -0400 Unable to do_query: ALTER TABLE w3t_Posts ADD B_AnonName VARCHAR(64) Duplicate column name 'B_AnonName'SQL ERROR: Fri, Apr 18 2003 23:16:19 -0400 Unable to do_query: UPDATE w3t_Posts SET B_AnonName = B_Username WHERE B_Reged = 'n' OR B_PosterId = '1' Unknown column 'B_Username' in 'field list'Dropping some unneeded columns from the Posts table... SQL ERROR: Fri, Apr 18 2003 23:16:19 -0400 Unable to do_query: ALTER TABLE w3t_Posts DROP B_Username, DROP B_Color, DROP B_UTitle, DROP B_ParentUser, DROP B_UStatus, DROP B_Signature Can't DROP 'B_Username'. Check that column/key existsProceed to step 8
Changing the Boards table to store a Uid instead of Username of last poster... SQL ERROR: Fri, Apr 18 2003 23:16:31 -0400 Unable to do_query: ALTER TABLE w3t_Boards ADD Bo_Posterid INT(9) UNSIGNED DEFAULT '0', CHANGE Bo_LastNumber Bo_LastNumber INT(9) UNSIGNED DEFAULT '0' Duplicate column name 'Bo_Posterid'SQL ERROR: Fri, Apr 18 2003 23:16:31 -0400 Unable to do_query: SELECT Bo_Poster FROM w3t_Boards Unknown column 'Bo_Poster' in 'field list' Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site112/fst/var/www/html/boards/ubbthreads/mysql.inc.php on line 130 SQL ERROR: Fri, Apr 18 2003 23:16:31 -0400 Unable to do_query: ALTER TABLE w3t_Boards DROP Bo_Poster Can't DROP 'Bo_Poster'. Check that column/key existsProceed to step 9
Alter the Messages table to store the Uid of the sender instead of username... Alter the Banned table to use the uid instead of username... SQL ERROR: Fri, Apr 18 2003 23:16:43 -0400 Unable to do_query: SELECT B_Username FROM w3t_Banned Unknown column 'B_Username' in 'field list' Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site112/fst/var/www/html/boards/ubbthreads/mysql.inc.php on line 130 SQL ERROR: Fri, Apr 18 2003 23:16:43 -0400 Unable to do_query: ALTER TABLE w3t_Banned CHANGE B_Username B_Uid INT(9) NOT NULL Unknown column 'B_Username' in 'w3t_Banned'Alter the Online table to store the Uid as well... SQL ERROR: Fri, Apr 18 2003 23:16:43 -0400 Unable to do_query: ALTER TABLE w3t_Online ADD O_Uid INT(9) Duplicate column name 'O_Uid'SQL ERROR: Fri, Apr 18 2003 23:16:43 -0400 Unable to do_query: ALTER TABLE w3t_Category ADD Cat_Type VARCHAR(10) NOT NULL DEFAULT 'forum', ADD INDEX type_ndx (Cat_Type) Duplicate column name 'Cat_Type'Proceed to step 10
Changing the method in which sticky posts are tracked... Adding a table for storing a que of display name changes... SQL ERROR: Fri, Apr 18 2003 23:16:54 -0400 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 existsSQL ERROR: Fri, Apr 18 2003 23:16:54 -0400 Unable to do_query: ALTER TABLE w3t_Users ADD U_WhichForums VARCHAR(3) DEFAULT 'all', ADD U_Categories VARCHAR(255) DEFAULT '-', CHANGE U_Approved U_Approved VARCHAR(8) NOT NULL Duplicate column name 'U_WhichForums'Done