Announcement

Collapse
No announcement yet.

Please help! mySQL error 1030!

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

  • Please help! mySQL error 1030!

    I am being plagued by mySQL error 1030 with my forums, and nothing I do will fix the problem.

    I deleted the entire database, deleted all the vbulletin software, re-installed everything, and within 1 or 2 posts, I suddenly have the problem again.

    My server has PHP 4.0.6 and mysql 3.22.32

    This is the error message I'm getting:

    Database error in vBulletin 2.2.1:

    Invalid SQL:
    SELECT
    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
    WHERE post.postid IN (0,2)
    ORDER BY dateline DESC

    mysql error: Got error -1 from table handler

    mysql error number: 1030

    Date: Sunday 13th of January 2002 08:15:09 PM
    Script: http://www.houseofham.com/forums/for...php?threadid=2
    Referer: http://www.houseofham.com/forums/for....php?forumid=4


    Please HELP!

    - Pahbi

  • #2
    Error -1 usually means MySQL doesn't know what the heck is going on.

    I'd say your webhost has a problem, possibly shutting down the server frequently without closing MySQL, but I have no idea.

    Comment


    • #3
      What is frustrating is I can run other mySQL applications like phpMyAdmin and can query the database manually, except for that one particular query.

      I can click on my name and it brings up my user panel, in fact, I can do anything except read/post messages.


      - Pahbi

      Comment


      • #4
        upgrade mysql from 3.22.32 to 3.23.47 if you can might be bugs in mysql itself in earlier versions
        :: Always Back Up Forum Database + Attachments BEFORE upgrading !
        :: Nginx SPDY SSL - World Flags Demo [video results]
        :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

        Comment

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