Announcement

Collapse
No announcement yet.

any ideas

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

  • any ideas

    does anyone know why my forums suddenly started producing this error ?


    Database error in vBulletin: Invalid SQL:
    SELECT
    session.userid AS sessionuserid,
    post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
    attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
    ,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
    FROM
    post
    LEFT JOIN icon ON icon.iconid=post.iconid
    LEFT JOIN user ON user.userid=post.userid
    LEFT JOIN userfield ON userfield.userid=user.userid
    LEFT JOIN avatar ON avatar.avatarid=user.avatarid
    LEFT JOIN customavatar ON customavatar.userid=user.userid
    LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
    LEFT JOIN session ON (session.userid = user.userid
    AND session.userid > 0

    AND session.lastactivity>992603507)
    WHERE
    post.postid IN (0,65,117,119,126,147,182)
    ORDER BY dateline

    mysql error: Got error 28 from table handler
    mysql error number: 1030
    Date: Friday 15th of June 2001 07:26:47 AM
    Script: /forums/showthread.php?s=&postid=182
    i get this error when i try to view any posts
    url:
    www.doasquad.com/forums/index.php
    running vb 2.01
    Last edited by pestilence; Fri 15 Jun '01, 12:40pm.

  • #2
    See these threads--this error seems to have something to do with corrupted tables, though not always:

    http://www.vbulletin.com/forum/showt...highlight=1030

    http://www.vbulletin.com/forum/showt...highlight=1030

    http://www.vbulletin.com/forum/showt...highlight=1030

    http://www.vbulletin.com/forum/showt...highlight=1030

    http://www.vbulletin.com/forum/showt...highlight=1030

    Yours,

    Andy

    Comment


    • #3
      Try uploading repair.php (found in the 'extras' directory of your vBulletin zip file) to your forums/admin directory, and go to it in a browser just like this:
      mysite.com/forums/admin/repair.php?check=1&html=1
      and see if you see any red blocks. If you do, see if it tried to repair it, and if so if it was successful.

      Comment


      • #4
        thanx

        db sorted and working now thanx

        Comment

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