My Database is just like UGH......a SICK Puppy, PLEase Help

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • WoBber
    New Member
    • Dec 2001
    • 18

    My Database is just like UGH......a SICK Puppy, PLEase Help

    I haven't really had time to E-mail the proper person here at VBulletin to complain about the software because I am such a busy person, but now I seriously don't know what to do. My database has been down for over a week. I have restarted mySQL several times and ran all the combinations there are on the repair.php file, but still, everything I get is this:

    There seems to have been a slight problem with the World of Britney.com Forums database.
    Please try again by pressing the refresh button in your browser.

    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

    We apologise for any inconvenience.


    I can't even get into the Control Panel either.

    I E-mailed my host and this is what they said:

    All of your databases are still there. The last update to alot of the
    files was on July 18th. Are you sure that you page is actually connecting
    to the databases? Your threat databases are showing todays date about 5
    minutes ago and the search databases about an hour ago.

    Also, your databases are the only ones running so all of the status must
    be referring to your databases.


    So, I'm like going nuts here, I have over 3000 members and they are the biggest Britney Spears forums out there, part of my website World of Britney.com.

    Will somebody please help me? It took me a lot to pay for the license so I'd appreciate if someone from the staff could help me out asap? Thanks so much..

    http://www.wobforums.com is the URL of my forums.

    -Ruben
    World of Britney.com
  • Cary
    Senior Member
    • Apr 2002
    • 4433
    • 3.6.x

    #2
    "An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists." - What does the email say?

    Also, check the admin/config.php file to see if the correct database information is listed there.

    Comment

    • WoBber
      New Member
      • Dec 2001
      • 18

      #3
      No E-mail has been sent....nor received.

      Comment

      • SaintDog
        Senior Member
        • Nov 2001
        • 906
        • 3.5.x

        #4
        Post what errors the e-mail gives you here and maybe we can further help you . It could be something very simple or something much greater, the e-mails should show what is wrong.

        - SaintDog

        Comment

        • Jake Bunce
          Senior Member
          • Dec 2000
          • 46598
          • 3.6.x

          #5
          post the source code of the error page, that will have more details.

          //edit: duh, i just went to your site:


          <!-- Database error in vBulletin 2.2.6:

          Invalid SQL: SELECT COUNT(*) AS users,MAX(userid) AS max FROM user
          mysql error: Can't open file: 'user.MYD'. (errno: 126)

          mysql error number: 1016

          Date: Monday 22nd of July 2002 07:23:59 PM
          Script: http://www.wobforums.com/
          Referer: http://www.vbulletin.com/forum/showt...&postid=324410
          -->

          ok, now we need eva to translate the error

          Comment

          • Scott MacVicar
            Former vBulletin Developer
            • Dec 2000
            • 13286

            #6
            If you had read the thread at the top of this forum, entitled Dealing with Database Errors you would have found that you need to repair the table, the specific error code 126 means "Index file is crashed / Wrong file format"

            Try doing the following
            using mysqlcheck repair for 3.23.38 and above
            i.e. in shell/telnet/ssh type while mysql is running and forum is CLOSED:
            mysqlcheck -r -u mysqlusername -p databasename

            via myisamchk repair functions while mysql is shutdown/stopped in shell/telnet/ssh type :
            myisamchk -r -u root -p databasename
            Scott MacVicar

            My Blog | Twitter

            Comment

            • Cary
              Senior Member
              • Apr 2002
              • 4433
              • 3.6.x

              #7
              Originally posted by Jakeman
              post the source code of the error page, that will have more details.
              Wow.. I never knew that - I guess you learn something new everyday

              Comment

              • WoBber
                New Member
                • Dec 2001
                • 18

                #8
                <html><head><title>World of Britney.com Forums Database Error</title><style>P,BODY{FONT-FAMILY:tahoma,arial,sans-serif;FONT-SIZE:11px;}</style><body>

                <!-- Database error in vBulletin 2.2.6:

                Invalid SQL: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='4'
                mysql error: Can't open file: 'user.MYD'. (errno: 126)

                mysql error number: 1016

                Date: Monday 22nd of July 2002 08:20:24 PM
                Script: http://www.wobforums.com/
                Referer:
                -->

                </table></td></tr></table></form>
                <blockquote><p>&nbsp;</p><p><b>There seems to have been a slight problem with the World of Britney.com Forums database.</b><br>
                Please try again by pressing the <a href="javascript:window.location=window.location;">refresh</a> button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:[email protected]">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p></blockquote></body></head></html>


                There u go...

                Comment

                • WoBber
                  New Member
                  • Dec 2001
                  • 18

                  #9
                  Originally posted by PPN
                  If you had read the thread at the top of this forum, entitled Dealing with Database Errors you would have found that you need to repair the table, the specific error code 126 means "Index file is crashed / Wrong file format"

                  Try doing the following
                  using mysqlcheck repair for 3.23.38 and above
                  i.e. in shell/telnet/ssh type while mysql is running and forum is CLOSED:
                  mysqlcheck -r -u mysqlusername -p databasename

                  via myisamchk repair functions while mysql is shutdown/stopped in shell/telnet/ssh type :
                  myisamchk -r -u root -p databasename
                  Ok thanks, will do this but....how do I close the forum if I can't even get into the Control panel??

                  -Ruben

                  Comment

                  • Steve Machol
                    Former Customer Support Manager
                    • Jul 2000
                    • 154488

                    #10
                    Repair.php won't work on the user table. You need to run this query in phpMyAdmin or its equivalent:

                    REPAIR TABLE user;
                    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

                    • WoBber
                      New Member
                      • Dec 2001
                      • 18

                      #11
                      allright, that is good info, all I need to know now is how to close the forums without being able to access the control panel....

                      Comment

                      • Steve Machol
                        Former Customer Support Manager
                        • Jul 2000
                        • 154488

                        #12
                        I don't think you need to worry about closing it first since no one can access it anyway. I would make a backup of the database, then run the query.
                        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

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