Web Wiz Forums - 7.6 - 7.9 SQL updates

Print Page | Close Window

7.6 - 7.9 SQL updates

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=11870
Printed Date: 09 April 2026 at 3:03am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: 7.6 - 7.9 SQL updates

Posted By: dudboy
Subject: 7.6 - 7.9 SQL updates
Date Posted: 20 September 2004 at 8:34am

I read in the documentation that from 7.6 - 7.7 there are some sql amends

6. msSQL_server_setup.asp - removed the creating of the tblActiveUsers table and the stored procedures:-
wwfSPActiveUsersWhereIPis
wwfSPAddNewActiveUser
wwfSPUpdateActiveUser
wwfSPDeleteActiveUser
wwfSPDeleteActiveUserDoubleEntry
wwfSPCountOfActiveUsers
wwfSPCountOfActiveGuests

How deos this effect upgrading an existing forum from 7.6 - 7.9.

Is there anything I need to run over the SQL database to remove / add or amend existing tables or can I just copy the new asp files up live.

Many thanks

-------------
www.clubgti.com
www.clubgti.com/forum

Replies:

Posted By: dj air
Date Posted: 20 September 2004 at 8:40am

you need to look around . but i think apart from the deletion of the active users table

i think nothing is done and are able to just upload the .asp files.. you need to have a look to see if any changes to stored procedures has been done (don't think so)

i think it is just uplaod new .asp files .

Posted By: dudboy
Date Posted: 20 September 2004 at 9:02am

The version I have running on my development server seems fine and this only says about deleting stored procedure

wwfSPActiveUsersWhereIPis
wwfSPAddNewActiveUser
wwfSPUpdateActiveUser
wwfSPDeleteActiveUser
wwfSPDeleteActiveUserDoubleEntry
wwfSPCountOfActiveUsers
wwfSPCountOfActiveGuests

I can't find anything else so will give it a go.

many thanks

-------------
www.clubgti.com
www.clubgti.com/forum

Posted By: dj air
Date Posted: 21 September 2004 at 8:37am

yes those stored procedures above are the ones for the active users feature before it was changed.