Announcement

Collapse
No announcement yet.

To many connections

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

  • To many connections

    i get an error when i try to access my vbulletin board

    Warning: Too many connections in ./admin/db_mysql.php on line 38
    My FFXI Linkshell Website
    - http://www.stealthvertigo.com

  • #2
    You (or your host) needs to increase the value of max_connections for MySQL

    Comment


    • #3
      how would i go about doing that
      My FFXI Linkshell Website
      - http://www.stealthvertigo.com

      Comment


      • #4
        Are you running on a dedicated server where you can make changes? If so, create or edit your /etc/my.cnf file. If you are on a shared server, you need to have your host make the changes. You also might want to consider switching from using pconnects to connect (set in admin/config.php).

        Comment


        • #5
          where would the my.cnf file be
          My FFXI Linkshell Website
          - http://www.stealthvertigo.com

          Comment


          • #6
            In the /etc directory.

            John
            John Percival

            Artificial intelligence usually beats real stupidity ;)

            Comment


            • #7
              i dont have an etc directory
              My FFXI Linkshell Website
              - http://www.stealthvertigo.com

              Comment


              • #8
                You need to ask your hosting provider to change this value then (it's only available to those with 'root' access to the machine).

                Comment


                • #9
                  what is exactly happening cause this didnt happen before
                  My FFXI Linkshell Website
                  - http://www.stealthvertigo.com

                  Comment


                  • #10
                    oh and it syays this on line 38 where the erorr is
                    PHP Code:
                    $this->link_id=mysql_pconnect($this->server,$this->user,$this->password); 

                    heres lines 29-42
                    PHP Code:
                    if ( == $this->link_id ) {
                          if (
                    $this->password=="") {
                            if (
                    $usepconnect==1) {
                              
                    $this->link_id=mysql_pconnect($this->server,$this->user);
                            } else {
                              
                    $this->link_id=mysql_connect($this->server,$this->user);
                            }
                          } else {
                            if (
                    $usepconnect==0) {
                              
                    $this->link_id=mysql_pconnect($this->server,$this->user,$this->password);
                            } else {
                              
                    $this->link_id=mysql_connect($this->server,$this->user,$this->password);
                            }
                          } 
                    is there anything i need to change
                    My FFXI Linkshell Website
                    - http://www.stealthvertigo.com

                    Comment


                    • #11
                      i deleted thse lines and now it works

                      PHP Code:
                      $this->link_id=mysql_pconnect($this->server,$this->user);
                              } else { 
                      PHP Code:
                      $this->link_id=mysql_pconnect($this->server,$this->user,$this->password);
                              } else { 
                      My FFXI Linkshell Website
                      - http://www.stealthvertigo.com

                      Comment

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