| Author |
 Topic Search  Topic Options
|
Andersen 
Groupie
Joined: 07 July 2002
Location: Denmark
Status: Offline
Points: 152
|
 Post Options
 Thanks(0)
 Quote  Reply
 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
|
 |
Andersen
Groupie
Joined: 07 July 2002
Location: Denmark
Status: Offline
Points: 152
|
Post Options
Thanks(0)
Quote Reply
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
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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
Edited by -boRg- - 27 December 2004 at 9:41am
|
|
|
|
Andersen
Groupie
Joined: 07 July 2002
Location: Denmark
Status: Offline
Points: 152
|
Post Options
Thanks(0)
Quote Reply
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
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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=61 31&KW=released
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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:-
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 |
|
|
|
|
|
|
Andersen
Groupie
Joined: 07 July 2002
Location: Denmark
Status: Offline
Points: 152
|
Post Options
Thanks(0)
Quote Reply
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
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 27 December 2004 at 10:27am |
It is in the version history file under:-
 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 earlier
to 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
|
|
|
|
