No announcement yet.

db error message

  • Filter
  • Time
  • Show
Clear All
new posts

  • db error message

    If you go to you see the main forums and topics... however if you click on any of those I get the below error - i ran out of hard drive space and the server crashed ... i freed up space and the ran myisamchk -r *.myi and that ran fine... but i still have the problem below.

    There seems to have been a slight problem with the Hunting Forums database.
    Please try again by pressing the refresh button in your browser.

    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

    We apologise for any inconvenience.

    Invalid SQL:
    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 vb3_thread AS thread
    LEFT JOIN vb3_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
    LEFT JOIN vb3_subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 3)
    LEFT JOIN vb3_post AS post ON(post.postid = thread.firstpostid)
    WHERE thread.threadid IN (0,18483,18496,18536,18619)
    ORDER BY sticky DESC, lastpost DESC

    mysql error: Can't open file: 'vb3_post.MYI'. (errno: 144)
    mysql error number: 1016
    Date: Monday 21st of February 2005 07:44:35 AM
    Username: Dan Jackson
    IP Address:

  • #2
    There is a problem with your vb3_post table. Try running a repair:

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

    You may need to run this multiple times to clear any reported errors.


    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.