Announcement

Collapse
No announcement yet.

Just installed VB 3.03 and got this error (1016)

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

  • Just installed VB 3.03 and got this error (1016)

    Database error in vBulletin 3.0.3:
    Invalid SQL:
    SELECT
    IF(votenum >= 1, votenum, 0) AS votenum,
    IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
    post.pagetext AS preview,
    thread.threadid, thread.title AS threadtitle, lastpost, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
    lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach
    , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
    , NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid,
    deletionlog.username AS del_username, deletionlog.reason AS del_reason
    FROM thread AS thread
    LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
    LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1)
    LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
    WHERE thread.threadid IN (0,3095,3019,3075,3081,3070,3016,3042,3052,3037,2988,3020,3003,3030,2934,3034,3022,2948,30 13,2899,2989,2985,3008,2983,2620,2977,2976,2942,2964,2957,2927,2939,2849,2930,2932,2866,30 98)
    ORDER BY sticky DESC, lastpost DESC

    mysql error: Can't open file: 'post.MYI'. (errno: 144)
    mysql error number: 1016
    I'm not sure how it got this, it seem to install fine.
    Last edited by WTFNOOB; Sun 11 Jul '04, 8:27am.

  • #2
    There is a problem with the post table. Backup if you can, then run a repair in your:

    Admin CP -> Import & Maintenance -> Repair / Optimize Tables

    Comment


    • #3
      Everything seems okay:

      postCheckWarning: Table is marked as crashed and last repair failedpostCheckWarning: Size of indexfile is: 39373824 Should be: 1024postCheckError: Can't read indexpage from filepos: -1postCheckError: Corrupt
      But then I got that. I just have to backup?

      Comment


      • #4
        If a repair does not fix the problem then you will need to restore a backup of your database.

        Comment


        • #5
          You sometimes have to run repair more than once to fix all the problems.
          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