Announcement

Collapse
No announcement yet.

Database error in vBulletin 4.2.2

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

  • Database error in vBulletin 4.2.2

    Receiving thousands of errors through mails, after sometime site is loading properly what will be error. how can i clear it
    ​Database error in vBulletin :

    mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    /home/xxxx/public_html/forums/includes/class_core.php on line 317

    MySQL Error :
    Error Number :
    Request Date : Friday, November 22nd 2013 @ 10:15:08 AM
    Error Date : Friday, November 22nd 2013 @ 10:15:08 AM
    Script : www.xxx.com
    Referrer : www.xxx.com
    IP Address :
    Username :
    Classname : vB_Database
    MySQL Version :








  • #2
    what PHP & mySQL are you on?. also what is the error number would help.
    Simple Straight Forward EU cPanel vBulletin Web Hosting Provider.

    Comment


    • #3
      Hi thanks for extending your hands to help me.

      PHP Version 5.2.17
      MySql version is MySQL 5.0.96

      MySQL Error & Error Number was empty only.

      Comment


      • #4
        if you look at source of web page it should show you the error number, and you also need to upgrade PHP to 5.3.**
        Simple Straight Forward EU cPanel vBulletin Web Hosting Provider.

        Comment


        • #5
          Ok. thanks for your suggestion, sure will try upgrading and see whether the problem persists.

          Comment


          • #6
            "Can't connect to local MySQL server"

            It's a server issue, you need to speak to your host about this.
            MARK.B | vBULLETIN SUPPORT

            TalkNewsUK - My vBulletin 5.5.2 Demo
            AdminAmmo - My Cloud Demo

            Comment


            • #7
              Yeah i talked with them. They don't know how to solve this issue. They asked me how to reproduced the error again. I said i don't know. But after getting the error i again reported to them. But they don't know how to solve this issue.

              Now asked them to upgrade php version and waiting.

              Comment


              • #8
                Originally posted by WEBDosser View Post
                if you look at source of web page it should show you the error number, and you also need to upgrade PHP to 5.3.**
                next time when i am receiving the error i will look it and update here.

                Comment


                • #9
                  It's definitely the server. I'm not sure why they are looking at upgrading php, it's nothing to do with that.

                  If you've got a host that's baffled by a "Can't connect to local MySQL server" error then it's probably time to look for a new host.
                  MARK.B | vBULLETIN SUPPORT

                  TalkNewsUK - My vBulletin 5.5.2 Demo
                  AdminAmmo - My Cloud Demo

                  Comment


                  • #10
                    I have a doubt, in my config.php file i have the following

                    $config['MasterServer']['servername'] = 'localhost';
                    $config['MasterServer']['port'] = 3306;

                    Is this is correct? or do i need to change to the IP addresses for MySQL connection.

                    Comment


                    • #11
                      Originally posted by coolbreeze86 View Post
                      I have a doubt, in my config.php file i have the following

                      $config['MasterServer']['servername'] = 'localhost';
                      $config['MasterServer']['port'] = 3306;

                      Is this is correct? or do i need to change to the IP addresses for MySQL connection.
                      You'd have to ask your host this, but if it was working before it's unlikely to have changed.

                      There really isn't much we can advise here....as stated, it's a server error, not a vBulletin error.....you need to speak to your hosts.
                      MARK.B | vBULLETIN SUPPORT

                      TalkNewsUK - My vBulletin 5.5.2 Demo
                      AdminAmmo - My Cloud Demo

                      Comment


                      • #12
                        Originally posted by coolbreeze86 View Post
                        Hi thanks for extending your hands to help me.
                        PHP Version 5.2.17
                        I thought 4.2.2 was an upgrade for PHP 4 something or other..
                        It goes higher?

                        Genuine question..


                        Comment


                        • #13
                          Originally posted by DemOnstar View Post

                          I thought 4.2.2 was an upgrade for PHP 4 something or other..
                          It goes higher?

                          Genuine question..
                          4.2.2 adds php 5.4 compatibility to vB4. It doesn't mean that ONLY php 5.4 will work.
                          MARK.B | vBULLETIN SUPPORT

                          TalkNewsUK - My vBulletin 5.5.2 Demo
                          AdminAmmo - My Cloud Demo

                          Comment


                          • #14
                            hi,
                            Here is my.cnf files

                            Code:
                            [mysqld]
                            skip-networking
                            log-slow-queries
                            safe-show-database
                            local-infile = 0
                            
                            connect_timeout=35
                            interactive_timeout=100
                            join_buffer_size=1M
                            key_buffer=16M
                            max_connections=500
                            max_delayed_threads=5
                            max_tmp_tables=4
                            myisam_sort_buffer_size=64M
                            query_cache_limit=1M
                            query_cache_size=16M
                            query_cache_type=1
                            read_buffer_size=1M
                            read_rnd_buffer_size=1M
                            sort_buffer_size=1M
                            table_cache=256
                            thread_cache_size=44
                            thread_concurrency=2
                            tmp_table_size=16M
                            wait_timeout=10800
                            max_allowed_packet=64M
                            open_files_limit=7480
                            
                            #datadir=/usr/local/mysql/data
                            socket=/var/lib/mysql/mysql.sock
                            
                            [mysql.server]
                            #user=mysql
                            #basedir=/usr/local/mysql
                            
                            [client]
                            #socket=/var/lib/mysql/mysql.sock
                            Is the commented last 4 lines need to be uncommented. I had read this in one of the posts. Whether this may solve the following error.
                            mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
                            /home/xxxx/public_html/forums/includes/class_core.php on line 317

                            Comment


                            • #15
                              Hi

                              This is not something vBulletin can support you with. We are not server configuration experts.

                              You need to speak to your host about this problem.
                              MARK.B | vBULLETIN SUPPORT

                              TalkNewsUK - My vBulletin 5.5.2 Demo
                              AdminAmmo - My Cloud Demo

                              Comment

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