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: MOD Implementation
 Inactive Users: 'my_Conn.Execute' error		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

puzo
Junior Member

Israel
417 Posts
Posted - 05 June 2003 :  11:34:42  Show Profile  Visit puzo's Homepage
Hi,
I have two forums, one has 120 users and the other one has 11000 users (both are on two DB's, same mods except for Announcments mod and some other improvements on the 11000 one), problem is the VIP Forum (120 members) works ok but when i use the Regular forum's DB (11000 members) on the VIP (just to test the DB on the VIP's ASP files) it doesnt work, as a matter of fact it doesnt work at all unless i use the regular plain Snitz version (no mods, just as it comes on this site), when i put the Regular forum's DB on the modded forum it gives me this error:

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

--------------------------------------------------------------------------------

Technical Information (for support personnel)

Error Type:
Microsoft VBScript runtime (0x800A01FB)
An exception occurred: 'my_Conn.Execute'
/vipforum/inc_func_common.asp, line 178

It must be a problem with the DB because the VIP DB works fine on the Regular forum's files, what does this command (my_Conn.Execute) refer to?

Thanks,
Mike.

Edited by - ruirib on 05 June 2003 15:26:45

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 05 June 2003 :  13:18:18  Show Profile  Send ruirib a Yahoo! Message
It executes some SQL statement, quite likely.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

puzo
Junior Member

Israel
417 Posts
Posted - 05 June 2003 :  13:36:27  Show Profile  Visit puzo's Homepage
does it have to do with a mod iv'e installed?
how can i fix this?

Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 05 June 2003 :  15:11:59  Show Profile  Send ruirib a Yahoo! Message
I don't know if it does, but if you have installed a mod, maybe that is the cause. To fix it you need to determine what's causing it and if the statement is mod related you'd better tell us what mod is it and what is the statement (also the previous 5-10 lines should be shown).
I will move this to the Help: Mod Implementation forum if you confirm as soon as you confirm this is indeed a mod related issue.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

puzo
Junior Member

Israel
417 Posts
Posted - 05 June 2003 :  15:17:19  Show Profile  Visit puzo's Homepage
Yup, it's the inactive users mod alright, this is the entire sub:

sub deleteInactiveUsers()
  strAUTimedOut = DateToStr(DateAdd("n",-strAUTimeout,strForumTimeAdjust))
  strSql = "DELETE FROM " & strTablePrefix & "ACTIVE_USERS WHERE AU_LASTACTIVETIME < '" & strAUTimedOut & "'"
  my_conn.execute (strSql)
end sub


Ill try to fix it, ill check the Inactive users readme and ill remove all the modifications.

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.26 seconds. Powered By: Snitz Forums 2000 Version 3.4.07