Web Wiz Support and Community Forums : "Active Topics" error https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 15 Apr 2026 22:50:33 +0000 Tue, 25 Oct 2005 05:55:58 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=16975 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA["Active Topics" error : My earlier post about the similar...]]> https://forums.webwiz.net/active-topics-error_topic16975_post92686.html#92686 Author: kiklop
Subject: 16975
Posted: 25 October 2005 at 5:55am

My earlier post about the similar post isn't on line.
However, just to notify you that I used your suggestion boRg, and changed acive_topic.asp page

(" & strDbTable & "Topic.Last_entry_date > " &strDatabaseDateFunction & " - " & Replace(dblActiveFrom,",",".") & "))"

This replace function has corrected the bug of messagess posted today not being displayed.

Thank you for the hint.
]]> Tue, 25 Oct 2005 05:55:58 +0000 https://forums.webwiz.net/active-topics-error_topic16975_post92686.html#92686 <![CDATA["Active Topics" error : It seems that this is a problem...]]> https://forums.webwiz.net/active-topics-error_topic16975_post92641.html#92641 Author: WebWiz-Bruce
Subject: 16975
Posted: 24 October 2005 at 12:47pm

It seems that this is a problem with locale settings on the server andaffects those locales that use a comma (,) instead of a dot (.) indecimal numbers.

This can be fixed by doing the following:-

Change line 295 in this:
 
 strSQL = "EXECUTE " & strDbProc & "ActiveTopics@dblActiveFrom = " & Replace(CStr(dblActiveFrom),",",".") & ",@AuthorID = " & lngLoggedInUserID & ", @GroupID = " &intGroupID & ", @GroupPerm = " & intForumGroupPermission
]]> Mon, 24 Oct 2005 12:47:28 +0000 https://forums.webwiz.net/active-topics-error_topic16975_post92641.html#92641 <![CDATA["Active Topics" error : What should I do? I replace all...]]> https://forums.webwiz.net/active-topics-error_topic16975_post92563.html#92563 Author: fx5500
Subject: 16975
Posted: 22 October 2005 at 3:21pm

 What should I do? I replace all the files and it happens all times. No matter if you are a member or guest.]]> Sat, 22 Oct 2005 15:21:19 +0000 https://forums.webwiz.net/active-topics-error_topic16975_post92563.html#92563 <![CDATA["Active Topics" error : I had a similar problem. I wrote...]]> https://forums.webwiz.net/active-topics-error_topic16975_post92535.html#92535 Author: Ritchie
Subject: 16975
Posted: 21 October 2005 at 5:38pm

I had a similar problem. I wrote about it here:
 
 
It Is solved very simply: it is necessary in a file active_topics.asp for a line 68 ('Session. LCID = 1033) to replace on (Session. LCID = 1033)Wink
]]> Fri, 21 Oct 2005 17:38:53 +0000 https://forums.webwiz.net/active-topics-error_topic16975_post92535.html#92535 <![CDATA["Active Topics" error : Hi. I upgrade from 7.92. Yes...]]> https://forums.webwiz.net/active-topics-error_topic16975_post92531.html#92531 Author: fx5500
Subject: 16975
Posted: 21 October 2005 at 2:20pm

 Hi.
 I upgrade from 7.92. Yes Its happenning all times. No matter if you are a member or a guests. Yes I updated all files.
]]> Fri, 21 Oct 2005 14:20:24 +0000 https://forums.webwiz.net/active-topics-error_topic16975_post92531.html#92531 <![CDATA["Active Topics" error : Some one else reported this error,...]]> https://forums.webwiz.net/active-topics-error_topic16975_post92517.html#92517 Author: WebWiz-Bruce
Subject: 16975
Posted: 21 October 2005 at 10:02am

Some one else reported this error, but I have not been able to replicate it on any machine.

Could you give more details so I can try and replicate it to work out what the problem is.

When does it happen?
Does it happen all the time?
Have you updated the page active_topics.asp with that in the latest version?
What version have you upgraded from?
If you replace all the .asp file with that from the latest version do you still get the error?
]]> Fri, 21 Oct 2005 10:02:25 +0000 https://forums.webwiz.net/active-topics-error_topic16975_post92517.html#92517 <![CDATA["Active Topics" error : Hi. I upgrade my site to 7.95...]]> https://forums.webwiz.net/active-topics-error_topic16975_post92493.html#92493 Author: fx5500
Subject: 16975
Posted: 20 October 2005 at 7:49pm

  Hi.
  I upgrade my site to 7.95 in today.(Its on MSSQL). When I click to "Active Topics" button , there is an  error code. Its below...
 
---------------------------------------
Microsoft OLE DB Provider for SQL Server error '80040e14'

Must pass parameter number 2 and subsequent parameters as '@name = value'. After the form '@name = value' has been used, all subsequent parameters must be passed in the form '@name = value'.

/forum/active_topics.asp, line 312

---------------------------------------
  What should I do?
]]> Thu, 20 Oct 2005 19:49:09 +0000 https://forums.webwiz.net/active-topics-error_topic16975_post92493.html#92493