Web Wiz Support and Community Forums : Running version 7.01. Can I upgrade? https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 19:31:35 +0000 Mon, 27 Dec 2004 10:34:26 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=12085 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Running version 7.01. Can I upgrade? : Ohhh.. My mistake.. I was looking...]]> https://forums.webwiz.net/running-version-7-01-can-i-upgrade_topic12085_post72636.html#72636 Author: Andersen
Subject: 12085
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.
 
]]> Mon, 27 Dec 2004 10:34:26 +0000 https://forums.webwiz.net/running-version-7-01-can-i-upgrade_topic12085_post72636.html#72636 <![CDATA[Running version 7.01. Can I upgrade? : It is in the version history file...]]> https://forums.webwiz.net/running-version-7-01-can-i-upgrade_topic12085_post72634.html#72634 Author: WebWiz-Bruce
Subject: 12085
Posted: 27 December 2004 at 10:27am

It is in the version history file under:-

Originally posted by version history version history wrote:


Changes from version 7.01 to version 7.5 beta1
----------------------------------------------
50. msSQL_server_setup.asp - changed the LastAndFirstThreadAuthor stored procedure to also get the message from the database


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 earlierto get all the upgrade info required in a more digestible form:-

http://forums.webwiz.net/search.asp?KW=released &SM=1&SI=TC&FM=1&OB=1
]]> Mon, 27 Dec 2004 10:27:21 +0000 https://forums.webwiz.net/running-version-7-01-can-i-upgrade_topic12085_post72634.html#72634 <![CDATA[Running version 7.01. Can I upgrade? : Ahmm. Thats not written in the...]]> https://forums.webwiz.net/running-version-7-01-can-i-upgrade_topic12085_post72633.html#72633 Author: Andersen
Subject: 12085
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.
 
]]> Mon, 27 Dec 2004 10:04:29 +0000 https://forums.webwiz.net/running-version-7-01-can-i-upgrade_topic12085_post72633.html#72633 <![CDATA[Running version 7.01. Can I upgrade? : Here is the extract that you need Upgrading...]]> https://forums.webwiz.net/running-version-7-01-can-i-upgrade_topic12085_post72630.html#72630 Author: WebWiz-Bruce
Subject: 12085
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 alittle more complcated. You need to replace all the old files with thenew ones. You then also need to change the stored procedurewwfSpLastAndFirstThreadAuthor, in the SQL Enterprise Manager  tothe following:-

Code:
CREATE PROCEDURE [dbo].[wwfSpLastAndFirstThreadAuthor] (
@lngTopicID int
) 
AS
SELECT tblThread.Thread_ID, tblThread.Author_ID, tblThread.Message, tblThread.Message_date, tblAuthor.Username
FROM tblAuthor, tblThread
WHERE tblAuthor.Author_ID = tblThread.Author_ID AND tblThread.Topic_ID = @lngTopicID
ORDER BY tblThread.Message_date ASC;
GO

]]> Mon, 27 Dec 2004 09:56:02 +0000 https://forums.webwiz.net/running-version-7-01-can-i-upgrade_topic12085_post72630.html#72630 <![CDATA[Running version 7.01. Can I upgrade? : The error means that an item can...]]> https://forums.webwiz.net/running-version-7-01-can-i-upgrade_topic12085_post72629.html#72629 Author: WebWiz-Bruce
Subject: 12085
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 inan 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=61 31&KW=released
]]> Mon, 27 Dec 2004 09:53:45 +0000 https://forums.webwiz.net/running-version-7-01-can-i-upgrade_topic12085_post72629.html#72629 <![CDATA[Running version 7.01. Can I upgrade? : This is the error message I get: ADODB.Recordset...]]> https://forums.webwiz.net/running-version-7-01-can-i-upgrade_topic12085_post72628.html#72628 Author: Andersen
Subject: 12085
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?
 
]]> Mon, 27 Dec 2004 09:49:28 +0000 https://forums.webwiz.net/running-version-7-01-can-i-upgrade_topic12085_post72628.html#72628 <![CDATA[Running version 7.01. Can I upgrade? : It shouldn&#039;t make a difference...]]> https://forums.webwiz.net/running-version-7-01-can-i-upgrade_topic12085_post72626.html#72626 Author: WebWiz-Bruce
Subject: 12085
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 updateposts 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


Edited by -boRg- - 27 December 2004 at 9:41am]]> Mon, 27 Dec 2004 09:39:48 +0000 https://forums.webwiz.net/running-version-7-01-can-i-upgrade_topic12085_post72626.html#72626 <![CDATA[Running version 7.01. Can I upgrade? : I am not sure if this is the problem....]]> https://forums.webwiz.net/running-version-7-01-can-i-upgrade_topic12085_post72622.html#72622 Author: Andersen
Subject: 12085
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.
http://akvariet.terrabyte.dk/images/capture.jpg
 
]]> Mon, 27 Dec 2004 09:17:40 +0000 https://forums.webwiz.net/running-version-7-01-can-i-upgrade_topic12085_post72622.html#72622 <![CDATA[Running version 7.01. Can I upgrade? : I´ll try catch you on MSN Dj.....]]> https://forums.webwiz.net/running-version-7-01-can-i-upgrade_topic12085_post72591.html#72591 Author: Andersen
Subject: 12085
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.
]]> Sun, 26 Dec 2004 10:45:33 +0000 https://forums.webwiz.net/running-version-7-01-can-i-upgrade_topic12085_post72591.html#72591 <![CDATA[Running version 7.01. Can I upgrade? : i thought that was the case -boRg-...]]> https://forums.webwiz.net/running-version-7-01-can-i-upgrade_topic12085_post72590.html#72590 Author: dj air
Subject: 12085
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 wantyou 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)
]]> Sun, 26 Dec 2004 09:32:49 +0000 https://forums.webwiz.net/running-version-7-01-can-i-upgrade_topic12085_post72590.html#72590