Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Current Version (Old)
 HELP ** ADO 2.6 / SQL 2000
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

rbrown1962
Starting Member

USA
1 Posts

Posted - 06 December 2001 :  23:24:12  Show Profile
Today I updated my SQL server to the latest service pack for SQL server. Also ADO 2.6 was put on. Well since then my snitz is shot. The forms dont show correct colorings ,, and trying to access a forum catagory returned an error I did manage to debug down the page to the error line. The problem seems to be in the forum.asp file in this routine, around line 220 something

rs.open strSql, my_Conn, 3
if not (rs.EOF or rs.BOF) then
rs.movefirst
** THE CALL BELOW RETURNED AN ERROR
rs.pagesize = strPageSize
***********************************
maxpages = cint(rs.pagecount)
rs.absolutepage = mypage
end if

However when I remmed out the line, it did get into the forums, however I showed no previously posted messages where I know there was over 100.

Any IDEAS ??? If you would like to see this running in real time go to the following
http://67.164.196.182/HD

There will be a short flash player movie ,, then you can enter the site, and click on message Brd. Any help on this PLEASE PLEASE send me an email at Rbrown1962@home.com

Thanks



RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 06 December 2001 :  23:33:41  Show Profile
Try it now ( you should undo any changes that you made to forum.asp ).

Basically what happened is the Application Variables needed to be reloaded. You can do this by running setup.asp (that's what I did to fix your problem).
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.28 seconds. Powered By: Snitz Forums 2000 Version 3.4.07