MySQL Error : Can't find file: './themdsco_mds/cms_navigation.frm'

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ascender
    Member
    • Feb 2007
    • 58

    [CMS] MySQL Error : Can't find file: './themdsco_mds/cms_navigation.frm'

    I've been sent some automatic vBulletin DB errors with the above subject line. I've repaired my DB tables via the AdminCP, but Google isn't giving me much more information than that.

    I've not made any changes recently, the above has just started happening.

    Any ideas as to what could be causing it or what I can do to resolve?

    Thanks!
  • Mr. Mikey
    Senior Member
    • Feb 2009
    • 187

    #2
    Unless vB4.0.7 is majorly different to vB4.0.4 (last one I looked at in depth) in file structure, that definitely isnt a vBulletin file.

    Run Maintenance -> Diagnostics -> Suspect File Versions and see if anything there is flagging up.
    My Forums: The Geek District - Off Topic Hut
    My Blog: Mikeylicious
    Projects: Shorten URL's with kwn.me

    Comment

    • Zachery
      Former vBulletin Support
      • Jul 2002
      • 59097

      #3
      That is a MySQL data file that is missing, IIRC FRM is the stucture of the table. Try repairing the table via the admincp if you can.

      Comment

      • ascender
        Member
        • Feb 2007
        • 58

        #4
        Its not flagged up as a suspicious file.

        Table checks out OK and is already up to date.

        Comment

        • Zachery
          Former vBulletin Support
          • Jul 2002
          • 59097

          #5
          Are you still getting mysql errors?

          Comment

          • ascender
            Member
            • Feb 2007
            • 58

            #6
            Yes, am now getting these for some reason.....

            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' (11)
            /home/themdsco/public_html/forums/includes/class_core.php on line 313

            Comment

            • Shamil.
              Senior Member
              • Feb 2008
              • 4755
              • 4.2.X

              #7
              Originally posted by ascender
              Yes, am now getting these for some reason.....

              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' (11)
              /home/themdsco/public_html/forums/includes/class_core.php on line 313
              You will need to consult your host to fix that error message. It looks likely that the server admin will need to increase max_connections in mysql.ini or my.cnf.
              Shamil Nunhuck, - Radon Systems Ltd.
              VPS + Dedicated Server Hosting and Management
              vBulletin Hosting and Services
              Server / Website Consultation

              Comment

              • Zachery
                Former vBulletin Support
                • Jul 2002
                • 59097

                #8
                Originally posted by Shamil.
                You will need to consult your host to fix that error message. It looks likely that the server admin will need to increase max_connections in mysql.ini or my.cnf.
                Not true, he'd get an error message about max_connections. This error indicates that mysql is down or otherwise unreacheable. Increasing the connections here will not fix the issue.

                Comment

                • Shamil.
                  Senior Member
                  • Feb 2008
                  • 4755
                  • 4.2.X

                  #9
                  Originally posted by Zachery
                  Not true, he'd get an error message about max_connections. This error indicates that mysql is down or otherwise unreacheable. Increasing the connections here will not fix the issue.
                  It seems to fix the issues on my servers.

                  wait_timeout might be another issue.
                  Shamil Nunhuck, - Radon Systems Ltd.
                  VPS + Dedicated Server Hosting and Management
                  vBulletin Hosting and Services
                  Server / Website Consultation

                  Comment

                  • Zachery
                    Former vBulletin Support
                    • Jul 2002
                    • 59097

                    #10
                    Originally posted by Shamil.
                    It seems to fix the issues on my servers.

                    wait_timeout might be another issue.
                    If I had to take a guess, restarting mysql after applying the change is what fixes it.

                    Can't connect means that it can't connect. MySQL is down, or otherwise unreachable, that is all the error means.

                    Comment

                    • Paul M
                      Former Lead Developer
                      vB.Com & vB.Org
                      • Sep 2004
                      • 9886

                      #11
                      Originally posted by Shamil.
                      It seems to fix the issues on my servers.

                      wait_timeout might be another issue.
                      The error means mysql is unreachable, generally because its down. Neither max connections or wait timeout will make any difference to that error.
                      Baby, I was born this way

                      Comment

                      • Shamil.
                        Senior Member
                        • Feb 2008
                        • 4755
                        • 4.2.X

                        #12
                        Originally posted by Zachery
                        If I had to take a guess, restarting mysql after applying the change is what fixes it.

                        Can't connect means that it can't connect. MySQL is down, or otherwise unreachable, that is all the error means.
                        Originally posted by Paul M
                        The error means mysql is unreachable, generally because its down. Neither max connections or wait timeout will make any difference to that error.
                        From what I've seen, the errors can happen sporadically, but two people clicking at the same time gives two outputs - one desired, one db error.
                        Shamil Nunhuck, - Radon Systems Ltd.
                        VPS + Dedicated Server Hosting and Management
                        vBulletin Hosting and Services
                        Server / Website Consultation

                        Comment

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