Announcement

Collapse
No announcement yet.

Can't post threads

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

  • Eagle Creek
    replied
    Hi Steve,

    with help of a friend (met him on this forum) and Putty I managed to fixed the tables.

    Thanks for your help!

    Leave a comment:


  • Eagle Creek
    replied
    Hi Steve,

    the post is properly fixed now (I guess; cause I get back on the tools.php page). But; when I click a subforum on the homepage I get another error :
    Database error in vBulletin 3.0.3:

    Invalid SQL:
    SELECT
    IF(votenum >= 2, votenum, 0) AS votenum,
    IF(votenum >= 2 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 = 5978)
    LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
    WHERE thread.threadid IN (0,33618,24114,21534,34446,20592,18918,34399,33914,32744,24109,33041,34249,33996,34475,338 55,21163,24955,20733,22808,34295,34417,22282,34468,165,34363,13168,32383,34386,22670,34409 ,33525,22603,22412,28249,34005,22669,12439,34271,34266,34205,34257,34220,31198,21172,31004 ,22165,24695,22268,32499,33922,28397,28995)
    ORDER BY sticky DESC, lastpost DESC

    mysql error: Can't open file: 'post.MYD'. (errno: 144)

    mysql error number: 1016


    Date: Monday 17th of April 2006 11:32:04 AM
    Script: http://www.soccerquest.nl/forum/forumdisplay.php?f=37
    Referer: http://www.soccerquest.nl/forum/index.php
    Username: Eagle Creek
    Last edited by Eagle Creek; Mon 17 Apr '06, 2:38am.

    Leave a comment:


  • Eagle Creek
    replied
    I tried about 4 times now but every time my browser says 'finished'.

    Do I have to try it again and again till it's completed?
    Last edited by Eagle Creek; Mon 17 Apr '06, 2:38am.

    Leave a comment:


  • Steve Machol
    replied
    mysql error: Can't open file: 'post.MYI' (errno: 144)

    MySQL error: 144 = Table is crashed and last repair failed

    You will have to run repair several times to fix all the errors.

    Leave a comment:


  • Eagle Creek
    replied
    It's now even when I try to read a post..

    Database error in vBulletin 3.0.3:

    Invalid SQL:
    SELECT postid, NOT ISNULL(deletionlog.primaryid) AS isdeleted
    FROM post AS post
    LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND type = 'post')
    WHERE threadid = 34504 AND visible = 1
    ORDER BY dateline

    mysql error: Can't open file: 'post.MYD'. (errno: 144)

    mysql error number: 1016

    Date: Sunday 16th of April 2006 03:04:06 PM
    Script: http://www.soccerquest.nl/forum/showthread.php?t=34504
    Referer: http://www.soccerquest.nl/forum/forumdisplay.php?f=22
    Username: Eagle Creek
    I tried to repair the POST table but it doesn't work? My browser just says finished and that's it..
    And: when I've done that, my site is extreme slow.. Almost not reachable.
    Last edited by Eagle Creek; Sun 16 Apr '06, 7:56am.

    Leave a comment:


  • Eagle Creek
    started a topic Can't post threads

    Can't post threads

    Suddenly I only got error after error when I try to make a post?

    Database error in vBulletin 3.0.3:

    Invalid SQL:
    REPLACE INTO postindex
    (wordid, postid, score, intitle)
    VALUES
    (276797, 1466099, 4, 2), (1847, 1466099, 2, 2), (254199, 1466099, 1, 0), (618, 1466099, 1, 0), (1724, 1466099, 1, 0), (2004, 1466099, 1, 0), (6665, 1466099, 2, 0), (684, 1466099, 1, 0), (1767, 1466099, 1, 0), (1638, 1466099, 1, 0), (1045, 1466099, 1, 0), (599, 1466099, 1, 0), (632, 1466099, 1, 0), (11120, 1466099, 1, 0), (95, 1466099, 1, 0), (96, 1466099, 1, 0), (25628, 1466099, 1, 0), (8618, 1466099, 1, 0), (2827, 1466099, 1, 0), (412, 1466099, 1, 0), (13560, 1466099, 1, 0), (500, 1466099, 1, 0), (13966, 1466099, 1, 0), (1423, 1466099, 1, 0), (2935, 1466099, 1, 0), (408, 1466099, 1, 0), (51017, 1466099, 1, 0), (49805, 1466099, 1, 0), (160, 1466099, 1, 0), (409, 1466099, 1, 0), (2594, 1466099, 1, 0), (303, 1466099, 1, 0), (670, 1466099, 1, 0), (69, 1466099, 1, 0), (6692, 1466099, 1, 0), (140184, 1466099, 1, 0), (45064, 1466099, 1, 0), (9065, 1466099, 1, 0)

    mysql error: Can't open file: 'postindex.MYD'. (errno: 144)

    mysql error number: 1016

    Date: Sunday 16th of April 2006 02:48:40 PM
    Script: http://www.soccerquest.nl/forum/newthread.php
    Referer: http://www.soccerquest.nl/forum/newt...newthread&f=43
    Username: Eagle Creek
    IP Address: *
    Also when editting a thread I got errors!

    Can somebody say what to do?
    Last edited by Eagle Creek; Sun 16 Apr '06, 5:52am.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X