Announcement

Collapse
No announcement yet.

Mysql error, help needed urgently please.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Mysql error, help needed urgently please.

    Hi, I seem to have an error on my forums which have kept the whole site down for around 8 hours now.
    The error message I am getting in my email reports is as follows:

    mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User lee246_lee246 has already more than 'max_user_connections' active connections
    /home/lee246/public_html/forums/includes/class_core.php on line 271

    Any ideas of what the problem is?

    Thanks in advance.

  • #2
    Make sure pconnect is off in your includes/config.php file:

    Code:
    	//	****** MASTER DATABASE PERSISTENT CONNECTIONS ******
    	//	This option allows you to turn persistent connections to MySQL on or off.
    	//	The difference in performance is negligible for all but the largest boards.
    	//	If you are unsure what this should be, leave it off. (0 = off; 1 = on)
    $config['MasterServer']['usepconnect'] = 0;
    If this is currently set to 1 then changing it to 0 might help the problem. Otherwise you need to get your host to increase the connection limit.

    Comment


    • #3
      Thanks, I checked the config file and the value is already set to 0.
      I've also sent an email to my host.
      Is there nothing else I could try?
      Thanks.

      Comment


      • #4
        There is nothing more you can do. Your forum is hitting the connection limit of the database, and that is a server restriction.

        Comment


        • #5
          Ok thanks for your help Jake.

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X