Announcement

Collapse
No announcement yet.

MAJOR HELP NEEEDED Database Error

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

  • MAJOR HELP NEEEDED Database Error

    I want to know why I keep seeing when i load my forum i.e. only the index.php page there is a database error occurring sometimes, sometimes no page can be displayed and sometimes it works. I get an error to my email sayin fail to connect mysql error = 0 and this has just started happening recently and my server people say that the server is all functional and I have made no changes at all to my files.

    Can somebody please help

  • #2
    This error means that either:

    1) The db info in your config.php file is wrong (in which case your forums won't work at all.)

    2) That user doesn't have permission to access the database listed in config.php.

    3) The database doesn't exist.

    4) MySQL isn't accepting new connections. (The server could either be down or has reached it's maximum connections limit - either on the server level or user level.) If you are sure your config.php info is correct, then you will need to contact your host about this.

    Note, many servers are being probed for the phpBB worm these days and the MySQL server is being overloaded. This could account for these errors.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      Yeah the db info is all correct. How would i move servers, just ftp the files to the new server and then the db files to be put back into the new database and then change the config.php? thats all? cos its doesnt work it says db error

      Comment


      • #4
        Instructions for moving servers are in the online manual here:

        http://www.vbulletin.com/docs/html/moving_servers

        Note: The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. Please see the instructions here:

        Backup:
        http://www.vbulletin.com/docs/html/m...nce_ssh_backup

        Restore:
        http://www.vbulletin.com/docs/html/m...ce_ssh_restore

        This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          I have read thos but not helpful enough

          Comment


          • #6
            Hmmm...those are the best docs I can point to.
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment


            • #7
              only our new servers have ssh

              Comment


              • #8
                How big is your database? You could ask your host to make a backup for you.
                Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                Change CKEditor Colors to Match Style (for 4.1.4 and above)

                Steve Machol Photography


                Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                Comment


                • #9
                  70mb and we have a copy of it now but i stil need you to explain how to get the thing to load cos i have ftped the files and also restored the database but nothing

                  Comment


                  • #10
                    ????

                    Comment


                    • #11
                      MySQL isn't accepting new connections. (The server could either be down or has reached it's maximum connections limit - either on the server level or user level.)

                      Comment


                      • #12
                        Originally posted by SL No. 1
                        70mb and we have a copy of it now but i stil need you to explain how to get the thing to load cos i have ftped the files and also restored the database but nothing

                        what else do i need to do staff?

                        Comment


                        • #13
                          So are you getting the error 100% of the time now? Or just on-again off-again?

                          Comment


                          • #14
                            The answers are in posts #2 and #4. I'm not sure what else we can do. What's the latest info?
                            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                            Change CKEditor Colors to Match Style (for 4.1.4 and above)

                            Steve Machol Photography


                            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                            Comment


                            • #15
                              80%

                              Comment

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