Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - a very sick forum !!
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

a very sick forum !!

 Post Reply Post Reply
Author
racekites View Drop Down
Newbie
Newbie


Joined: 18 November 2004
Status: Offline
Points: 33
Post Options Post Options   Thanks (0) Thanks(0)   Quote racekites Quote  Post ReplyReply Direct Link To This Post Topic: a very sick forum !!
    Posted: 12 April 2007 at 10:31am

Hey guys

been running webwiz for years now, running on SQLServer.

However the db server went down and the databases have been restored onto a new machine.

Its now running and i've updated the connection strings, however the forum is still very broken.

Nothing has changed in terms of code, just the location of the db.. (as far as i'm aware)

http://www.racekites.com/forum/default.asp

Its not picking up the variables for the stylesheet, and am getting loads of errors all over the place..

when openening a forum and geting the following :

Microsoft VBScript runtime error '800a000b'

Division by zero

/forum/forum_topics.asp, line 447

which is :

'Count the number of pages for the topics using FIX so that we get the whole number and  not any fractions
    intTotalRecordsPages = FIX(intTotalRecords / intTopicPerPage)


Please help !!

Cry

Cheers
A




Edited by racekites - 12 April 2007 at 10:38am
Back to Top
racekites View Drop Down
Newbie
Newbie


Joined: 18 November 2004
Status: Offline
Points: 33
Post Options Post Options   Thanks (0) Thanks(0)   Quote racekites Quote  Post ReplyReply Direct Link To This Post Posted: 12 April 2007 at 10:37am

update :

it looks like includes are not working... ??

the files are present however variables are not being given values ...??

tis very strange...


Back to Top
racekites View Drop Down
Newbie
Newbie


Joined: 18 November 2004
Status: Offline
Points: 33
Post Options Post Options   Thanks (0) Thanks(0)   Quote racekites Quote  Post ReplyReply Direct Link To This Post Posted: 12 April 2007 at 11:47am

update :

okay looks like i may have found the issue.

when calling getForumConfigurationData() found in global_variables_inc.asp it appears that the condition :

If isEmpty(Application(strAppPrefix & "blnConfigurationSet")) OR isNull(Application(strAppPrefix & "blnConfigurationSet")) OR Application(strAppPrefix & "blnConfigurationSet") = false OR blnUseApplicationVariables = false Then

is set to true, therefore the configuration data is not being populated.

have added a line :

Application(strAppPrefix & "blnConfigurationSet") = False

Which seems to have fixed lots of issues !!


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: 12 April 2007 at 1:44pm
The problem was that you tried to run the forum before it was connected to the database so the cached database quires didn't work.

Change the part back to how it was originally and if it happens again just go to the skin configuration page in the admin area and submit the page forcing the form to re-cache the quires.
Back to Top
racekites View Drop Down
Newbie
Newbie


Joined: 18 November 2004
Status: Offline
Points: 33
Post Options Post Options   Thanks (0) Thanks(0)   Quote racekites Quote  Post ReplyReply Direct Link To This Post Posted: 12 April 2007 at 1:55pm

Hi b

the db connection was up and running, i wrote a test page querying the db which worked fine. It appears that some values were cached in IIS hence the Application object being true.

looks like its working now...

thank you !!

Tongue


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.