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

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Bug Reports (Closed)
 v3.3 BUG+FIX cint in admin_count.asp
 Forum Locked  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

pweighill
Junior Member

United Kingdom
453 Posts

Posted - 06 January 2002 :  04:48:14  Show Profile
In admin_count.asp the following code needs the cint changing to a clng
	'## Forum_SQL - Write total number of users to Totals table
strSql = " UPDATE " & strTablePrefix & "TOTALS "
strSql = strSql & " SET U_COUNT = " & cint(RS("Countof"))



HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 06 January 2002 :  05:50:14  Show Profile  Visit HuwR's Homepage
I have removed your other posts, as they are the same thing just a different place. You refered to the chkUser4 function and the pop_delete file.

basically, anywhere that cInt is used on a table_id field it should be changed to cLng

Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 06 January 2002 :  13:24:36  Show Profile
what is the reason for changing cInt to cLng ?
Go to Top of Page

pweighill
Junior Member

United Kingdom
453 Posts

Posted - 06 January 2002 :  14:33:07  Show Profile
quote:
what is the reason for changing cInt to cLng ?


cint only works for numbers upto 32768

Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 08 January 2002 :  22:10:41  Show Profile
So we want to change all instances of cInt to cLng ?

so far I have only made the 1 change in admin_count.asp as noted above.
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 09 January 2002 :  04:11:36  Show Profile
I think yes, at least for all database ID's. There have been a couple support threads in the past where busy forums exceeded 32K posts and had problems.

We have another 12K posts here, I think. :)


======
Doug G
======
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 09 January 2002 :  04:52:31  Show Profile
the REPLY_ID here is getting close to 92000, TOPIC_ID just went over 20000 not too long ago.
Go to Top of Page

pweighill
Junior Member

United Kingdom
453 Posts

Posted - 09 January 2002 :  10:32:37  Show Profile
quote:

So we want to change all instances of cInt to cLng ?

so far I have only made the 1 change in admin_count.asp as noted above.



Look at chkUser4 function in inc_functions.asp
and also in the pop_delete.asp file.

Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 28 January 2002 :  17:31:49  Show Profile
ok, fixed in v3.4
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000 Version 3.4.07