Announcement

Collapse
No announcement yet.

MySQL Problems

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

  • MySQL Problems

    I recently upgraded to 2.2.2 and am now gettign this error.

    On the user level it shows:

    There seems to have been a slight problem with the GaminGuru 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.


    The email that it sends out contains:

    Database error in vBulletin 2.2.2:

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

    mysql error number: 1016

    Date: Saturday 09th of February 2002 10:19:27 AM
    Script: http://gaminguru.com/forums/
    Referer:

  • #2
    your user table is corrupted you need to do the following in this order

    1. close forum via vB admin panel
    2. upload repair.php from your vB zip file's extra's folder in the /admin directory and load it into your browser

    yourdomain.com/forums/admin/repair.php

    3. read repair.php page instructions in order to repair database
    :: Always Back Up Forum Database + Attachments BEFORE upgrading !
    :: Nginx SPDY SSL - World Flags Demo [video results]
    :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

    Comment


    • #3
      OK I'll upload the repair.php.

      Just about clsoing the forums... It gives em the smae error if I try to access admin cp.

      Comment


      • #4
        Ok sicne I can't access admin cp I jsut ftped the repair.php and ran it.

        It shows teh first page with instructiosn jsut fine. But if I try running it with any commands (ie: ...?check=1&iterations=4&forum=gamingur_vBull or ....html=1&check=1) it gives me the same error as I see everywhere else on teh forums.


        P.S. If you want to see for yourself, pm me and I'll give you the htaccess password.
        Last edited by okrogius; Sat 9 Feb '02, 6:34am.

        Comment


        • #5
          in that case you need to log into shell as root user and following instructions at http://i4net.tv/marticle/get.php?act...le&articleid=7

          or log into phpmyadmin for the vb database and run in the query box

          REPAIR TABLE user;
          :: Always Back Up Forum Database + Attachments BEFORE upgrading !
          :: Nginx SPDY SSL - World Flags Demo [video results]
          :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

          Comment


          • #6
            Originally posted by eva2000
            in that case you need to log into shell as root user and following instructions at http://i4net.tv/marticle/get.php?act...le&articleid=7

            or log into phpmyadmin for the vb database and run in the query box

            REPAIR TABLE user;

            Thanks, I tried the phpmyadmin quewry and it worked. Thanks a million.

            However, would you have any ideas where it woudl be cuased and any ideas to prevent it from reoccuring?

            Comment


            • #7
              Hmm jsut tried to psot a new thread and this is what i got...


              Database error in vBulletin 2.2.2:

              Invalid SQL: SELECT wordid,title FROM word WHERE title IN ('nothing','is','imposisble','database','fixed','this','shouldnt','occur','again','we','ap ologize','in','advance','for','the','inconvienice','posting','at','that','ugly','xmb','',' were','back','up','nothing','is','imposisble')
              mysql error: Can't open file: 'word.MYD'. (errno: 145)

              mysql error number: 1016

              Date: Saturday 09th of February 2002 10:49:18 AM
              Script: http://gaminguru.com/forums/newthread.php
              Referer: http://forums.gaminguru.com/newthrea...read&forumid=6

              Comment


              • #8
                HMm jsut tried again and it worked... [face_confused]

                Comment

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