Announcement

Collapse
No announcement yet.

MYSQL error

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

  • MYSQL error

    In preperation for an upgarde to 3.6 (curently running 3.5.3), I tried to run a database backup via SSH and received the following error:

    -- Server version 3.23.58
    mysqldump: Got error: 1103: Incorrect table name '.' when doing LOCK TABLES.


    Now my forum is down with the following error being displayed:

    There seems to have been a problem with the database.
    Please try again by clicking the Refresh button in your web browser.
    An E-Mail has been dispatched etc ....

    I can't acess my admin control panel any longer either ... so I can't run a repair from there.

    How can I fix?

    Thanks in advance!
    Regards,
    Keith
    www.veggiegogo.com

  • #2
    Not sure about the error backing up, but first of all, do not upgrade to 3.6.x with that version of MySQL. It doesn't meet the requirements for it, and I'm not sure if it still happens, but it used to be that if you even tried upgrading to it with that version, you'd run into some nasty things during the upgrade that would take alot work to fix.

    Secondly, right click on that database error page and copy and paste the info here.

    Comment


    • #3
      Thanks Kiwi - Do you mean copy from the website error? I copied the SSH error after attempting an MYSQLdump. But is there other data you are seeking?

      Thanks again
      Regards,
      Keith
      www.veggiegogo.com

      Comment


      • #4
        When the database error page comes up, right click and choose View Page Source. Copy that information here. That has the full error.

        Comment


        • #5
          Let us see your mysql command line query you use to do your backup. Leave the password out.
          Computer Help Forum
          An informed rider makes their first destination the motorcycle forum at rider info.

          Comment


          • #6
            Sure - Thanks ~ I'll do both:

            I used the command recommended on the Vbulletin manual for MYSQL backups/exports:
            mysqldump --opt -Q -u dbusername -p databasename > backupname.sql

            The view source page for my forum www.equineonthemind.com


            <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
            <html>
            <head>
            <title> Database Error</title>
            <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
            <style type="text/css">
            <!--
            blockquote { margin-top: 75px; }
            p { font: 11px tahoma, verdana, arial, sans-serif; }
            -->
            </style>
            </head>
            <body>
            <blockquote>
            <blockquote>
            <p><strong>There seems to have been a problem with the database.</strong><br />
            Please try again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</p>
            <p>An E-Mail has been dispatched to our <a href="
            Regards,
            Keith
            www.veggiegogo.com

            Comment


            • #7
              For future reference, right-click on the error page and go to View/Source. That will show the real database error message:

              mysql_connect(): Access denied for user: '[email protected]' (Using password: YES)
              /home/httpd/vhosts/equineonthemind.com/httpdocs/includes/class_core.php on line 279


              The most likely cause of this error is that the info in your config.php file is wrong or your db user does not have full permissions to this database. Please read this for all the known causes of this error:

              http://www.vbulletin.com/forum/showthread.php?t=194542
              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


              • #8
                Sorry Steve - For some reason when I copy and attemp to post the scource code it only shows a portion of what I'm trying to post.... Let me try something
                Last edited by keith77; Mon 24th Sep '07, 12:36am.
                Regards,
                Keith
                www.veggiegogo.com

                Comment


                • #9
                  Not sure why it won't allow me to post the full text, which is what happened earlier ... Here's the error portion of the source code - but the code appears to be missing the Error description and number. Also, I've never had an issue backing up the DB prior to this ... But this last back up appears to have crashed the DB.

                  <!--
                  Database error in vBulletin :
                  mysql_connect(): Access denied for user: '[email protected]' (Using password: YES)
                  /home/httpd/vhosts/equineonthemind.com/httpdocs/includes/class_core.php on line 279
                  MySQL Error :
                  Error Number :
                  Date : Monday, September 24th 2007 @ 01:21:17 AM
                  Script : http://www.equineonthemind.com/
                  Referrer :
                  IP Address : 81.153.70.115
                  Username :
                  Classname : vb_database
                  -->

                  Thanks guys,
                  Keith
                  Last edited by keith77; Mon 24th Sep '07, 12:39am.
                  Regards,
                  Keith
                  www.veggiegogo.com

                  Comment


                  • #10
                    Doh! ... Yes, I had indeed changed the DB password and haden't updated the config file .... Thanks so much everyone for assisting and for pointing me in the right direction - It's much appreciated.
                    Regards,
                    Keith
                    www.veggiegogo.com

                    Comment

                    Related Topics

                    Collapse

                    Working...
                    X