| Author |
 Topic Search  Topic Options
|
Rusty Stumps 
Newbie
Joined: 15 April 2009
Location: Fishers, Indian
Status: Offline
Points: 30
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Error message on new install
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. 
Edited by Rusty Stumps - 15 April 2009 at 10:29pm
|
 |
Scotty32
Moderator Group
Joined: 30 November 2002
Location: Manchester, UK
Status: Offline
Points: 1682
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
Rusty Stumps
Newbie
Joined: 15 April 2009
Location: Fishers, Indian
Status: Offline
Points: 30
|
Post Options
Thanks(0)
Quote Reply
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.
Edited by Rusty Stumps - 16 April 2009 at 4:04pm
|
|
Scotty32
Moderator Group
Joined: 30 November 2002
Location: Manchester, UK
Status: Offline
Points: 1682
|
Post Options
Thanks(0)
Quote Reply
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:
'*** Advanced Paging - Performance Boost ***
'Set this to true for advanced paging in SQL Server 2005/2008 and mySQL
'If you use SQL Server 2005/2008 or mySQL this will give a massive performance boost to your forum
Const blnSqlSvrAdvPaging = False |
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).
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
Rusty Stumps
Newbie
Joined: 15 April 2009
Location: Fishers, Indian
Status: Offline
Points: 30
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
Rusty Stumps
Newbie
Joined: 15 April 2009
Location: Fishers, Indian
Status: Offline
Points: 30
|
Post Options
Thanks(0)
Quote Reply
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
|
|
