Announcement

Collapse
No announcement yet.

SQL Error

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

  • SQL Error

    I'm getting the following error on new messages. Forum has been running fine until a few days ago. I'm running 3.5.4. The messages are posting but I'm still getting the errors.

    Database error in vBulletin 3.5.4:

    Invalid SQL:

    INSERT INTO mailqueue
    (dateline, toemail, fromemail, subject, message, header)
    VALUES

    Lines Removed for Privacy

    MySQL Error : Can't open file: 'mailqueue.MYI'. (errno: 145)
    Error Number : 1016
    Date : Thursday, December 28th 2006 @ 12:12:44 AM
    Script : http://www.mysite.com/forum/newthread.php
    Referrer : http://www.mysite.com/forum/newthrea...=newthread&f=5
    IP Address : xx.xx.xx.xx
    Username : myuserid
    Classname : vb_database

    Thanks.

    Tim
    Please give us a visit at our Dog Forum

  • #2
    MySQL error: 145 = Table was marked as crashed and should be repaired

    This error means that table has crashed. To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

    Admin CP -> Import & Maintenance -> Repair/Optimize Tables -> Check All -> Continue

    If you cannot open your Admin CP then you can repair tables with 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


    • #3
      Thank you! I was having the same problem and this worked. I did have to run the repair procedure several times but it has fixed itself.

      Have you Beat Your Truck today?

      Comment


      • #4
        Originally posted by Steve Machol View Post
        If you cannot open your Admin CP then you can repair tables with phpMyAdmin.
        Where do I find phpMyAdmin???

        Comment


        • #5
          Check with your web host. Hopefully they have given you some kind of control panel for your site that gives you a phpMyAdmin option. I know that not all of them do, but mine does. With mine, you have to know some basic commands to make phpMyAdmin work (not entirely point and click).

          Do a google on phpMyAdmin and you can learn more about it.
          Have you Beat Your Truck today?

          Comment


          • #6
            Originally posted by Steve Machol View Post
            If you cannot open your Admin CP then you can repair tables with phpMyAdmin.
            How do we do this ?

            I know how to run sql querries

            what one do I run ?

            thanks

            btw, this is for a client and he was told this so far

            I tried this
            Code:
            REPAIR TABLE phrase;
            but it didn't fix it

            oops, and its for this error

            'phrase.MYI'
            Last edited by Loco.M; Tue 2nd Jan '07, 5:51pm.
            -- Web Developer for hire
            ---Online Marketing Tools and Articles

            Comment

            Loading...
            Working...
            X