mySQL error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • klisis
    Senior Member
    • May 2000
    • 1195

    mySQL error

    What's the problem?
    Code:
    <!-- 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>992346730)
    WHERE
    post.postid IN (0,7927,7929)
    ORDER BY dateline 
    
    mysql error: Got error 28 from table handler
    mysql error number: 1030
    Date: Tuesday 12th of June 2001 08:07:10 AM
    Script: /forum/showthread.php?threadid=1010
    Referer: [url]http://anime-anime.com/forum/forumdisplay.php?forumid=25[/url]
     -->
  • jamez
    Member
    • Feb 2001
    • 68

    #2
    Just noticed you are having the same mysql error.

    Comment

    • klisis
      Senior Member
      • May 2000
      • 1195

      #3
      Nevermind it. It is my host's fault. They let mySQL partition full and let mySQL crashed into hell.

      This has happened twice in a month. I am considering moving off this host.

      If you would like to know what host I am using PM me.

      Comment

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