https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 04 Apr 2026 05:22:02 +0000 Tue, 11 Dec 2007 22:27:11 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=24973 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/new-installation-in-progress_topic24973_post130022.html#130022 Author: NShel
Subject: 24973
Posted: 11 December 2007 at 10:27pm

Knowing what version to upgrade to definitely made this a more pleasurable experience.

Thanks for your patience.


]]> Tue, 11 Dec 2007 22:27:11 +0000 https://forums.webwiz.net/new-installation-in-progress_topic24973_post130022.html#130022 https://forums.webwiz.net/new-installation-in-progress_topic24973_post130001.html#130001 Author: WebWiz-Bruce
Subject: 24973
Posted: 11 December 2007 at 11:16am

The error messages that you have suggest either that you are running version 8 database, or you have already run the upgrade tool on this database.

Have a look inside your original database, if it has a tblSession table, then you are using version 8

If your old forum also has a calender system then you are certainly using version 8 as the calendar systems was only introduced in version 8.
]]> Tue, 11 Dec 2007 11:16:33 +0000 https://forums.webwiz.net/new-installation-in-progress_topic24973_post130001.html#130001 https://forums.webwiz.net/new-installation-in-progress_topic24973_post129987.html#129987 Author: NShel
Subject: 24973
Posted: 11 December 2007 at 3:41am

It occurred to me that I might be upgrading from the wrong version, but I see that the old version I had was 7.7.  ]]> Tue, 11 Dec 2007 03:41:51 +0000 https://forums.webwiz.net/new-installation-in-progress_topic24973_post129987.html#129987 https://forums.webwiz.net/new-installation-in-progress_topic24973_post129986.html#129986 Author: NShel
Subject: 24973
Posted: 11 December 2007 at 3:13am

Okay.

1. I asked the web host to restore the database and he emailed me that he had
2. I deleted all of version 7 out of the forum directory.
3. I uploaded the Database Upgrade Tools, went to (my forum) Database Upgrade Tools/upgrade.htm and chose to upgrade from ver. 7.
4. This is what I got back:
Database Updated Started

Stage 1: Database Connection..... Complete

Stage 2: Creating New Database Tables and Fields.....
Error Updating the Table tblForum
Column names in each table must be unique. Column name 'Sub_ID' in table 'DBO.tblForum' is specified more than once.


Error Updating the Table tblTopic
Column names in each table must be unique. Column name 'Icon' in table 'DBO.tblTopic' is specified more than once.


Error Update the Table tblThread
Column names in each table must be unique. Column name 'Hide' in table 'DBO.tblThread' is specified more than once.


Error Updating the Table tblPermissions
Column names in each table must be unique. Column name 'View_Forum' in table 'DBO.tblPermissions' is specified more than once.


Error Dropping Contraints in Table tblPermissions
ALTER TABLE DROP COLUMN failed because column 'Read' does not exist in table 'tblPermissions'.


Error Altering the Table tblAuthor
Column names in each table must be unique. Column name 'No_of_PM' in table 'DBO.tblAuthor' is specified more than once.


Error Altering the Table tblConfiguration
Column names in each table must be unique. Column name 'ID' in table 'DBO.tblConfiguration' is specified more than once.


Error Altering the Table tblDateTimeFormat
Column names in each table must be unique. Column name 'ID' in table 'DBO.tblDateTimeFormat' is specified more than once.


Error Creating the Table tblPollVote
There is already an object named 'tblPollVote' in the database.


Error Creating the Table tblSession
There is already an object named 'tblSession' in the database.

Complete

Stage 3: Creating Index's on database.....
Error Creating one or more Index's
There is already an index on table 'tblSession' named 'Session_ID'.

Complete

Stage 4: Entering default values for new fields.....
Error entering default values in the Table tblConfiguration
Invalid column name 'Upload_allocation'.

Complete

Stage 5: Populating Database with Default Forum Permissions (this may take some time to complete).....
Permissions are reset to original defaults, you may need to update them once the upgrade is complete.
Complete

Stage 6: Populating Database with Forum Statistics (this may take some time to complete).....Complete

Stage 7: Populating Database with Topic Statistics (this may take some time to complete).....


The database was backed up before any of this was begun.  Any suggestions?


]]> Tue, 11 Dec 2007 03:13:55 +0000 https://forums.webwiz.net/new-installation-in-progress_topic24973_post129986.html#129986 https://forums.webwiz.net/new-installation-in-progress_topic24973_post129970.html#129970 Author: NShel
Subject: 24973
Posted: 10 December 2007 at 4:54pm

Thanks, that's pretty clear.

I expect you'll be asleep before I get this finished, so thanks for your help and I'll let you know how it turned out.


]]> Mon, 10 Dec 2007 16:54:53 +0000 https://forums.webwiz.net/new-installation-in-progress_topic24973_post129970.html#129970 https://forums.webwiz.net/new-installation-in-progress_topic24973_post129969.html#129969 Author: WebWiz-Bruce
Subject: 24973
Posted: 10 December 2007 at 4:49pm

No

1. Remove all the files for your version 7 forum (accept the Access database file if using the Access version)
2. Run the database upgrade tool
3. Upload version 9
4. Edit the file database/database_connection.asp so that it points to your database

You do not follow the instructions at http://www.webwiz.net/WebWizForums/kb/mySQL_install.asp as these are for a new installations with a new database.

As to why you would be looking at the mySQL instructions I don't know as version 7 did not have support for mySQL. If you are using mySQL then check that you are not using version 8, as mySQL was only supported from version 8 onwards.
]]> Mon, 10 Dec 2007 16:49:41 +0000 https://forums.webwiz.net/new-installation-in-progress_topic24973_post129969.html#129969 https://forums.webwiz.net/new-installation-in-progress_topic24973_post129968.html#129968 Author: NShel
Subject: 24973
Posted: 10 December 2007 at 4:42pm

Okay, so I'm starting with an empty directory.

I copy all the v.9 files to it.

Then I restore the v7 database,

THEN I run MS SQL Server v7 to v9 update...

and then follow the directions at http://www.webwiz.net/WebWizForums/kb/mySQL_install.asp

Check?


]]> Mon, 10 Dec 2007 16:42:34 +0000 https://forums.webwiz.net/new-installation-in-progress_topic24973_post129968.html#129968 https://forums.webwiz.net/new-installation-in-progress_topic24973_post129966.html#129966 Author: NShel
Subject: 24973
Posted: 10 December 2007 at 4:23pm

Well, I am reading the instructions, but I won't quibble with you that I'm getting it all wrong.

I am working from the original v.7 database which I backed up from the begining.

Here's what I did.  Before I began the upgrade, I backed up all my ver. 7 files as well.  Then I deleted from the server the default.asp file but did not delete the image files.  My reasons for doing this were that I didn't see the reference to image files (and can't find it now) and my old ver. 7 uploads file took 2 days to back up it was so large.

It's still that large, but I'll set about deleting all.  This is the right course, yes?

I apologize for my clumsiness.  I debated where to begin with your instructions because I found the file Readmefirst.txt.  I was unsure whether to read it first or not since it was in a subdirectory below the one simply called, readme.txt. 
But first is first so...  Obviously, I made the wrong choice.

So here goes again...



Edited by NShel - 10 December 2007 at 4:28pm]]> Mon, 10 Dec 2007 16:23:37 +0000 https://forums.webwiz.net/new-installation-in-progress_topic24973_post129966.html#129966 https://forums.webwiz.net/new-installation-in-progress_topic24973_post129965.html#129965 Author: WebWiz-Bruce
Subject: 24973
Posted: 10 December 2007 at 3:44pm

STOP SLOW DOWN YOU ARE NOT READING THE INSTRUCTIONS AND ARE DOING IT ALL WRONG!   

You need to go back to your original unmodified database, if you are getting an error saying that tblSession already exists then you are either using version 8 or you have run the a version 9 database setup against this database.

Once you find your version 7 unmodified database, you then need to follow the database upgrade tool instructions. These mention that you have remove your version 7 asp and images files and to prevent users from using your forum while the database is upgraded, it also mentions that you can not use an older version (ie 7 or 8) with a database upgraded to version 9, or you will get a corrupted database.

You also need to run any database tools ONLY ONCE, running it again will make things worse! If it fails the first time, then you need to find out why, before rolling back to the original database and starting again.

There is no reason why you should get any errors at all, infact getting errors is very rare and are usually because someone has not followed the instructions.


Edited by -boRg- - 10 December 2007 at 3:52pm]]> Mon, 10 Dec 2007 15:44:52 +0000 https://forums.webwiz.net/new-installation-in-progress_topic24973_post129965.html#129965 https://forums.webwiz.net/new-installation-in-progress_topic24973_post129964.html#129964 Author: NShel
Subject: 24973
Posted: 10 December 2007 at 3:22pm

It's possible that some of my forum members might have tried to re-register while the above was going on.  I assumed that the "new" version of the old database would just write over them, but perhaps this is part of the problem?

Right now, there's only the server error message coming up, so if I do it again, they won't be able to do that again.


]]> Mon, 10 Dec 2007 15:22:07 +0000 https://forums.webwiz.net/new-installation-in-progress_topic24973_post129964.html#129964