| Author |  Topic  | 
              
                | HelenaStarting Member
 
 
 
                Spain21 Posts
 | 
                    
                      |  Posted - 22 December 2002 :  13:24:31   
 |  
                      | Now is even worse: 
 "internal server error"
 "/foro/inc_header.asp, line 117"
 
 In my inc_header.asp in line 117 there are ....
 
 set my_Conn = Server.CreateObject("ADODB.Connection")
 my_Conn.Open strConnString
 |  
                      |  |  | 
              
                | OneWayMuleDev. Team Member & Support Moderator
 
      
 
                Austria4969 Posts
 |  | 
              
                | HelenaStarting Member
 
 
 
                Spain21 Posts
 | 
                    
                      |  Posted - 22 December 2002 :  13:30:20   
 |  
                      | Nop, I did not changes. 
 I was testing forums, the fact is i was tryin' to load forums since another machine to test it using another user (normal user).
 
 
  |  
                      |  |  | 
              
                | HelenaStarting Member
 
 
 
                Spain21 Posts
 | 
                    
                      |  Posted - 22 December 2002 :  17:37:42   
 |  
                      | OK, what i've observed is: 
 If i access de forums without login everything works ok
 If I access the forums loged as normal user everything's ok too
 
 but when I access as moderator or administrator pages are created in no less than 27 secconds. It happens in any page, specially in default.asp and active.asp. The rest of pages sometimes load fastly and sometimes very slow.
 
 If there's more than a moderator seems the server finally do not accept more connections and finally give an internal server error in inc_header.asp in line 117 which try to open my_Conn again.
 After a few minutes without activity can work again but if i contiue as moderator the problem comes again.
 
 If i access de forums as normal user again everything turns ok
 
 I've the private messages mod turned off
 I've have active users turned on
 
 Any ideas?
 
 thanks a lot
 
 p.d. lot of thanks for your help, OneWayMule
  |  
                      |  |  | 
              
                | OneWayMuleDev. Team Member & Support Moderator
 
      
 
                Austria4969 Posts
 |  | 
              
                | HelenaStarting Member
 
 
 
                Spain21 Posts
 | 
                    
                      |  Posted - 22 December 2002 :  18:29:59   
 |  
                      | Hi again, OneWayMule  
 ops, yes searching in those files to see if i find an unclosed recordset finally at the last of the page I added :
 
 my_Conn.close
 set my_Conn= nothing
 
 thinkin' maybe was this what was unclosed. But I obtain this error you comment
 
 
 quote:Microsoft VBScript runtime error '800a01a8'
 
 Object required
 
 /foro/active_users.asp, line 692
 
 so, it doesn't work
  i must change this again.
 
 I've been looking for unclosed recordsets in all these files (inc_header.asp, default.asp, inc_func_common.asp, active.asp, active_users.asp) and found all well closed.
 
 The strange thing is that it seems it only happens to me
  
 Ah, the more smilies MOD does not work with the data base.
 Specially seems that the problem is when there's an access to data base.
 The more smilies MOD work basically with javascript and only use asp to upgrade the files when I add new smilies to its folder rewritting and running more smilies set up.
 The changes i made to this MOD was only make it work with reponse.write, like the rest of the forum code. I do not think this MOD can be the problem. It must be araund active users or private messages. Anyway the strange is that only occurs in my forum.
 
 
  I'll keep you informed about my progress! 
 Thanks again (and sorry for my horrible english
  ) |  
                      |  |  | 
              
                | OneWayMuleDev. Team Member & Support Moderator
 
      
 
                Austria4969 Posts
 |  | 
              
                
                |  Topic  |  |