'ROW_NUMBER' 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=27393
Printed Date: 29 March 2026 at 4:24am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: 'ROW_NUMBER' Error
Posted By: Kendiala
Subject: 'ROW_NUMBER' Error
Date Posted: 20 May 2009 at 6:18pm
|
I just installed to free version of Web Wiz Forums to test it before recommending it to a client to buy for her site. The application installed so easily and I think the member API thing is going to be just what we need.
Unfortunately, trying to use it hasn't been so complication free. When clicking on a forum to read or post in it, or when when clicking on the New Posts, http://www.makeyourcosmetics.com/forum/active_topics.asp?UA=Y" rel="nofollow - Un-Answered Topics , or Member List links - and possibly more, but those are the only ones I've checked so far - I get a version of the following error:
An error has occurred while executing SQL query on database. Please contact the forum administrator. Support Error Code:- err_SQLServer_get_active_topics File Name:- active_topics.asp Error details:- Microsoft OLE DB Provider for SQL Server 'ROW_NUMBER' is not a recognized function name. Each of the file names is different, obiously, but it all boils down to 'ROW_NUMBER' is not a recognized function name. How can this be fixed, please? I searched the boards here before posting, but I don't see any previous reference to this.
Thanks.
|
Replies:
Posted By: Kendiala
Date Posted: 20 May 2009 at 6:24pm
| Never mind! Apparently I didn't search well enough. I just found what I'm looking for in another post. |
Posted By: cmv
Date Posted: 22 May 2009 at 10:46am
|
hi @ all,
found the WebWiz forum software recently, just checking it out on a machine running SQL2K ... and fell into the same trap ...
since this post shows up in search first i thought it might be useful to post the detail:
file \database\database_connection.asp line 135 -> change to Const blnSqlSvrAdvPaging = FALSE
regards, christian ------------- and remember: a CRAY is the only computer that runs an endless loop in just four hours ... |
Posted By: 123Simples
Date Posted: 22 May 2009 at 1:46pm
Thanks for making the post Christian and welcome to Web Wiz Forums  ------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
cmv wrote:Posted By: cmv
Date Posted: 22 May 2009 at 5:57pm
|
thanks for the warm welcome,
let me say i've been quite surprised to find a forum app written in classic ASP what is still under that level of maintenance.
i wonder why it didn't hit my desk formerly (i.e. several years ago) when i searched and found only Snitz more or less ...
i'm just walking through the files how to best personalize it (without screwing it up regarding further updates) and must say i'm quite impressed, also about the database design.
christian
ps: sorry if the question is already covered (you notice, sometimes i miss the important lines ...) - is there a SVN somewhere?
edit: while trying to upload the avatar (as .png) unhandled exception: Permission denied /functions/functions_upload.asp, line 716 (what seems to differ from the downloaded code .... CreateFolder failed?) ------------- and remember: a CRAY is the only computer that runs an endless loop in just four hours ... |
Posted By: 123Simples
Date Posted: 22 May 2009 at 6:37pm
What does SVN stand for?  as I'm not that knowledgeable on abbreviations LOL
------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: cmv
Date Posted: 22 May 2009 at 11:19pm
|
SVN = http://en.wikipedia.org/wiki/Subversion_%28software%29" rel="nofollow - SubVersioN ;-) ------------- and remember: a CRAY is the only computer that runs an endless loop in just four hours ... |