URGENT Troubleshoot and resolve 500 Error (PHP) - Processes Hanging

Discussion in 'Programming' started by Dave4559, Jul 7, 2007.

  1. #1
    URGENT - Please reply if you can help immediatly, it may be only a very small issue - ie wrong permissions, but I don't know where to start! Quote an hourly rate which allows flexibility for size of issue! It may only be a small problem!

    I will surely need help in the future, so a good job will get repeat business.

    Please help, I have changed a standard script (index.php file and template.html file - I can tell you changes) and now it is causing database processes to hang and then after 25 process open, all of my sites go down and I get 500 errors! I use Hostgator as host and they do not allow more that 25 processes to be open.

    This was the thoughts of the live chat support at host gator:

    There is a 500 error checker in cpanel I ran it and came up with this as the main reason.
    Justyn: Warning : Dave is using ( 33 ) processes
    David: what does that mean?
    Justyn: One of your scripts is leaving database connections hanging. They are not closing, once you get over 25 you will start to get 500 errors.
     
    Dave4559, Jul 7, 2007 IP
  2. Scoding

    Scoding Well-Known Member

    Messages:
    1,091
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    155
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #2
    try to put db_close($db_variable)...
     
    Scoding, Jul 7, 2007 IP
  3. Dave4559

    Dave4559 Peon

    Messages:
    174
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #3
    Thanks all, have someone looking at it, so hopefully it will be fixed!
     
    Dave4559, Jul 7, 2007 IP
  4. SUSH

    SUSH Peon

    Messages:
    28
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #4
    Try mysql_close(); just before ?> tag.
    That should help. Although if your website's too high in traffic, start serving cache pages...
    Bye :)
     
    SUSH, Jul 8, 2007 IP