Web Wiz Forums - How 2 upgade from 7.5 to 7.51a

Print Page | Close Window

How 2 upgade from 7.5 to 7.51a

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=6950
Printed Date: 29 March 2026 at 4:18pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: How 2 upgade from 7.5 to 7.51a

Posted By: WebWiz-Bruce
Subject: How 2 upgade from 7.5 to 7.51a
Date Posted: 03 November 2003 at 7:06am

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&PN=1 - 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

-------------
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

Replies:

Posted By: kmacy
Date Posted: 04 November 2003 at 9:25am

Can we delete the old stored procedure "wwfSpActiveToipcs"?

-------------
Ken Macy

Posted By: WebWiz-Bruce
Date Posted: 04 November 2003 at 9:43am

Yes

-------------
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: Sensei16V
Date Posted: 05 November 2003 at 9:29am

I've got working the 7.01 version in my website, and I've modified several thing about the skin and other stuff...

what should be the best way to update to 7.51a???

what about the database??? this sp is the only thing that changed since 7.01???

Thanks!

Posted By: WebWiz-Bruce
Date Posted: 06 November 2003 at 4:11am

If you read this post carefully you will see that you first need to follow the post on upgrading from 7.01 to 7.5 then this one from 7.5 to 7.51a.

-------------
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: JohnnySlotCar
Date Posted: 10 November 2003 at 2:41am

Do I need to change ALL files to get to 7.51a from 7.5, or are the a select few I only need to upgrade. I ask because I have modified all display files to match my site - lot of work so soon after 7.5... Cry

John

Posted By: Phat
Date Posted: 10 November 2003 at 3:02am

Read the Version History.txt file that is in the download. It lists all th efiels that have been changed.

Posted By: tobes
Date Posted: 10 November 2003 at 4:56pm

sorry but where is the wwfSpActiveTopics file

-------------

http://www.itstooloud.com">

Posted By: MadDog
Date Posted: 10 November 2003 at 5:17pm

wwfSpActiveTopics is a stored procedure, not a file!

-------------
http://www.iportalx.net" rel="nofollow">

Posted By: JohnnySlotCar
Date Posted: 12 November 2003 at 2:31am

Phat wrote:

Read the Version History.txt file that is in the download. It lists all th efiels that have been changed.

Thanks!!

Posted By: tobes
Date Posted: 12 November 2003 at 4:36am

MadDog wrote:

wwfSpActiveTopics is a stored procedure, not a file!

so can you point me in the direction of how to find it,,,, thanks,,, sorry i am not to into all this asp stuff

-------------

http://www.itstooloud.com">

Posted By: teknorat
Date Posted: 15 November 2003 at 11:52pm

So am I correct in thinking that I only need update those files listed in the history txt file? I need to know for sure as I have done some new graphics and don't want to risk losing them.

Posted By: teknorat
Date Posted: 16 November 2003 at 12:06am

In fact if you make a zip file that only contains the files needed to upgrade from 7.5 to 7.51a and their folders I will purchase the link removal. Deal?

EDIT: never mind just did it. (will buy it anyway)

Posted By: neotrix
Date Posted: 22 November 2003 at 12:47am

My .db file has got toooooooo big... people have been posting to it, now i want to upgrade it, its almost impossible for me to download that file, amend it and reupload it....

do you think this will work with out ammending that Active users table?

Posted By: wilcox00
Date Posted: 24 November 2003 at 4:32pm

Upgrading from 7.5 to 7.6

Hi,

I just replaced ALL the files except for the db and my header and footer pages. everything seems to be fine... but will i run into any problems down the road?

Posted By: wolfie
Date Posted: 28 November 2003 at 11:33am

A bit of a stupid question, but where the hell do you change the strVersion information?
Mine still says 7.51a and I have upgraded but cannot find that field...

-------------
Wolfie--[ http://www.wolfweb.co.uk - WolfWeb.co.uk ]
PHP, .net--[ beginner ] ASP, VB, C, SQL--[ intermediate ] X/D/HTML, CSS, WML, XML--[

Posted By: Eftie
Date Posted: 01 December 2003 at 6:51am

A simple 30 second search job as CTRL F in filemanager resulted in two possibilities:

common.asp section 'Initialise variables
Const strVersion = "7.6"

admin/common.asp section 'Intialise variables
Const strVersion = "7.6"

-------------
Eftie

Posted By: wfusco
Date Posted: 07 December 2003 at 6:13am

tobes wrote:

MadDog wrote:

wwfSpActiveTopics is a stored procedure, not a file!

so can you point me in the direction of how to find it,,,, thanks,,, sorry i am not to into all this asp stuff

You will find it on your SQL Server under Stored Proceedures

Posted By: Pierse
Date Posted: 09 December 2003 at 2:11am

I missed an update... 7.51 is there anywhere i have to get it? I have 7.5 and 7.6 cant just update with those two?

If not, where can I find 7.51?

Posted By: WebWiz-Bruce
Date Posted: 09 December 2003 at 3:56am

Just upgrade to the latest version.

You don't need to move to inbetween versions if you missed any, just replace files with 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: Pierse
Date Posted: 14 December 2003 at 9:50pm

thanks.. I was worried...

Posted By: india
Date Posted: 23 December 2003 at 9:40am

If the installed version is v7.x, then also it can be upgraded to latest versions directly BUT you need to backup database before doing anything. /forum/admin/database/wwforum.mdb

Posted By: kyle
Date Posted: 25 December 2003 at 2:06am

MadDog wrote:

wwfSpActiveTopics is a stored procedure, not a file!

...

Posted By: tsunamih
Date Posted: 25 December 2003 at 8:39pm

hi, gents

i'm a newbie here and i ought to post this in the topic about upgrading from 7.01 to 7.5 but thats now closed.

basically i need to upgrade from 7.01 to 7.6, but as i have thus far worked out, it seems i need to upgrade from 7.01 to 7.5 first

thing is...i cant find anywhere to download 7.5 from!!! can anyone help here??? either a link to download v7.5 or another way of upgrading from 7.01 to 7.5

Posted By: india
Date Posted: 25 December 2003 at 11:47pm

tsunamih wrote:

hi, gents

i'm a newbie here and i ought to post this in the topic about upgrading from 7.01 to 7.5 but thats now closed.

basically i need to upgrade from 7.01 to 7.6, but as i have thus far worked out, it seems i need to upgrade from 7.01 to 7.5 first

thing is...i cant find anywhere to download 7.5 from!!! can anyone help here??? either a link to download v7.5 or another way of upgrading from 7.01 to 7.5

Already told before. just upgrade to latest version

Posted By: neotrix
Date Posted: 05 January 2004 at 7:35am

i just uploaded the files of the latest version, i had 7.5 and i simply uploaded the files excluding the Access Database, and its working fine

-------------
http://www.muhammadbinyusrat.com/blog/" rel="nofollow - Say to the believing men..