vBulletin SEO Forums

SEO

vBulletin Search Engine Optimization

Buy vBSEO Now! HACKER SAFE certified sites prevent over 99.9% of hacker crime.
ne nw
vBSEO Total Support Team Launches DeskPro New vBSEO Discount Level for Network Builders vBSEO 3.2.0 GOLD Has Landed Success with vBSEO = 600ore Web Visitors + $1400 in a Day! Crawlability Inc. Files for SEO Technology Patent
se sw

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 ...

Go Back   vBulletin SEO Forums > vBSEO SEO Plugin > Troubleshooting

home page crashing... home page crashing...

Enhancing 80 million pages.

 Register FAQ Members List Social Groups Calendar Search Today's Posts Mark Forums Read

Reply

 

LinkBack Thread Tools
  #1  
Old 04-14-2007, 07:04 AM
Member
  
Real Name: ---------
Join Date: Mar 2007
Location: Oklahoma
Posts: 60
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.

Quote:
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #2  
Old 04-14-2007, 11:30 AM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
  
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,923
Quote:
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.
Support Team Launches New DeskPro Powered Tool Enhanced Support at Your Service

vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #3  
Old 04-14-2007, 03:58 PM
Member
  
Real Name: ---------
Join Date: Mar 2007
Location: Oklahoma
Posts: 60
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
Reply

« social bookmarking | Jump menus disappear »
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
The vBSEO LinkBacks User Guide - vBSEO 3.0 GOLD Joe Ward General Discussion 25 06-05-2008 12:04 PM


All times are GMT -4. The time now is 03:11 AM.

Contact Us - vBSEO Home - Site Map - Top

Powered by vBulletin Version 3.8.0 Release Candidate 2
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.5 ©2008, Crawlability, Inc.