Database error The database has encountered a problem.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Sergio68
    Senior Member
    • May 2002
    • 817
    • 6.0.X

    [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
  • Mark.B
    vBulletin Support
    • Feb 2004
    • 24286
    • 6.0.X

    #2
    We need to know what the actual error message is.
    MARK.B
    vBulletin Support
    ------------
    My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
    My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

    Comment

    • Sergio68
      Senior Member
      • May 2002
      • 817
      • 6.0.X

      #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

      • donald1234
        Senior Member
        • Oct 2011
        • 1953
        • 4.1.x

        #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

        • Mark.B
          vBulletin Support
          • Feb 2004
          • 24286
          • 6.0.X

          #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
          ------------
          My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
          My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

          Comment

          • Sergio68
            Senior Member
            • May 2002
            • 817
            • 6.0.X

            #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

            • Sergio68
              Senior Member
              • May 2002
              • 817
              • 6.0.X

              #7
              Originally posted by Mark.B
              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

              • donald1234
                Senior Member
                • Oct 2011
                • 1953
                • 4.1.x

                #8
                Originally posted by Sergio68



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

                Comment

                • Sergio68
                  Senior Member
                  • May 2002
                  • 817
                  • 6.0.X

                  #9
                  Originally posted by donald1234

                  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

                  • donald1234
                    Senior Member
                    • Oct 2011
                    • 1953
                    • 4.1.x

                    #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

                    • Sergio68
                      Senior Member
                      • May 2002
                      • 817
                      • 6.0.X

                      #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

                      • donald1234
                        Senior Member
                        • Oct 2011
                        • 1953
                        • 4.1.x

                        #12
                        Try this from the command line

                        Code:
                         
                         service mysqld restart

                        Comment

                        • donald1234
                          Senior Member
                          • Oct 2011
                          • 1953
                          • 4.1.x

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

                          Comment

                          • Sergio68
                            Senior Member
                            • May 2002
                            • 817
                            • 6.0.X

                            #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

                            • donald1234
                              Senior Member
                              • Oct 2011
                              • 1953
                              • 4.1.x

                              #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...