sublo
12-19-2006, 03:09 PM
Hi All. I need help desperately. My sites are on one colocated virtual server. They were working yesterday. I made no changes. All the vBulletin/vBadvanced Home pages are suddenly down! the http://blaablaablaa.blaa/forums are still up. What happened????
Here are the sites: http://www.camillegerard.com, http://www.stjosephforums.org
Please, please help. MySQL is indeed up and running. I tried restarting the daemon as well as rebooting the server. No luck.
Help!
Here is the error:
Database error in vBulletin 3.6.3:
Invalid SQL:
SELECT 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(2,5)
GROUP BY post.postid
ORDER BY sticky DESC,thread.dateline ASC
LIMIT 10;
MySQL Error : Got error 28 from storage engine
Error Number : 1030
Date : Tuesday, December 19th 2006 @ 12:15:37 PM
Script : http://www.camillegerard.com/
Referrer :
IP Address : 67.154.66.228
Username : Freddy
Classname : vb_database
Here are the sites: http://www.camillegerard.com, http://www.stjosephforums.org
Please, please help. MySQL is indeed up and running. I tried restarting the daemon as well as rebooting the server. No luck.
Help!
Here is the error:
Database error in vBulletin 3.6.3:
Invalid SQL:
SELECT 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(2,5)
GROUP BY post.postid
ORDER BY sticky DESC,thread.dateline ASC
LIMIT 10;
MySQL Error : Got error 28 from storage engine
Error Number : 1030
Date : Tuesday, December 19th 2006 @ 12:15:37 PM
Script : http://www.camillegerard.com/
Referrer :
IP Address : 67.154.66.228
Username : Freddy
Classname : vb_database