Results 1 to 3 of 3

home page crashing...

This is a discussion on home page crashing... within the Troubleshooting forums, part of the vBSEO SEO Plugin category; I don't think that my issue has anything do to with vbSEO , but I am still having trouble and ...

  1. #1
    Member
    Real Name
    ---------
    Join Date
    Mar 2007
    Location
    Oklahoma
    Posts
    60
    Liked
    0 times

    home page crashing...

    I don't think that my issue has anything do to with vbSEO, but I am still having trouble and need help. My home page does not work anymore. Any ideas where to start? I can't figure out why it would suddenly break.

    Database error in vBulletin 3.6.5:

    Invalid SQL:

    SELECT IF(votenum >= 1, votenum, 0) AS numbvote, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg, thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastpostid, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext, allowsmilie,
    thread.iconid AS threadiconid, iconpath AS threadiconpath,
    avatarpath, NOT ISNULL(customavatar.filedata) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision,
    NOT ISNULL(subscribethread.subscribethreadid) AS subscribed

    FROM thread AS thread
    LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
    LEFT JOIN postparsed AS postparsed ON (postparsed.postid = post.postid AND postparsed.styleid = 1 AND postparsed.languageid = 1)
    LEFT JOIN icon AS icon ON (icon.iconid = thread.iconid)
    LEFT JOIN user AS user ON (user.userid = post.userid)
    LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
    LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid)
    LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
    WHERE thread.threadid IN(1414,1241,1237,1182,1059,1052,1011,951,934,851, 838,738,734,654)


    GROUP BY post.postid
    ORDER BY sticky DESC,thread.dateline DESC
    LIMIT 14;

    MySQL Error : Got error 28 from table handler
    Error Number : 1030
    Date : Saturday, April 14th 2007 @ 04:23:39 AM

    Username :
    Classname : vb_database
    Last edited by BrettMo; 04-14-2007 at 07:20 AM.

  2. #2
    vBSEO Staff Oleg Ignatiuk's Avatar
    Real Name
    Oleg Ignatiuk
    Join Date
    Jun 2005
    Location
    Belarus
    Posts
    25,689
    Liked
    157 times
    MySQL Error : Got error 28 from table handler
    Hello,

    try vB admincp->Maintenance->Repair / Optimize Tables to resolve db table issue.
    Oleg Ignatiuk / Crawlability Inc.
    vBSEO 3.6.0 GOLD Released!
    Unveiling the NEW vBSEO Sitemap Generator 3.0. - available NOW for vBSEO Customers!


  3. #3
    Member
    Real Name
    ---------
    Join Date
    Mar 2007
    Location
    Oklahoma
    Posts
    60
    Liked
    0 times
    Thanks Oleg for giving it a shot. I found the answer here: mysql error: Got error 28 from table handler (error number 1030) - vBulletin Community Forum It was a server space issue that the host had to resolve.
    Last edited by BrettMo; 04-21-2007 at 03:20 AM.

Similar Threads

  1. The vBSEO LinkBacks User Guide - vBSEO 3.0 GOLD
    By Joe Ward in forum General Discussion
    Replies: 49
    Last Post: 09-20-2011, 08:10 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •