Error message on new install
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=27262
Printed Date: 02 April 2026 at 7:08pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Error message on new install
Posted By: Rusty Stumps
Subject: Error message on new install
Date Posted: 15 April 2009 at 7:26pm
|
I'm receiving the following error message when I click on a sub-forum area:
Server Error in Forum Application
An error has occurred while executing SQL query on database. Please contact the forum administrator. Support Error Code:- err_SQLServer_get_topics_data File Name:- forum_topics.asp Error details:- Microsoft OLE DB Provider for SQL Server 'ROW_NUMBER' is not a recognized function name. All other functions seem to work OK. I've done a good deal of Admin work and the database checks out. I've even successfully uploaded my client list into the Forum system.
PS: I just downloaded the SQL 2000 version which is what I thought I downloaded before. This error comes from the code for SQL 2005 and above. "ROW_COUNT" is not in SQL 2000.
I did a BEYOND COMPARE analysis of both the first download and the SQL 2000 specific download and all the files are identical including the forum_topics.asp. So, it looks like someone possibly overwrote the SQL 2000 version with the SQL 2005 version.  ------------- Thanks, Walg |
Replies:
Posted By: Scotty32
Date Posted: 16 April 2009 at 11:48am
|
As far as Im aware, all of the different database versions are exactly the same. Its just that they are pre-configured for that database, mostly in the "database/database.asp" file (i forget the exact name now, but in that folder). Make sure that this file is set correctly. One other difference I believe between MSSQL 2000 and MSSQL 2005 is in the forum_topics.asp file, there is something to select the max records. For this particular issue, I suspect it maybe that you have Advanced Paging on, again check your database.asp file to check this is turned off if you are running a MSSQL 2000 database. ------------- S2H.co.uk - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum . |
Posted By: WebWiz-Bruce
Date Posted: 16 April 2009 at 11:55am
|
Scotty32 is quite right about you not having the right version. You are getting this error because you have downloaded the SQL Server 2005/2008 version when you have the SQL Server 2000 version. You need to download the SQL Server 2000 version and swap the database/database_connection.asp file with the one from that version. All of the files are the same between the database versions, only the database/database_connection.asp file is different. ------------- 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: Rusty Stumps
Date Posted: 16 April 2009 at 3:46pm
|
Sorry fellas, you did NOT read my PS that was added to the original post. I went back and downloaded the SQL 2000 verision. I expanded it in a new directory and did a BEYOND COMPARE between the two sets of files. They are the SAME. There are no differences between the first set of files I downloaded, which I knew was the SQL 2000 version and the second set which I KNOW are the SQL 2000 version.
What it looks like is either the SQL 2000 version has been overwritten by the SQL 2005 version or the link is pointing to the wrong file.
I specifically went to the screen with the SQL 2000 button and click on that for the second download.
The error is because there is SQL 2005+ code in the file. The function ROW_NUMBER() is not available in SQL 2000. But if I'm downloading the SQL 2000 version, like I know I am, then why is that code in there? It's in both sets of files I downloaded. ------------- Thanks, Walg |
Posted By: Scotty32
Date Posted: 16 April 2009 at 4:27pm
|
I did read that you downloaded it and compared the files, which is why I said the only difference was the "database/database_connection.asp" file. All other files are the exact same, but the SQL statements will be generated differently based on the settings you choose in the above file. All each version does, is pre-configures the database_connection.asp file for each database type. I've just downloaded SQL 2000 version my self, and it looks perfectly fine to me. the part that activates the ROW_NUMBER() is:
As I said earlier, this needed to be disabled for 2000, which it is in the file i just downloaded. So you would need to check that the version you are running has this disabled (set to false). ------------- S2H.co.uk - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum . |
Posted By: WebWiz-Bruce
Date Posted: 16 April 2009 at 4:28pm
|
Sorry Rusty, but you did not read my reply in regards to ALL the files being the same. Please read back through my previous post that informs you about the differences between the different database versions which are setup in the database/database_connection.asp file. All the other files are the same in the forum, the only difference between the SQL Server 2005/2008 code and the SQL Server 2000 code is one variable setting in the database/database_connection.asp file. ------------- 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: Rusty Stumps
Date Posted: 16 April 2009 at 4:35pm
|
Sorry, Bruce, I also lost my workstation hard drive this morning and have not been able to do a successful restore from the backup from last night. Total frustration all around. I am writing this on my Server. I will look at the connection file and swap it out.
But, BEYOND COMPARE showed no difference between the files. Also, the file name is exactly the same. Is that correct? ------------- Thanks, Walg |
Posted By: Rusty Stumps
Date Posted: 16 April 2009 at 4:50pm
|
Bruce, Thanks, it's fixed now. Sorry for the frustration but as I explained I had a few other issues going and have production I need to do with that workstation. [groan]
Walt ------------- Thanks, Walg |
Posted By: WebWiz-Bruce
Date Posted: 16 April 2009 at 4:53pm
|
No problem just glad that it was sorted in the end.
------------- 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 |