Announcement

Collapse
No announcement yet.

Incorrect SQL?

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

  • Incorrect SQL?

    John Bradshaw
    10-17-2001 09:00 AM
    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 user.invisible = 0
    AND session.lastactivity>1003267641)
    WHERE post.postid IN (0,90,93,94,104,112,331,354,1351,1370,1403,1418,5959,5976,5980,5982)
    ORDER BY dateline

    mysql error: Got error -1 from table handler
    mysql error number: 1030
    Date: Tuesday 16th of October 2001 10:42:21 PM
    Script: /forums/showthread.php?postid=5959#post5959


    I keep getting this error, it was working yesterday, it won't work now


    John Bradshaw
    10-17-2001 09:22 AM
    I think my database may be corrupted, how do I fix this?

    I get this error with the database fixing tool:

    Database error in vBulletin: Invalid SQL: CHECK TABLE announcements
    mysql error: You have an error in your SQL syntax near 'CHECK TABLE announcements' at line 1
    mysql error number: 1064
    Date: Wednesday 17th of October 2001 02:08:02 PM
    Script: /forums/repair.php?html=1&check=1&forum=deskpro&iterations=4
    Referer:


    John Bradshaw
    10-17-2001 09:33 AM
    I have managed to narrow the problem down to just showing threads, everything else seems to work fine, including logins etc...

    The error I am gettin is:
    Database error in vBulletin: Invalid SQL:
    SELECT DISTINCT
    session.userid AS sessionuserid,
    announcementid,startdate,enddate,announcement.title,pagetext,user.*,userfield.*
    ,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
    FROM announcement
    LEFT JOIN user ON user.userid=announcement.userid
    LEFT JOIN userfield ON userfield.userid=announcement.userid
    LEFT JOIN avatar ON avatar.avatarid=user.avatarid LEFT JOIN customavatar ON customavatar.userid=announcement.userid
    LEFT JOIN session ON (session.userid = announcement.userid
    AND session.userid <> 0
    AND user.invisible = 0
    AND session.lastactivity>1003324331)
    WHERE startdate<='1003325231' AND enddate>='1003325231' AND (announcement.forumid='3' OR announcement.forumid='1' OR announcement.forumid='-1') ORDER BY startdate DESC
    mysql error: Got error -1 from table handler
    mysql error number: 1030
    Date: Wednesday 17th of October 2001 02:27:11 PM
    Script: /forums/announcement.php?forumid=3
    Referer: http://www.scc-forums.org/forums/for....php?forumid=3


    or

    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>1003324378)
    WHERE post.postid IN (0,3324,5703,5723)
    ORDER BY dateline

    mysql error: Got error -1 from table handler
    mysql error number: 1030
    Date: Wednesday 17th of October 2001 02:27:58 PM
    Script: /forums/showthread.php?threadid=444
    Referer: http://www.scc-forums.org/forums/for....php?forumid=3


    Please help I am really stuck!!

  • #2
    Find repair.php from the 'extras' directory of the vBulletin zip file. Upload it to your main directory and follow the on-screen instructions. In the results, look for any red squares. Does this help at all?

    Comment

    Loading...
    Working...
    X