Issue with 9.55
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=27035
Printed Date: 02 April 2026 at 8:34pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Issue with 9.55
Posted By: Hozza
Subject: Issue with 9.55
Date Posted: 24 February 2009 at 10:04pm
|
Hi,
Just uploaded new version 9.55, from 8.02
 all has gone really well, including the DB upgrade, but unfortunately when I try and enter one of the forums I get the following error. Microsoft VBScript runtime error '800a01f4'
Variable is undefined: 'blnSqlSvrAdvPaging' /forum_topics.asp, line 422 So i thought I bet its the upgraded DB, but I get the same on the default one too.Any idea's?
Thx
Paul
|
Replies:
Posted By: Hozza
Date Posted: 24 February 2009 at 10:06pm
|
oh so you can see for yourselve's here my sight....
http://www.gunshotwound.co.uk" rel="no follow - www.gunshotwound.co.uk
|
Posted By: WebWiz-Bruce
Date Posted: 25 February 2009 at 9:59am
|
Looks like your site is working now, but if it is not then it could be a corrupted file so try reuploading all the files again as this is a scripting error rather than a database 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: Hozza
Date Posted: 25 February 2009 at 11:54am
|
Thanks for having a look, but as far as I can see, the website is working perfectly, except for the sub-forums and some of the weblinks, which are still getting this error. I have, as you said, re-downloaded the forum package and uploaded the new package, but this has made no difference unfortunately. Could it be a hosting issue as I have just moved provider? If so, what might be missing from the server, so I can address enquires to them..
Thank you for your time and help in this matter,
Paul
|
Posted By: WebWiz-Bruce
Date Posted: 25 February 2009 at 12:08pm
|
The error means that a variable 'blnSqlSvrAdvPaging' is not declared within the software. This variable is declared in the file database/database_connection.asp. Make sure that you are running the latest version of this file and not using an database_connection.asp file from a previous release. At a guess I would say that you have tried to use a database/database_connection.asp file from your old version so that you don't need to re-type in your database connection details into this file. This file was updated in newer releases to add in advanced paging for SQL Server and mySQL which uses the new variable 'blnSqlSvrAdvPaging' which is declared in this 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: 123Simples
Date Posted: 25 February 2009 at 2:39pm
|
Your running on fasthosts - have you checked which version of SQL server they are running? Web Wiz Forums comes with 4 different options SQL Server 2005/2008 Version mySQL Version SQL Server 2000 Version and Access Version If fasthosts are running SQL 2000 and you uploaded the 2005/2008 version this could cause similar issues I expect ------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: Hozza
Date Posted: 25 February 2009 at 6:23pm
Talk about hitting the nail on the head, bad lazy Hozza 
Well thank you for your advice and it WORKED
 |