SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: User x already has more than 'max_user_connections' active connections in

  1. #1
    SitePoint Member
    Join Date
    May 2003
    Location
    Indonesia
    Posts
    15
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    User x already has more than 'max_user_connections' active connections in

    Hi,

    Yesterday, my website is inaccessible. The error prompts:

    Warning: mysql_connect() [function.mysql-connect]: User x already has more than 'max_user_connections' active connections in /home/musicast/public_html/libs/adodb/drivers/adodb-mysql.inc.php on line 364
    Fatal error: Call to a member function GetAll() on a non-object in /home/musicast/public_html/modules/frontend.php on line 26

    The hosting not so helpful support told that the user had too many connection and have to look into the script the cause of this and close that connection.

    I'm using ADODb connect function to connect to database, not the persistent one, and my assumption it's automatically close when the queries are finish.

    I also try the Close() function but it didn't work.

    Would someone help me solve this problem?

    Thank you.

  2. #2
    Hosting Advisor silver trophybronze trophy
    SitePoint Award Recipient cpradio's Avatar
    Join Date
    Jun 2002
    Location
    Ohio
    Posts
    2,797
    Mentioned
    44 Post(s)
    Tagged
    0 Thread(s)
    From some searching it is my understanding that your host will need to kill the current connections that are still sitting there open. Once that is accomplished, add the close() function and run a few tests. Then have your host check to see if any connections were still left open, as if they are the close() did nothing to resolve the issue.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •