Web Wiz Forums - Active topic error

Print Page | Close Window

Active topic error

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

Topic: Active topic error

Posted By: Titan
Subject: Active topic error
Date Posted: 05 November 2003 at 10:20pm

HEy guys, when I try to check active topics i get the following error. I recently upgraded from 7.01 to 7.51a SQL vesrion.

Microsoft OLE DB Provider for SQL Server error '80040e14'

Could not find stored procedure 'wwfSpActiveTopics'.

/forum/active_topics.asp, line 293

Topics

Topic Starter

Replies

Views

Last Post

Replies:

Posted By: dudboy
Date Posted: 06 November 2003 at 1:28am

You need to go into Query analyzer for SQL and run this script against your database

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

See here http://forums.webwiz.net/forum_posts.asp?TID=6950&PN=1 - http://forums.webwiz.net/forum_posts.asp?TID=6950&a mp;a mp;PN=1

I have found that active topics still does not work correctly though even in the latest verion

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