SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    May 2003
    Location
    Indonesia
    Posts
    18
    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 Team Leader silver trophybronze trophy
    cpradio's Avatar
    Join Date
    Jun 2002
    Location
    Ohio
    Posts
    5,161
    Mentioned
    152 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
  •