Announcement

Collapse
No announcement yet.

Another mySQL DB Connection Limit Issue

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

  • lmgc
    replied
    I did'nt touch any file, config.php or any file !
    i will contact my hoster to see where is the problem.

    Thank's man

    Leave a comment:


  • Zachery
    replied
    Then check your config.php file like I suggested, this is NOT a bug with vBulletin.

    Leave a comment:


  • lmgc
    replied
    Sorry but i get these errors just few minutes after upgrading to 4.1.4 PL1 !

    Leave a comment:


  • Zachery
    replied
    That has nothing to do with vBulletin as a bug, and nothing to do with the original posters error message. If all of your information in your config file is 100% correct, you need to contact your webhost for help resolving the problem.

    Leave a comment:


  • lmgc
    replied
    Database error in vBulletin :

    mysql_connect() [<a
    href='function.mysql-connect'>function.mysql-connect</a>]: Unknown
    MySQL server host 'mysql.xxxxx.net' (2)
    /home/www/xxxxx/web/forum/includes/class_core.php on
    line 314

    MySQL Error :
    Error Number :
    Request Date : Tuesday, July 12th 2011 @ 05:30:31 PM
    Error Date : Tuesday, July 12th 2011 @ 05:30:54 PM
    Script :
    Referrer :
    IP Address : .195..216
    Username :
    Classname : vB_Database
    MySQL Version :

    Leave a comment:


  • Zachery
    replied
    What is the specific error message you're getting?

    Leave a comment:


  • lmgc
    replied
    Hello

    i have the same issue just after upgrading to v 4.1.4 PL1 !!
    with the past release (4.1.4) i did not have any mysql errors !

    is the probleme concerning this new PL ?

    Leave a comment:


  • Steve Machol
    replied
    This:

    mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User [username] already has more than 'max_user_connections' active connections/[location]/includes/class_core.php on line 314

    ...is a server issue. It is not a vB 'bug'.

    Leave a comment:


  • Zachery
    replied
    There is no vBulletin bug for this specific issue.

    Each user who connects to your site, for at least a second or two, must make at least 1 mysql connection to get the data.
    If you are limited to 10 connections, you might never get hit with the limit with only 10 users online. All 10 connections would have to be in use when an 11th connection starts. This would generate the error. This error is a MySQL error and vBulletin has no control over it. Your webhost is limiting your mysql resources.

    Leave a comment:


  • beishe8
    replied
    Originally posted by DrMarie View Post
    I think there may be a VB bug. When I first installed my forum I started to get these error messages and I only had 4 users! How can 4 users take up all of my database connections?
    Please check "Who's Online" :
    There are currently 969 users online. 55 members and 914 guests
    Most users ever online was 12,419, Sun 23rd May '10 at 10:46am.
    Maybe there are more than 4 users online.

    Leave a comment:


  • DrMarie
    replied
    I think there may be a VB bug. When I first installed my forum I started to get these error messages and I only had 4 users! How can 4 users take up all of my database connections? I'm guessing there is a missed mysql close or something somewhere in the code.

    Of course, it could be in the code in the rest of my site, but then why are so many people having this problem!

    Leave a comment:


  • weave
    replied
    Thanks Steve

    Leave a comment:


  • Steve Machol
    replied
    It depends on what that user is doing, but essentially 1 user = at least 1 connection used.

    Leave a comment:


  • weave
    replied
    Understood.

    So are we saying that in vBulletin, that 1 user = 1 MySQL connection? Does have the CMS add more to this? I am still not getting how you make SQL connections compared to PHPBB.

    Thanks

    Leave a comment:


  • Steve Machol
    replied
    I have no way of knowing what your host currently limits you to.

    Leave a comment:

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