Print Page | Close Window

"Active Topics" 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=16975
Printed Date: 16 April 2026 at 2:22am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: "Active Topics" error
Posted By: fx5500
Subject: "Active Topics" error
Date 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?



Replies:
Posted By: WebWiz-Bruce
Date 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?


-------------
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: fx5500
Date 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.


Posted By: Ritchie
Date Posted: 21 October 2005 at 5:38pm
I had a similar problem. I wrote about it here:
 
http://forums.webwiz.net/forum_posts.asp?TID=16951&PN=1&TPN=2 - http://forums.webwiz.net/forum_posts.asp?TID=16951&PN=1&TPN=2
 
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


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


Posted By: WebWiz-Bruce
Date Posted: 24 October 2005 at 12:47pm
It seems that this is a problem with locale settings on the server and affects those locales that use a comma (,) instead of a dot (.) in decimal 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


-------------
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: kiklop
Date 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.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net