<?xml version="1.0" encoding="utf-8" ?>
<?xml-stylesheet type="text/xsl" href="RSS_xslt_style.asp" version="1.0" ?>
<rss version="2.0" xmlns:WebWizForums="https://syndication.webwiz.net/rss_namespace/">
 <channel>
  <title>Web Wiz Support and Community Forums : Active topic error</title>
  <link>https://forums.webwiz.net/</link>
  <description><![CDATA[This is an XML content feed of; Web Wiz Support and Community Forums : Web Wiz Forums : Active topic error]]></description>
  <copyright>Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved.</copyright>
  <pubDate>Sat, 04 Apr 2026 03:41:45 +0000</pubDate>
  <lastBuildDate>Thu, 06 Nov 2003 01:28:12 +0000</lastBuildDate>
  <docs>http://blogs.law.harvard.edu/tech/rss</docs>
  <generator>Web Wiz Forums 12.08</generator>
  <ttl>360</ttl>
  <WebWizForums:feedURL>https://forums.webwiz.net/RSS_post_feed.asp?TID=7034</WebWizForums:feedURL>
  <image>
   <title><![CDATA[Web Wiz Support and Community Forums]]></title>
   <url>https://forums.webwiz.net/forum_images/web_wiz_forums.png</url>
   <link>https://forums.webwiz.net/</link>
  </image>
  <item>
   <title><![CDATA[Active topic error : You need to go into Query analyzer...]]></title>
   <link>https://forums.webwiz.net/active-topic-error_topic7034_post35034.html#35034</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="https://forums.webwiz.net/member_profile.asp?PF=11563">dudboy</a><br /><strong>Subject:</strong> 7034<br /><strong>Posted:</strong> 06&nbsp;November&nbsp;2003 at 1:28am<br /><br /><P>You need to go into Query analyzer for SQL and run this script against your database</P><P>&nbsp;</P><P>CREATE PROCEDURE &#091;dbo&#093;.&#091;wwfSpActiveTopics&#093; (<BR>@AuthorID int,<BR>@GroupID int,<BR>@GroupPerm int,<BR>@dblActiveFrom datetime<BR><BR>)<BR>AS<BR>SELECT tblForum.Forum_name, tblForum.Password, tblForum.Forum_code, tblTopic.* <BR>FROM tblCategory, tblForum, tblTopic <BR>WHERE ((tblCategory.Cat_ID = tblForum.Cat_ID AND tblForum.Forum_ID = tblTopic.Forum_ID) AND (tblTopic.Last_entry_date &gt; GetDate() - @dblActiveFrom))<BR>&nbsp;AND (tblForum.&#091;Read&#093; &lt;= @GroupPerm OR (tblTopic.Forum_ID IN (<BR>&nbsp;&nbsp;&nbsp; SELECT tblPermissions.Forum_ID <BR>&nbsp;&nbsp;&nbsp; FROM tblPermissions <BR>&nbsp;&nbsp;&nbsp; WHERE tblPermissions.Author_ID = @AuthorID OR tblPermissions.Group_ID = @GroupID AND tblPermissions.&#091;Read&#093;=1))<BR>&nbsp;&nbsp;&nbsp; )<BR>ORDER BY tblCategory.Cat_order ASC, tblForum.Forum_Order ASC, tblTopic.Last_entry_date DESC;<BR>GO</P><P>&nbsp;</P><P>See here <A href="http://forums.webwiz.net/forum_posts.asp?TID=6950&amp;PN=1" target="_blank"> http://forums.webwiz.net/forum_posts.asp?TID=6950&a mp;a mp;PN=1</A></P><P>I have found that active topics still does not work correctly though even in the latest verion</P><span style="font-size:10px"><br /><br />Edited by dudboy</span>]]>
   </description>
   <pubDate>Thu, 06 Nov 2003 01:28:12 +0000</pubDate>
   <guid isPermaLink="true">https://forums.webwiz.net/active-topic-error_topic7034_post35034.html#35034</guid>
  </item> 
  <item>
   <title><![CDATA[Active topic error :      HEy guys, when I try...]]></title>
   <link>https://forums.webwiz.net/active-topic-error_topic7034_post35022.html#35022</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="https://forums.webwiz.net/member_profile.asp?PF=13382">Titan</a><br /><strong>Subject:</strong> 7034<br /><strong>Posted:</strong> 05&nbsp;November&nbsp;2003 at 10:20pm<br /><br /><TABLE cellSpacing=0 cellPadding=4 width="98%" align=center><T><T><TR><P>&nbsp;</P><TD><P><SPAN class=text>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.&nbsp;&nbsp;</SPAN></P><P><SPAN class=text></SPAN>&nbsp;</P></TD></></TR></T></T></TABLE><TABLE cellSpacing=0 cellPadding=1 width="98%" align=center bgColor=#006699><T><T><TR><TD><TABLE cellSpacing=0 cellPadding=0 width="100%" bgColor=#ffffff><T><T><TR><TD bgColor=#ffffff><TABLE height=14 cellSpacing=1 cellPadding=3 width="100%" bgColor=#ffffff><T><T><TR><TD class=ting width="3%" background=forum_images/table_bg_image.gif bgColor=#cccccc>&nbsp;</TD><TD class=ting width="41%" background=forum_images/table_bg_image.gif bgColor=#cccccc>Topics</TD><TD class=ting width="15%" background=forum_images/table_bg_image.gif bgColor=#cccccc>Topic Starter</TD><TD class=ting align=middle width="7%" background=forum_images/table_bg_image.gif bgColor=#cccccc>Replies</TD><TD class=ting align=middle width="7%" background=forum_images/table_bg_image.gif bgColor=#cccccc>Views</TD><TD class=ting align=middle width="29%" background=forum_images/table_bg_image.gif bgColor=#cccccc>Last Post</TD></TR><FONT face=Arial size=2><P>Microsoft OLE DB Provider for SQL Server</FONT><FONT face="Times New Roman"> </FONT><FONT face=Arial size=2>error '80040e14'</FONT><FONT face="Times New Roman"> </FONT><P><FONT face=Arial size=2>Could not find stored procedure 'wwfSpActiveTopics'.</FONT> <P><FONT face=Arial size=2>/forum/active_topics.asp</FONT><FONT face=Arial size=2>, line 293</FONT> </P><P>&nbsp;</P><P></P></T></TR></T></TR></T></P></T></TABLE></TD></T></TR></T></TABLE></TD></T></TR></T></TABLE><span style="font-size:10px"><br /><br />Edited by Titan</span>]]>
   </description>
   <pubDate>Wed, 05 Nov 2003 22:20:59 +0000</pubDate>
   <guid isPermaLink="true">https://forums.webwiz.net/active-topic-error_topic7034_post35022.html#35022</guid>
  </item> 
 </channel>
</rss>