34 users online (0 members and 34 guests)  


  Results 1 to 3 of 3

Related

  1. 500 internal server error    Forum: CGI Perl Forum
    Replies: 1
  2. Internal Server Error?    Forum: CGI Perl Forum
    Replies: 9
  3. Replies: 0
  4. Server error    Forum: ASP Forum
    Replies: 2
  1. #1
    Doorknob's Avatar
    Super Newbie

    Status
    Offline
    Join Date
    Jun 2002
    Location
    Malaysia
    Posts
    316

    server error. please help

    i have a page in an iframe (code below) that refreshes about once a minute. problem is, after a while (not sure exactly how long), it will give an error :

    Server Application Error
    The server has reached the maximum recovery limit for the application during the processing of your request. Please contact the server administrator for assistance

    looked thru the code (only a coupla lines) but cant find problem. your assistance is appretiated.

    **code starts**

    <%@ Language=VBScript %>
    <% Response.Buffer = true %>
    <!-- #INCLUDE FILE="inc/conn.inc" -->
    <html>
    <head>
    <title>Zero FC</title>
    <link href="css/std.css" rel="stylesheet">
    <meta http-equiv="Refresh" content="75;URL=bottom.asp">
    </head>
    <body>
    <table width='100%' height='100%' cellpadding=0 cellspacing=0>
    <tr><td width=130 height=40><img src='images/zeronuclear.jpg' height=35 width=92><img src='images/world.gif' height=33 width=33></td>
    <%
    set rsMatches = server.CreateObject("ADODB.Recordset")
    strSQL = "SELECT VisitorNo FROM History"
    rsMatches.Open strSQL,conn,3,1
    if not rsMatches.EOF then
    VisitorNo = rsMatches.Fields(0).Value
    Response.Write "<td width=80 align=center valign=middle>Total<br>Visitors </td><td width=70><table cellpadding=0 cellspacing=0><tr><td>"

    for i = 1 to len(VisitorNo)
    x = Mid(VisitorNo,i,1)
    Response.Write "<img src='images\c" & x & ".gif' height=21 width=16>"
    next
    Response.Write "</td></tr></table></td>"
    end if
    rsMatches.Close

    Response.Write "<td valign=middle align=center>Currently Online : <br>"

    x = 0
    Name = ""
    bNextLine = false
    strSQL = "SELECT PlayerID,UserName FROM Security WHERE Status='ONLINE'"
    rsMatches.Open strSQL,conn,3,1
    do while not rsMatches.EOF
    Name = rsMatches("UserName")
    if x = 0 or bNextLine = true then
    Response.Write "<a href='profile.asp?profileid=" & rsMatches("PlayerID") & "'>" & Name & "</a>"
    bNextLine = false
    else
    Response.Write ", <a href='profile.asp?profileid=" & rsMatches("PlayerID") & "'>" & Name & "</a>"
    end if
    if x = 5 then
    Response.Write "<br>"
    bNextLine = true
    x = -1
    end if
    x = x + 1
    rsMatches.MoveNext
    loop
    rsMatches.Close
    if Name = "" then Response.Write "None"
    set rsMatches = nothing
    set conn = nothing
    %></td>
    <td align=center width=200>
    Add <a href onClick="addbookmark();">Zero FC</a> to your Favourites<br>
    Set <a href onClick="this.style.behavior='url(#default#homepage)';this.setHomePage('http://www26.brinkster.com/zerofc/');">Zero FC</a> as default homepage
    </td>
    </tr>
    </table>
    </body>
    </html>

    **code ends**

  2. #2
    Zaire's Avatar
    Senior Member

    Status
    Offline
    Join Date
    Mar 2001
    Location
    Hamburg, NY
    Posts
    312
    I haven't used ASP in soo long, been so busy with sitemod, but I think I noticed something

    Code:
    for i = 1 to len(VisitorNo)

    This statement is never ended! Your error means that the script is taking too much time to execute, such as a loop that lasts forever.

  3. #3
    Doorknob's Avatar
    Super Newbie

    Status
    Offline
    Join Date
    Jun 2002
    Location
    Malaysia
    Posts
    316
    that's the funny thing, the page runs fine, but because it refreshes, if i leave it alone for a while (i'm guessing around 1/2 hour in which time it would have refreshed itself 30 times, this error msg comes out. *bangs head on keyboard*



Tags for this Thread