Announcement

Collapse
No announcement yet.

slight problem with the database...

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

  • slight problem with the database...

    I woke up this morning and found that my forums give this error:

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

    and from the source I get:


    -----------------------------------------------------------------------------
    -----------------------------------------------------------------------------
    <!-- Database error in vBulletin 2.2.8:

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

    mysql error number: 1016

    Date: Friday 24th of January 2003 09:28:02 AM
    Script: http://www.jeeperos.com/foros/foros/
    Referer:
    -->
    -----------------------------------------------------------------------------
    -----------------------------------------------------------------------------

    Any help will be appreciated, I have no clue whats going on. Also tried to get into the /admin and wouldnt let me, gives the same error.

    thanks a lot!!

  • #2
    you have a corrupted table, you need to repair it via one of the following methods
    ===================
    1. via phpmyadmin

    using query

    REPAIR TABLE user;

    2. or 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

    3. or via myisamchk repair functions while mysql is shutdown/stopped in shell/telnet/ssh type :

    myisamchk -r -u root -p databasename

    option #3 most likely requires server and mysql root access to first stop mysql and then run myisamchk repair options.
    :: 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
      WOW thanks a lot for the fast answer Eva2000,

      Do you know if there is a manual for Dumbs on "HOW TO" do any of those? I dont have a clue how to use mysql or any other tool you mentioned before. Or know anyone who would do it for me? (even if I have to pay for it)

      again thanks a lot!

      Comment


      • #4
        BTW I have phpmyadmin and can log in, so if you could tell me a few steps on how to do it maybe I can tackle it?

        thanks again!!

        Comment


        • #5
          In the Querry space on phpMyAdmin I found this:


          ---------------------------------------------------------
          SQL-query :

          PMA_mysql_list_fields(

          vbulletin, user
          )

          MySQL said:


          Can't open file: 'user.MYD'. (errno: 145)
          ---------------------------------------------------------

          My database is : vbulletin

          So I just go to the

          Run SQL query/queries on database vbulletin [Documentation] :

          Square and type: REPAIR TABLE vbulletin

          is that right?

          thanks a lot!!
          "

          Comment


          • #6
            run query box type

            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


            • #7
              WOW! that did it!!


              thanks a lot!! I really mean it, you made my weekend!

              Comment


              • #8
                no probs
                :: 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

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