Announcement

Collapse
No announcement yet.

vbulletin error help

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

  • vbulletin error help

    ok i have been getting an attachment error;


    ftahisp4_attachmentCheckWarning: Table is marked as crashed and last repair failedftahisp4_attachmentCheckWarning: Size of indexfile is: 103424 Should be: 1024ftahisp4_attachmentCheckWarning: Size of datafile is: 1265711588 Should be: 1265711268ftahisp4_attachmentCheckError: Record-count is not ok; is 944 Should be: 0ftahisp4_attachmentCheckWarning: Found 949 parts Should be: 0 partsftahisp4_attachmentCheckError: Corruptftahisp4_attachment


    I tried running the database repair but that is what i get.......how can i fix this....

  • #2
    i also get this;

    Database error in vBulletin 3.6.9:
    Invalid SQL:
    SHOW CREATE TABLE ftahisp4_attachment;
    MySQL Error : Table './ftahisp4_ftahisp4/ftahisp4_attachment' is marked as crashed and last (automatic?) repair failed
    Error Number : 144
    Date : Monday, November 24th 2008 @ 12:14:06 PM
    Script : http://www.ftahispano.com/admincp/backup.php?do=sqlfile
    Referrer : http://www.ftahispano.com/admincp/backup.php?do=choose
    IP Address : 67.180.121.79
    Username : gentz
    Classname : vB_Database

    Comment


    • #3
      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 -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

      If you cannot access the Admin CP you can also use phpMyAdmin to repair tables.

      If that doesn't work then this may be too damaged to fix with the normal methods. Please check out this thread for other ways to repair a db, particularly items #2 and 3:

      http://www.vbulletin.com/forum/showt...threadid=44909

      You may have to ask your host to try and repair this for you.
      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


      • #4
        ok got that fixed now i get this;

        Database error in vBulletin 3.6.9:

        Invalid SQL:

        SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount, lastpostid
        , forumread.readtime AS forumread
        FROM ftahisp4_forum AS forum
        LEFT JOIN ftahisp4_forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 1);

        MySQL Error : Lost connection to MySQL server during query
        Error Number : 2013
        Date : Monday, November 24th 2008 @ 02:18:03 PM
        Script : http://www.ftahispano.com/
        Referrer :
        IP Address : 67.180.121.79
        Username : gentz

        Comment


        • #5
          This is a server issue. You need to contact your host about this. See this post for the possible causes of a lost connection error:

          http://www.vbulletin.com/forum/showt...265#post310265
          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