| Author |
 Topic Search  Topic Options
|
WebWiz-Bruce 
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
 Topic: Web Wiz Forums 7.51a FULL released
Posted: 03 November 2003 at 6:59am |
Web Wiz Forums version 7.51a FULL has now been released.
You can download this new version from:-
http://www.webwiz.net/web_wiz_forums/forum_download.as p
The new version includes improved security, bug fixes, including:-
- Security bug fixes
- Improved security
- Improved browser detection
- New version of Web Wiz Rich Text Editor 1.2a has been intergrated
- Bug fixes
If you are running an oldeer version you should upgrade today for the imporved security.
You can download this new version from:-
http://www.webwiz.net/web_wiz_forums/forum_download.as p
Edited by -boRg-
|
|
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Posted: 03 November 2003 at 7:03am |
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&a mp;a mp;a mp;PN=1
Upgrading Access Version 7.5 to 7.51a
Just replace the old files with the new ones keeping the same database
file.
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. 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-
|
|
|
|
MadDog
Mod Builder Group
Joined: 01 January 2002
Status: Offline
Points: 3008
|
Posted: 03 November 2003 at 10:39am |
Cool!
Guess ill be busy updating my portal again 
|
|
|
|
Maverick
Newbie
Joined: 12 July 2002
Location: Canada
Status: Offline
Points: 19
|
Posted: 03 November 2003 at 11:51am |
Hate to ask a silly question, how do you create the new stored procedure in the SQL Enterprise Manager? Lat time when I upgraded from an access to a SQL database you simply executed a .asp file.
If anyone could give me a brief run down on how to do this, I am using GearHosts as a SQL host as well.
Cheers and TIA
Mav
|
|
Maverick
Newbie
Joined: 12 July 2002
Location: Canada
Status: Offline
Points: 19
|
Posted: 03 November 2003 at 12:35pm |
Ok ....I'm sorry I asked that so quick I should have done a search first, now I have. But if you don't have a copy of SQL Enterprise, is there any other way to update to v7.51 from 7.5? Or is there any plans to make a .asp file to create a database file again?
Cheers
Mav
|
|
Maverick
Newbie
Joined: 12 July 2002
Location: Canada
Status: Offline
Points: 19
|
Posted: 03 November 2003 at 12:41pm |
Actually answered my own question, so anyone following this post with similar questions here is a free 30 day eval copy of EM
http://www.microsoft.com/sql/evaluation/trial/2000/download. asp
Cheers
Mav
|
|
Maverick
Newbie
Joined: 12 July 2002
Location: Canada
Status: Offline
Points: 19
|
Posted: 03 November 2003 at 3:41pm |
Hey did all the above in Enterprise Manager and now I get this error:
Microsoft OLE DB Provider for SQL Server error '80004005'
Invalid authorization specification
/common.asp, line 249
Any suggestions? I added that new stored proedure no prob but?????
Cheers
|
|
wistex
Mod Builder Group
Joined: 30 August 2003
Location: United States
Status: Offline
Points: 877
|
Posted: 03 November 2003 at 10:17pm |
Of course you would release 7.51 on November 3rd... the day AFTER I install 7.5! LOL I just installed 7.5 on the 2nd.
I guess I'll be upgrading again! 
|
|
|
|
Web Wiz Forums 7.51a FULL released
