"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)
 |
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. |