Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - "Active Topics" error
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

"Active Topics" error
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
fx5500 View Drop Down
Groupie
Groupie
Avatar

Joined: 30 July 2005
Location: Turkey
Status: Offline
Points: 64 		Post Options Post Options   Thanks (0) Thanks(0)   Quote fx5500 Quote  Post ReplyReply Direct Link To This Post Topic: "Active Topics" error
    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?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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?
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
fx5500 View Drop Down
Groupie
Groupie
Avatar

Joined: 30 July 2005
Location: Turkey
Status: Offline
Points: 64 		Post Options Post Options   Thanks (0) Thanks(0)   Quote fx5500 Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Ritchie View Drop Down
Groupie
Groupie
Avatar

Joined: 14 June 2005
Location: Russian Federation
Status: Offline
Points: 91 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Ritchie Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
fx5500 View Drop Down
Groupie
Groupie
Avatar

Joined: 30 July 2005
Location: Turkey
Status: Offline
Points: 64 		Post Options Post Options   Thanks (0) Thanks(0)   Quote fx5500 Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
kiklop View Drop Down
Groupie
Groupie


Joined: 14 July 2005
Status: Offline
Points: 137 		Post Options Post Options   Thanks (0) Thanks(0)   Quote kiklop Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.