Web Wiz Support and Community Forums : 7.6 - 7.9 SQL updates https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 09 Apr 2026 03:05:19 +0000 Tue, 21 Sep 2004 08:37:24 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=11870 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[7.6 - 7.9 SQL updates : yes those stored procedures above...]]> https://forums.webwiz.net/7-6-7-9-sql-updates_topic11870_post65921.html#65921 Author: dj air
Subject: 11870
Posted: 21 September 2004 at 8:37am

yes those stored procedures above are the ones for the active users feature before it was changed.]]> Tue, 21 Sep 2004 08:37:24 +0000 https://forums.webwiz.net/7-6-7-9-sql-updates_topic11870_post65921.html#65921 <![CDATA[7.6 - 7.9 SQL updates : The version I have running on...]]> https://forums.webwiz.net/7-6-7-9-sql-updates_topic11870_post65791.html#65791 Author: dudboy
Subject: 11870
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

]]> Mon, 20 Sep 2004 09:02:07 +0000 https://forums.webwiz.net/7-6-7-9-sql-updates_topic11870_post65791.html#65791 <![CDATA[7.6 - 7.9 SQL updates : you need to look around . but...]]> https://forums.webwiz.net/7-6-7-9-sql-updates_topic11870_post65785.html#65785 Author: dj air
Subject: 11870
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 hasbeen done (don't think so)

i think it is just uplaod new .asp files .
]]> Mon, 20 Sep 2004 08:40:28 +0000 https://forums.webwiz.net/7-6-7-9-sql-updates_topic11870_post65785.html#65785 <![CDATA[7.6 - 7.9 SQL updates : I read in the documentation that...]]> https://forums.webwiz.net/7-6-7-9-sql-updates_topic11870_post65783.html#65783 Author: dudboy
Subject: 11870
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

 

]]> Mon, 20 Sep 2004 08:34:10 +0000 https://forums.webwiz.net/7-6-7-9-sql-updates_topic11870_post65783.html#65783