Running version 7.01. Can I upgrade?
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=12085
Printed Date: 11 April 2026 at 10:35pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Running version 7.01. Can I upgrade?
Posted By: bacwebdesign
Subject: Running version 7.01. Can I upgrade?
Date Posted: 08 October 2004 at 11:16pm
| I've just taken over a site running version 7.01 of the forum. Can I upgrade to the latest version without eliminating my content? |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 09 October 2004 at 4:36am
|
You haven't said what version you are running. If you are using Access just backup the database, which should have a name like wwForum.mdb and then overwrite all the files except the database with the files from the latest version. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Andersen
Date Posted: 19 December 2004 at 9:11am
|
boRg, what if itīs SQL ?
Iīm running 7.01 here, and have been thinking to upgrade several times. But each time I figure this is gona take a lot of time, if even possible.
I have read in another thread, that you suggest going through the history file. Well fine, except the history requires that one is upgrading all the inbetween versions as well.
I wonder if there is an hmm.. kind of easy way to go from 7.01 to 7.9 now? Or at least somekind of an explanation to do it.
------------- Greets Andersen |
Posted By: dj air
Date Posted: 19 December 2004 at 11:01am
|
for SQL upgrade it is stated in the version history. the structure i don't think has changed i think its only the Stored procedures. you can try deleting the existing stored procedures and run the section of the MSSQL_server_Setup.asp file that creates the stored procedures. and just replace the .asp files listed. |
Posted By: Andersen
Date Posted: 20 December 2004 at 12:02pm
|
I know youīre just trying to help dj air, but words like "I dont think.." and "you can try..." does not really convince me, that this is going to work.
If I understand this correct. I would need to go through all files from the 7.5 til 7.9 stated in the version history file. Most files have been changed in the upgrade from 7.01 to 7.5 though, and some have been changed again in the upgrade from 7.5 to 7.9.
I think this is difficult.
------------- Greets Andersen |
Posted By: dj air
Date Posted: 20 December 2004 at 2:16pm
|
ive just checked the History on the MSSQL_Server_Setup.asp file ..
nothing has been changed since V7.01 so your Database is up topdate. things have been deleted but that doesn't matter as its not requireds. so you only have to upload the .asp files and delete the stored procedures and re create them, by only using the certain section that creates the stored procedures. |
Posted By: Andersen
Date Posted: 21 December 2004 at 9:29am
This stored procedures I have yet to understand what the heck it is, and how to delete/create those.
Is this done only by running the msSQL_server_setup.asp file? Copying the files is no problem
 Another question.. I read somewhere, that the uploaded files by the users will now be stored in a folder containing the username. What happens to those files which has already been uploaded before the upgrade, and now located in the images/upload folder?
------------- Greets Andersen |
dj air wrote:Posted By: dj air
Date Posted: 21 December 2004 at 10:10am
|
to add the stored procedures agan you need to open your database (SQL)
using something like MS enterprise manager. and go to the stored
procedures section of the database and delete all procedures fopr the
forum within the section. then open the msSQL_server_setup.asp file and delete the sections that add the tables, indexes etc. leaving the sections that create the stored procedures. im not sure but you may be able to just re run the file without modifications. it will through up errors about the tables but that would be ok. then your done. (use at own risk). regards to posts and uploaded images. they will be ok. it will be correct also for new uploads as they will be put into users folders. |
Posted By: Andersen
Date Posted: 23 December 2004 at 9:36pm
|
Hmm, Dj Air.. I just made a test, and it didnt went well.
What I did was:
Installed a new empty database. Restore a backup from my original forum to this new empty database.
Made the changes to the stored procedures. Copy the whole directory if WebWiz 7.9 to a new domain. Changed the SQL connection to this new database.
When entering the "new" forum now, Itīs working fine, just untill I try to enter one of the forum areas. Then I receive this error:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal. /forum_topics.asp, line 424 Looking from the main page, all data seems to have been copied. So I wonder what I made wrong!
Btw.. Merry Christmas to all of you!
------------- Greets Andersen |
Posted By: Andersen
Date Posted: 23 December 2004 at 9:40pm
|
Hmm.. Just noticed. I can enter all messages using the Active Topics.
------------- Greets Andersen |
Posted By: dj air
Date Posted: 24 December 2004 at 5:51am
|
the error message means that a field is missing from the table. (topics table) but from what i saw in the Version history nothing was done. hjave a look on the line that the error occurs, that hopefullly will tell you whats missing. whjen you say created a new database do you mean blank one.? with No WWF info at all. or do you mean a blank WWF database on the SQL server, with the scructure. you can always try making a blank WWF tables and then import data ONLY. |
Posted By: Andersen
Date Posted: 24 December 2004 at 8:19am
|
I used the enterprise manager til create a new database (I assume itīs empty). After that I used Enterpriser to restore the database (know it sounds silly, as itīs a new database), but pointed the path to the original database, to restore the data from that one into the new one.
------------- Greets Andersen |
Posted By: dj air
Date Posted: 24 December 2004 at 9:59am
|
can you open the Topic table and see what the last field is called,
then we can tell if its because a new field has been entered, you have replaced the stored procedures by deleting the old ones (that will also be imported in think). re run the creation script. |
Posted By: Andersen
Date Posted: 24 December 2004 at 8:12pm
|
I guess you mean open the database in enterprise manager, go to the tables and doubble click on the tblTopic ?
Iīm not sure what to look for in here, but the last field is Priority, Smallint, 2, no mark in Nulls, Default empty.
I didnīt delete the old procedures (those mentioned in upgrade 7.5) as I thought it didnīt matter. ------------- Greets Andersen |
Posted By: Andersen
Date Posted: 25 December 2004 at 9:22am
|
HMMMM.. it has to be something wrong with the msSQL_server_setup.asp file.
I tried again, restoring data to the "forum2" database, by using the backup from "forum1", after that I ran the msSQL_server_setup.asp modified to only update the section of the Stored Procedures.
I get the same error, but also noticed I got a new error this time:
Error Creating the Stored Procedure wwfSpDBinfo (it may already exsist). If you are using MS SQL Server 7 ignore this error (You will not be able to view SQL Server stats in the admin area) The result is the same though.
Now.. It seems like there is either something missing in the stored procedures/tabel, or the file forum_topic.asp is corrupted somehow.
I really need a good advice now, as I have no more ideas what to do from here.
------------- Greets Andersen |
Posted By: Andersen
Date Posted: 25 December 2004 at 11:04am
|
i have just opened the tbltopic tabel, and as far as I can see, theyīre totally identical. 2933 topics, and the fields are exactly the same in the two databases..
------------- Greets Andersen |
Posted By: Andersen
Date Posted: 25 December 2004 at 5:10pm
|
If I comment this line out from forum_topic.asp (line 424) then it all works fine:
'strFirstPostMsg = Mid(rsTopic("Message"), 1, 275)
Can anyone tell me, whatīs happning?
What does this line do, why does it work without, and why is this given me problems when upgrading from 7.01 to 7.9 when the databases is identical?
Btw this line is not in the forum_topic.asp from version 7.01
------------- Greets Andersen |
Posted By: WebWiz-Bruce
Date Posted: 26 December 2004 at 7:05am
|
This line gives a preview of the first message when you hover the mouse over the link to the topic in the active topics page
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Andersen
Date Posted: 26 December 2004 at 7:28am
|
Can you tell me why this line gives the error then?
I am a bit afraid to "open" the new upgraded forum yet, untill I know whats the problem here, and hopefully how to fix it. ------------- Greets Andersen |
Posted By: dj air
Date Posted: 26 December 2004 at 8:02am
|
the field either isn't being bought in via the query Select table.fieldname Fieldname = "message" (or whatever its called) is that in the query above , that brings in the topic details... if not add it to the begining after SELECT it may be a Stored procedure then in that case you will need to check the stored procedure named above the query. else it might be that the topic table doesn't hold the new field check the topic table to make sure the table holds the field. |
Posted By: Andersen
Date Posted: 26 December 2004 at 8:20am
|
I have very little idea what youīre speaking of boRg. I know very little asp, and nada sql.
I have however found out how to open a tabel, and I can tell for sure, my two databases (7.01 and 7.9) is identical as far as topic tabel goes. So my guess is that the field is missing.
Now, how do I add it, and whats the name of it?
(and why is it missing?).
------------- Greets Andersen |
Posted By: WebWiz-Bruce
Date Posted: 26 December 2004 at 8:34am
|
There are no fields added to the database between different version 7 databases.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Andersen
Date Posted: 26 December 2004 at 9:24am
 Is there anyone who is capable of telling me, whats going on, and how I get version 7.9 to work from this point I have reached?
I am getting more confused for each answer to this topic and close to give it all up
 ------------- Greets Andersen |
Posted By: dj air
Date Posted: 26 December 2004 at 9:32am
|
i thought that was the case -boRg- , the only thing i can think is that your .asp files are corrupt, as the database should be correct. the first error message suggests the value isn't bought into the page., to downloading a new version of the forum_posts.asp, also if you want you can send me an email with the existing file, to check, Aaron[AT]emagine-hosts.com also if you need you can contact me via MSN (aaronhoc[at]hotmail.com) |
Posted By: Andersen
Date Posted: 26 December 2004 at 10:45am
|
Iīll try catch you on MSN Dj.. I really would like to get this fixed and get up to date on the forum.
------------- Greets Andersen |
Posted By: Andersen
Date Posted: 27 December 2004 at 9:17am
|
I am not sure if this is the problem. But after trying to locate somekind of a differences between my two databases, I started all over with creating a new "second" database (empty) and set it up loke it was a totally new forum. Then I created a forum and entered a message in it.
After that I went back to Enterprise Manager to investigate the difference between the "new" and the "old" (Original) database in the tbltopic tabel.
I did notice a difference now.. My original database is NOT! starting with Topic number 1, but insted topic number 2.
The new database is starting with topic number 1. Can this be the cause of all problems? And if yes, what the heck to I do now? (Where did topic number 1 go?).
I have a screendump if anyone would like to see.
------------- Greets Andersen |
Posted By: WebWiz-Bruce
Date Posted: 27 December 2004 at 9:39am
|
It shouldn't make a difference as it just means that the first topic has been deleted. What is the exact error message you get? Also make sure when you updated you have gone through all the update posts I wrote as they contain what stored procedures have changed:- http://forums.webwiz.net/search.asp?KW=released&SM=1&SI=TC&FM=1&OB=1 - http://forums.webwiz.net/search.asp?KW=released &SM=1&SI=TC&FM=1&OB=1 ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Andersen
Date Posted: 27 December 2004 at 9:49am
|
This is the error message I get:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal. /forum_topics.asp, line 424 Happens when entering one of the forums.Either I have totally misunderstood your version history, otherweise as far as I can tell, the only version which has something changed as far as stored procedures is version 7.6 where you remove 6 or 7.
I got the impression, if thats all, my database should be compatible with 7.9 without modifications?
------------- Greets Andersen |
Posted By: WebWiz-Bruce
Date Posted: 27 December 2004 at 9:53am
|
The error means that an item can not be found in the returned SQL query. This means that your database is probably correct. The problem is that the stored procedure 'wwfspLastAndFirstThreadAuthor' has changed from 7.01 to 7.9 to add in an extra part that returns an extra field to the recordset. The following post tells you the stored procedure that needs to be updated:- http://forums.webwiz.net/forum_posts.asp?TID=6131&KW=released - http://forums.webwiz.net/forum_posts.asp?TID=61 31&KW=released ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: WebWiz-Bruce
Date Posted: 27 December 2004 at 9:56am
|
Here is the extract that you need Upgrading SQL Server Version Upgrading from version 7.01 to 7.5 SQL server version is a little more complcated. You need to replace all the old files with the new ones. You then also need to change the stored procedure wwfSpLastAndFirstThreadAuthor, in the SQL Enterprise Manager to the following:-
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Andersen
Date Posted: 27 December 2004 at 10:04am
|
Ahmm. Thats not written in the version history!!
Iīll give it a go in a few minutes and retur with the result.
------------- Greets Andersen |
Posted By: WebWiz-Bruce
Date Posted: 27 December 2004 at 10:27am
It is in the version history file under:-
There where allot of changes between 7.01 to version 7.5 beta1 so you probably just missed it. You are best off going through the files in the search I gave earlier to get all the upgrade info required in a more digestible form:- search.asp?KW=released&SM=1&SI=TC&FM=1&OB=1 - http://forums.webwiz.net/search.asp?KW=released &SM=1&SI=TC&FM=1&OB=1 ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Andersen
Date Posted: 27 December 2004 at 10:34am
|
Ohhh.. My mistake.. I was looking for the same "layout" as you wrote in history file section 7.6 where you have changes to the database..
Well, everything is working now.. Thanks alot boRg.
------------- Greets Andersen |