Web Wiz Forums - Web Wiz Forums 7.51a FULL released

Print Page | Close Window

Web Wiz Forums 7.51a FULL released

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=6949
Printed Date: 04 April 2026 at 6:41am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Web Wiz Forums 7.51a FULL released

Posted By: WebWiz-Bruce
Subject: Web Wiz Forums 7.51a FULL released
Date 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.asp - 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.asp - http://www.webwiz.net/web_wiz_forums/forum_download.as p

-------------
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: WebWiz-Bruce
Date 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&PN=1 - 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

-------------
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: MadDog
Date Posted: 03 November 2003 at 10:39am

Cool!

Guess ill be busy updating my portal again

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

Posted By: Maverick
Date 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

Posted By: Maverick
Date 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

Posted By: Maverick
Date 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 - http://www.microsoft.com/sql/evaluation/trial/2000/download. asp

Cheers

Mav

Posted By: Maverick
Date 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

Posted By: wistex
Date 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!

-------------
http://www.wistex.com" rel="nofollow - WisTex Solutions
http://www.caribbeanchoice.com/forums" rel="nofollow - CaribbeanChoice Forums

Posted By: Tegwin
Date Posted: 05 November 2003 at 4:33pm

Maverick wrote:

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 - http://www.microsoft.com/sql/evaluation/trial/2000/download. asp

Cheers

Mav

If you want a free version of Enterprrise Manager equivilent check out this site, this is made in VB and you get the full source code.

http://www.asql.biz/DbaMgr/DownLoad2k.shtm - http://www.asql.biz/DbaMgr/DownLoad2k.shtm

-------------
If you dont want my peaches, dont shake my tree

Posted By: Buffer
Date Posted: 06 November 2003 at 2:11am

I am currently running 7.01 (MSAccess version) and would like an idiots guide on how to upgrade to latest forum version. I have access to MSAccess (version not quite sure) but unfortunately I have not actually used it yet.

Could you possibly e-mail some basic instructions.

Cheers and apologies

Buffer

Posted By: WebWiz-Bruce
Date Posted: 06 November 2003 at 3:51am

Follow the instructions in this topic, they couldn't be much plainer.

-------------
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: pedalcars
Date Posted: 06 November 2003 at 6:09am

(very, very!) minor fault:

register.asp - line 1363, column 154, add </a> to close hyperlink for email notify button.

This isn't closed otherwise, and you get a single blank space as part of the link after the button. If hyperlinks are underlined (as mine are), this becomes more obvious.

-------------
http://www.pedalcars.info/ - www.pedalcars.info

The most fun on four wheels

Posted By: WebWiz-Bruce
Date Posted: 06 November 2003 at 8:46am

Thanks I shall look into it.

-------------
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: steganos01
Date Posted: 06 November 2003 at 9:31am

I have this error when I try to see the forum I suscribe......
(I upade to the 7.51a version)

Microsoft VBScript runtime (0x800A01F4)
Variable is undefined: 'strTxtSubscribeToForum'
/email_notify_subscriptions.asp, line 354

Any can help?

PD:
I have to copy the file email_notif_subscriptiones.asp from the 7.5 version and work fine

Posted By: WebWiz-Bruce
Date Posted: 07 November 2003 at 2:58am

The language file has been updtaed, make sure you also upload the languge file that comes with version 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: huwnet
Date Posted: 07 November 2003 at 8:02am

Well done!

Posted By: DanVet
Date Posted: 07 November 2003 at 11:37am

Hi,

Is there a difference between versions 7.51 and 7.51a?

Thanks,

Dan.

Posted By: KyleL
Date Posted: 07 November 2003 at 5:58pm

-boRg- wrote:

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

There is your answer.

Posted By: DanVet
Date Posted: 08 November 2003 at 10:19am

Thanks KyleL - but that isn't my answer.

I'm wondering what the difference between 7.51 and 7.51a is. (not between 7.50 and 7.51a).

I think 7.51 was available for download for a matter of hours before becoming 7.51a.

I've upgraded 7.01 to 7.50 to 7.51 and I'd like to know if I now need to upgrade to 7.51a.

Cheers,

Dan.

Posted By: Maverick
Date Posted: 08 November 2003 at 10:23am

Yes you should, v7.51 's polling option does not work. I think 3 or 4 files were changed in 7.51a.

Try to make a poll and you'll get an error with version 7.51, fixed in 7.51a

Cheers

Posted By: WebWiz-Bruce
Date Posted: 08 November 2003 at 11:58am

This is taken from the Version Hiostory file that comes with the forum listing the changed files:-

Changes from version 7.51 to version 7.51a
------------------------------------------
1. poll_create_form.asp - fixed bug whereby new polls could not be created
2. email_messager.asp - fixed by wherby if you selected to have a copy sent to yourself they both went to the Recipient
3. forum_password_form.asp - fixed javascript focus bug
4. printer_friendly_posts.asp - fixed replace null bug if signature is null value

-------------
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: DanVet
Date Posted: 08 November 2003 at 12:31pm

Thanks.

So are these the only 4 files I need upload to my server? Or should I replace the whole lot?

By the way - you're not any relation to Alan Corkhill from Salisbury are you?

Posted By: WebWiz-Bruce
Date Posted: 08 November 2003 at 12:50pm

If you are running version 7.51 then only upload the 4 files listed.

No, I don't know anyone called Alan Corkhill.

-------------
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: wistex
Date Posted: 13 November 2003 at 12:17am

-boRg- wrote:

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

Note: If you have changed the following lines in common.asp and admin/common.asp:

'Set up the database table name prefix and stored procedure prefix
'(This is useful if you are running multiple forums from one database)
' - make sure you also change this in the msSQL_server_setup.asp file if setting up an ms SQL server database)
Const strDbTable = "wwf_tbl"
Const strDbProc = "wwf_Sp"

you will need to modify the above stored procedure to match.

You will get an error on the Active Topics page otherwise.

-------------
http://www.wistex.com" rel="nofollow - WisTex Solutions
http://www.caribbeanchoice.com/forums" rel="nofollow - CaribbeanChoice Forums

Posted By: Pfactor
Date Posted: 14 November 2003 at 6:31pm

Please, I need to have 10 forums

but everyone independent ... (pleople dont have to know that tere are more Forums...

Is possible with just 1 WebWizForum????

i dont have the place for 10 times WWF.. 15 Meg.

Thanks

Best Regards

Pfactor