SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    May 2003
    0 Post(s)
    0 Thread(s)

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


    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/ 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
    152 Post(s)
    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.
    Be sure to congratulate Patche on earning July's Member of the Month
    Go ahead and blame me, I still won't lose any sleep over it
    My Blog | My Technical Notes


Posting Permissions

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