Database error. My forum is down

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Cercle
    New Member
    • Apr 2007
    • 23
    • 3.6.x

    Database error. My forum is down

    Hi all

    I´m in troubles guys.

    My forum is down and i have the follow messages from vbulletin in my email box.


    Database error in vBulletin :

    mysqli_real_connect() [<a href='function.mysqli-real-connect'>function.mysqli-real-connect</a>]: (08004/1040): Too many connections
    /home/xxxxxx/public_html/forum/includes/class_core.php on line 1040

    MySQL Error :
    Error Number :
    Date : Thursday, December 20th 2007 @ 03:43:44 AM
    Script : http://www.xxxxxxxxxx.com/forum/index.php
    Referrer :
    IP Address : 213.60.226.202
    Username :
    Classname : vB_Database_MySQLi



    Database error in vBulletin :

    mysqli_real_connect() [<a href='function.mysqli-real-connect'>function.mysqli-real-connect</a>]: (08004/1040): Too many connections
    /home/xxxxxxx/public_html/forum/includes/class_core.php on line 1040

    MySQL Error :
    Error Number :
    Date : Thursday, December 20th 2007 @ 03:44:44 AM
    Script : http://www.xxxxxxxxxxx.com/forum/index.php
    Referrer :
    IP Address : 213.60.226.202
    Username :
    Classname : vB_Database_MySQLi


    Database error in vBulletin 3.6.5:

    Invalid SQL:

    SELECT *
    FROM vb_style
    WHERE (styleid = 1 AND userselect = 1)
    OR styleid = 14
    ORDER BY styleid ASC
    LIMIT 1;

    MySQL Error : MySQL server has gone away
    Error Number : 2006
    Date : Thursday, December 20th 2007 @ 03:46:27 AM
    Script : http://www.xxxxxxxxx.com/forum/cron.php?&rand=519706
    Referrer : http://xxxxxxxxxxx/forum/
    IP Address : 81.34.90.71
    Username :
    Classname : vB_Database_MySQLi


    Can anybody help me please?

    Thank you again
  • Boxy
    Senior Member
    • Oct 2002
    • 3139

    #2
    Too many connections: The server has maxed out the number of MySQL connections it allows. This is a server-wide limit, not just your forums. You can try turning persistent connections off in your config.php:

    $config['MasterServer']['usepconnect'] = 0;

    But if you still have problems after that, all you can do is ask your host to raise the maximum number of connections they allow. Here is more info on that error:


    Details and things to try regarding the second error, MySQL server has gone away can be found in this post: http://www.vbulletin.com/forum/showp...5&postcount=12

    Comment

    • Cercle
      New Member
      • Apr 2007
      • 23
      • 3.6.x

      #3
      Originally posted by Boxy
      Too many connections: The server has maxed out the number of MySQL connections it allows. This is a server-wide limit, not just your forums. You can try turning persistent connections off in your config.php:

      $config['MasterServer']['usepconnect'] = 0;

      But if you still have problems after that, all you can do is ask your host to raise the maximum number of connections they allow. Here is more info on that error:


      Details and things to try regarding the second error, MySQL server has gone away can be found in this post: http://www.vbulletin.com/forum/showp...5&postcount=12
      Thank you Boxy.

      $config['MasterServer']['usepconnect'] = 0; That was correct.

      I´m still having the same problem

      Comment

      • peterska2
        Senior Member
        • Oct 2003
        • 8869
        • 3.7.x

        #4
        If this has not resolved the issue you will need to contact your host to see if they can raise the number of connections permitted. Otherwise, you will need to consider moving to a different host where this will not be an issue.

        Comment

        • Cercle
          New Member
          • Apr 2007
          • 23
          • 3.6.x

          #5
          Originally posted by Kerry-Anne
          If this has not resolved the issue you will need to contact your host to see if they can raise the number of connections permitted. Otherwise, you will need to consider moving to a different host where this will not be an issue.
          Thank for your reply Kerry. That I´ll do.

          Comment

          • Cercle
            New Member
            • Apr 2007
            • 23
            • 3.6.x

            #6
            Thank you very much to the Vbulletin team. After a migration to a new server, all it works perfect now

            Comment

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