| Author |
 Topic  |
|
putimeswebmaster
New Member
67 Posts |
 Posted - 12 June 2002 : 00:50:31
|
Same error:
Microsoft VBScript runtime error '800a01c2'
Wrong number of arguments or invalid property assignment: 'chkForumAccess'
/forum/active_smk.asp, line 360
I have exactly:
' Does user have access to the forum??
if cLng(Forum_ID) <> cLng(currForum) then
testAllow = chkForumAccess(Forum_ID,MemberID,false)
end if
if testAllow then
Pop Up Times Webmaster
http://www.popuptimes.com |
 |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 12 June 2002 : 03:13:55
|
Instuctions there look like they may have been for a slightly different version of the forums, try replacing it with this instead
' Does user have access to the forum??
if cLng(Forum_ID) <> cLng(currForum) then
testAllow = chkForumAccess(Forum_ID,MemberID)
end if
if testAllow then
Basically I've just removed the ,false from the testallow line.
www.daoc-halo.com |
|
|
|
putimeswebmaster
New Member
67 Posts |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 12 June 2002 : 09:12:50
|
Your welcome 
www.daoc-halo.com |
|
|
|
putimeswebmaster
New Member
67 Posts |
Posted - 12 June 2002 : 10:08:24
|
Do you know of similar performance enhancements to fourm.asp and topic.asp?
Pop Up Times Webmaster
http://www.popuptimes.com |
|
|
|
putimeswebmaster
New Member
67 Posts |
Posted - 12 June 2002 : 15:37:21
|
After making the changes to active.asp, my host still reports 53,646 database transactions in a 10 minute window. There were probably 500 pages views in that time frame, most of them topic.asp, then forum.asp.
That would be 107 transactions per page view.
My host (Interland) is going to shut me down unless I migrate
to a dedicated DB server which I cannot afford.
Steve
Pop Up Times Webmaster
http://www.popuptimes.com |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 12 June 2002 : 17:19:32
|
That's just a sorry excuse. Maybe you should look for a host that won't impose those restrictions...
I'm sure the query numbers will come down sharply with 3.4, but don't know how soon it will come out.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 12 June 2002 : 17:44:57
|
you could try turning off things like subscription/moderations etc, but I would seriously consider looking for a new host
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 12 June 2002 : 18:18:35
|
I suspect there is a MOD that causes problems. Interland and Crystaltech, both premier hosting companies, have been having problems with busy snitz sites and have resorted to shutting down some sites. One 30gb/mo Snitz site on CrystalTech with SQL Server has changed to a different forum to stay online (and is happy with the change).
Not all forums seem to have these problems which is why I think there is a MOD somewhere that has a coding problem gobbling up CPU and database resources.
$0.02
======
Doug G
====== |
|
|
|
putimeswebmaster
New Member
67 Posts |
Posted - 12 June 2002 : 21:58:42
|
I have a smiley mod and the email random password mod.
No others.
Thanks for all the thought and effort everyone.
Pop Up Times Webmaster
http://www.popuptimes.com |
|
|
|
putimeswebmaster
New Member
67 Posts |
Posted - 12 June 2002 : 22:03:41
|
I cannot switch to another forum.
I have over 150,000 posts and that knowledge base is very valuable to our members.
Steve
Pop Up Times Webmaster
http://www.popuptimes.com |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 12 June 2002 : 23:24:29
|
Have you tried archiving some of your posts
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 16 June 2002 : 23:40:47
|
Ok, I started to have a look at this. Couldn't spend as much time with this as I'd like, but we can have some improvements with simple measures.
My test was done in my small forum, with few categories 5 and forums (13). For topic.asp, the only file I managed to have a look so far, logged in as admin, topic.asp generated 49 T-SQL calls plus 51 additional stored procs calls (cursor handling) (total 91).
A quick analysis led me to the conclusion that the greatest responsability for this number of calls derives from including inc_jump_to.asp in this file.
After removing the include to inc_jump_to.asp, the T-SQL query number came down to 17 and the TSQL + stored proc calls (35) came down to a total of 58.
The price to pay is bearable: you no longer have the drop-down box to jump to ther forums at the bottom of the page.
To remove the include of inc_jump_to.asp, around line 499, find:
<table width="100%">
<tr>
<td align="center" valign="top" width="70%"><% Call PostingOptions() %></td>
<td align="center" valign="top" width="30%"><!--#INCLUDE FILE="inc_jump_to.asp" --></td>
</tr>
</table>
Just delete red part. You can also switch the values 70% and 30%. Where you have now 70%, put 30% and where you have 30% put 70%.
A similar thing can be done in forum.asp.
I can find a way to diminish the number of Db calls without removing inc_jump_to.asp, but I need more time and the reduction can be a bit minor.
This will save quite a number of calls to the DB. Typically two per each of your existing forums and one per existing category.
Let me know if you need additional help on this.
Hope this helps a bit. Better not have the drop down than lose the forum.
I'm also sorry if i couldn't put more time into this. I'll keep on trying. I believe I can remove 3 to 5 additional T-SQL statement calls from topic.asp. In fact I've already removed an extra call but it's a bit complicated to explain it here and now (it's getting a bit late).
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Edited by - ruirib on 16 June 2002 23:42:01 |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 17 June 2002 : 00:33:43
|
Remove many of the GetMemberID calls and replace them with MemberId to Ruirib that helps a lot also.
www.daoc-halo.com |
|
|
|
putimeswebmaster
New Member
67 Posts |
Posted - 17 June 2002 : 01:10:47
|
I have ~50,000 active posts, the rest are archived.
I will try ruirib's modification now.
Pop Up Times Webmaster
http://www.popuptimes.com |
|
|
|
Topic |
|
Topic Locked
