| Author |
 Topic Search  Topic Options
|
WebWiz-Bruce 
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 10 December 2007 at 9:23am |
|
If you are upgrading from a previous version of Web Wiz Forums you do not use the mssql_server_setup.asp file.
Instead, if you are upgrading from another version 9, you just replace the ASP files and images with those from the latest version.
If you are upgrading from a version 7 or version 8 then you use the tools found in the Database Upgrade Tools zip file that you get with the latest version. This zip file also contains a readme.txt file which explains how to use the tools.
|
|
|
 |
NShel
Groupie
Joined: 23 September 2006
Location: United States
Status: Offline
Points: 49
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 December 2007 at 1:58pm |
Okay, that got me really close, but not quite. I ran the Microsoft SQL Server v7 to v9 Update and here's what I got:
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 'HomesteadUser1.tblForum' is specified more than once.
Then a page full of these for each table, then at the end, this:
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..... 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)..... Complete
Error Discription: There is already an index on table 'tblSession' named 'Session_ID'.
Web Wiz Forums database is set up, but with Error!
I'm guessing that I get my host to delete everything from the database directory, then restore the backed-up database and try again. Am I headed in the right direction?
|
|
|
jamie.townsend
Groupie
Joined: 07 December 2007
Location: England
Status: Offline
Points: 114
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 December 2007 at 2:28pm |
Yea it does sound like the upgrade has already been applied and possibly failed previosuly.
Try it from your backup and see if you get any further.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 December 2007 at 2:47pm |
|
Where you went wrong was using the database setup tool on an already existing database, this tool is only for new installs.
What you will need to do is go back to your original version 7.x database backup (the one before you ran the database setup tool), then run the database upgrade tool on the database.
|
|
|
|
NShel
Groupie
Joined: 23 September 2006
Location: United States
Status: Offline
Points: 49
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 December 2007 at 3:18pm |
|
So I deleted the database, restored it and ran MS SQL server V7 to V9 etc.
It gave me another series of messages saying that n o such tables could be found and when I ran it again, it told me that, for example, "Error Creating the Table tblSession
There is already an object named 'tblSession' in the database."
This completed with lots of such warnings but didn't mention being set up with errors.
Anyway, now when I try to run default.asp, I get this:
Server Error in Forum Application
An error has occurred while executing SQL query on database.
Please contact the forum administrator.
Support Error Code:- err_SQLServer_get_forum_data
File Name:- default.asp
Error details:-
Microsoft OLE DB Provider for SQL Server
Invalid column name 'Last_topic_ID'.
Very frustrating. Do I need to start from the very begining or what?
|
|
NShel
Groupie
Joined: 23 September 2006
Location: United States
Status: Offline
Points: 49
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
NShel
Groupie
Joined: 23 September 2006
Location: United States
Status: Offline
Points: 49
|
Post Options
Thanks(0)
Quote Reply
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
|
|
