Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - error when create new forum
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

error when create new forum

 Post Reply Post Reply
Author
dmaher View Drop Down
Newbie
Newbie


Joined: 11 July 2012
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote dmaher Quote  Post ReplyReply Direct Link To This Post Topic: error when create new forum
    Posted: 11 July 2012 at 1:38pm
I've upgraded to premium edition.

I can create a new forum ok, but when i go to forum here, i get the following error:

http://aimawards.org.uk/forum/forum_topics.asp?FID=1&title=first-forum - http://aimawards.org.uk/forum/forum_topics.asp?FID=1&title=first-forum

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
Forum Version:- 10.11

What is the issue?  I'm using SQL Server 2005.
Back to Top
dbramley View Drop Down
Groupie
Groupie


Joined: 24 April 2008
Status: Offline
Points: 118
Post Options Post Options   Thanks (0) Thanks(0)   Quote dbramley Quote  Post ReplyReply Direct Link To This Post Posted: 11 July 2012 at 1:49pm
You've not installed the SQL 2008 version have you?
Back to Top
dmaher View Drop Down
Newbie
Newbie


Joined: 11 July 2012
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote dmaher Quote  Post ReplyReply Direct Link To This Post Posted: 11 July 2012 at 2:46pm
The SQL2008 and SQL2005 versions seem to be the same to me?
Back to Top
dmaher View Drop Down
Newbie
Newbie


Joined: 11 July 2012
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote dmaher Quote  Post ReplyReply Direct Link To This Post Posted: 11 July 2012 at 3:43pm
Solved issue myself. Changed this in file called  /database/database_settings.asp  to false.

'*** 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
blnSqlSvrAdvPaging = false

This is not documented anywhere i can see so hope it helps someone.
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: 11 July 2012 at 4:28pm
The error means that you are either using SQL Server 2000 or if a later version of SQL Server then you have set the compatibility mode for the forums database to SQL Server 2000.

When you upgrade next make sure you select SQL Server 2000 as the database version so that the advanced paging variable (blnSqlSvrAdvPaging) is not set to True.
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.