Announcement

Collapse
No announcement yet.

Database error The database has encountered a problem.

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

  • [Forum] Database error The database has encountered a problem.

    Hello,

    I'm moving my vbulletin to another server and I have this error message. I checked "everything" and I'm not able to make it work, can you please suggest me some steps to do to solve this issue?
    Italian Body Building & Fitness : www.BodyWeb.com
    Italian unofficial support Forum : www.vBulletin.it

  • #2
    We need to know what the actual error message is.
    MARK.B | vBULLETIN SUPPORT

    TalkNewsUK - My vBulletin 5.5.4 Demo
    AdminAmmo - My Cloud Demo

    Comment


    • #3
      Hello, that was the actual message :
      Database error
      The database has encountered a problem.

      Please try the following:
      • Load the page again by clicking the Refresh button in your web browser.
      • Open the test.bodyweb.com home page, then try to open another page.
      • Click the Back button to try another link.
      The test.bodyweb.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
      We apologise for any inconvenience.

      PHP 5.5.12
      Mysql 5.1.73
      Italian Body Building & Fitness : www.BodyWeb.com
      Italian unofficial support Forum : www.vBulletin.it

      Comment


      • #4
        VB 4 is not compatible with PHP 5 but I doubt if that would cause your database error, that sort of error usually means your database doesn't exist. I take it the error is on your new server? Have you created a new database and imported the old one?

        Comment


        • #5
          Donald's advice is correct, but we still need to see the actual database error to know exactly what's going on. Check your server error logs. There will be a MySQL error of some sort.
          MARK.B | vBULLETIN SUPPORT

          TalkNewsUK - My vBulletin 5.5.4 Demo
          AdminAmmo - My Cloud Demo

          Comment


          • #6
            Not compatible with PHP5 ? OMG.

            Yes, of course I've created the database and imported, I can connect from the outside with a GUI administration program and I can see the database, tables, user and permission.
            Can you suggest me some commands to check from terminal line?
            Italian Body Building & Fitness : www.BodyWeb.com
            Italian unofficial support Forum : www.vBulletin.it

            Comment


            • #7
              Originally posted by Mark.B View Post
              Donald's advice is correct, but we still need to see the actual database error to know exactly what's going on. Check your server error logs. There will be a MySQL error of some sort.
              Ok, the log file seems normal, nothing strange.
              140526 02:51:31 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
              140526 02:51:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
              140526 2:51:31 InnoDB: Initializing buffer pool, size = 5.0G
              140526 2:51:31 InnoDB: Completed initialization of buffer pool
              140526 2:51:31 InnoDB: Started; log sequence number 0 2167852166
              140526 2:51:31 [Note] Event Scheduler: Loaded 0 events
              140526 2:51:31 [Note] /usr/libexec/mysqld: ready for connections.
              Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
              140526 3:12:33 [Note] /usr/libexec/mysqld: Normal shutdown
              Italian Body Building & Fitness : www.BodyWeb.com
              Italian unofficial support Forum : www.vBulletin.it

              Comment


              • #8
                Originally posted by Sergio68 View Post



                140526 3:12:33 [Note] /usr/libexec/mysqld: Normal shutdown
                Try restarting mysql

                Comment


                • #9
                  Originally posted by donald1234 View Post

                  Try restarting mysql
                  Done a thousand times, even apache. Did even now, nothing, same message.
                  What I need is probably a step by step guide to check every possible problem.

                  Is there a way to know exactly what kind of error is that one? "Database error" means no connection to database for which specific reason? User permission, host permission, wrong database, other?
                  Italian Body Building & Fitness : www.BodyWeb.com
                  Italian unofficial support Forum : www.vBulletin.it

                  Comment


                  • #10
                    No connection errors usually go something like unable to connect to database through socket blah blah or user xxx denied permision blah blah. That is either no database to connect to or the mysql server is down.

                    Comment


                    • #11
                      That's really weird? What can I check?
                      OS Centos 6.5 64bit, I could give more data and specification, but in private.
                      Italian Body Building & Fitness : www.BodyWeb.com
                      Italian unofficial support Forum : www.vBulletin.it

                      Comment


                      • #12
                        Try this from the command line

                        Code:
                         
                         service mysqld restart

                        Comment


                        • #13
                          If that doesn't work look at the error log here
                          Code:
                          /var/log/mysqld.log

                          Comment


                          • #14
                            Donald, we did that exact two things already, please check couple post over
                            Italian Body Building & Fitness : www.BodyWeb.com
                            Italian unofficial support Forum : www.vBulletin.it

                            Comment


                            • #15
                              What does it say following this command?

                              Code:
                              /etc/init.d/mysqld status

                              Comment

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