How 2 upgade from 7.5 to 7.51a

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

REMEMBER BACK-UP ALL FILES FIRST INCASE THINGS DON'T GO TO PLAN!!!!

Upgrading from 7.1 to 7.5 please see:-

   http://forums.webwiz.net/forum_posts.asp?TID=6136

Upgrading Access Version 7.5 to 7.51a

Just replace the old files with the new ones keeping the same database
file. All changed files are listed in the Version History file that comes with the forum.

Upgrading MS SQL Server Version 7.5 to 7.51a

Upgrading from version 7.5 to 7.51a SQL server version is a
little more complcated. You need to replace all the old files with the
new ones. All changed files are listed in the Version History file that
comes with the forum.You then also need to create the new stored
procedure, wwfSpActiveTopics, in the SQL Enterprise Manager  to
the following:-

CREATE PROCEDURE [dbo].[wwfSpActiveTopics] (

@AuthorID int,

@GroupID int,

@GroupPerm int,

@dblActiveFrom datetime

)

AS

SELECT tblForum.Forum_name, tblForum.Password, tblForum.Forum_code, tblTopic.* 

FROM tblCategory, tblForum, tblTopic 

WHERE ((tblCategory.Cat_ID = tblForum.Cat_ID AND tblForum.Forum_ID =
tblTopic.Forum_ID) AND (tblTopic.Last_entry_date > GetDate() -
@dblActiveFrom))

 AND (tblForum.[Read] <= @GroupPerm OR (tblTopic.Forum_ID IN (

    SELECT tblPermissions.Forum_ID 

    FROM tblPermissions 

    WHERE tblPermissions.Author_ID = @AuthorID OR
tblPermissions.Group_ID = @GroupID AND tblPermissions.[Read]=1))

    )

ORDER BY tblCategory.Cat_order ASC, tblForum.Forum_Order ASC, tblTopic.Last_entry_date DESC;

GO

Edited by -boRg-