Announcement

Collapse
No announcement yet.

Mysql error--- Please help...

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

  • Mysql error--- Please help...

    I get this error when I visit my forum. Any suggestions?

    ---------------------------------
    Database error in vBulletin 2.2.6:
    Invalid SQL: SELECT COUNT(*) AS posts FROM post
    mysql error: Can't open file: 'post.MYD'. (errno: 145)
    mysql error number: 1016
    Date: Saturday 01st of February 2003 06:32:55 PM
    Script: http://www.rapbattles.com/forum/forum/
    ---------------------------------

    Thanks.

  • #2
    Run the following query in phpMyAdmin:

    REPAIR TABLE post;

    Comment


    • #3
      Hi Cary,

      Thanks for your response. However my oblivious nature finds this task a lot more complicated then it actually is. As guessed this is my first time using phpmyadmin.

      My situation is--- I am currently in phpmyadmin, and have the database open. With all the of the vB tables located on the right side. I clicked the "post" link. But from here I am a bit confused on where to go from here; Please help Cary or anyone else.

      Thanks in advance.

      Comment


      • #4
        Click on the SQL tab at the top of the page, then copy-n-paste Cary's query in this box.
        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


        • #5
          Steve,

          I tried that earlier and continue to receive the following error

          Error
          SQL-query :
          SHOW FIELDS FROM `post` FROM `rapbattl_forum`
          MySQL said:

          Can't open file: 'post.MYD'. (errno: 145)
          Thanks nonetheless. Anything else I can try?

          Comment


          • #6
            I you tried that earlier you would have gotten some result displayed. What was it?
            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


            • #7
              Same thing.

              Anyone who can repair this, let me know. I'll gladly pay.

              Kind regards,
              -Mike

              Comment


              • #8
                Fill out a support ticket at:

                http://www.vbulletin.com/members/support_form.php

                Be sure to include the login info to your Admin CP and phpMyAdmin.
                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...
                X