The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Mad SQL problems!
Well I come home and my co-admin tells me there are SQL errors abroad. DB errors that os.
If I click view PM's I get this Code:
Database error in vBulletin 3.6.5: Invalid SQL: SELECT pm.*, pmtext.* , icon.title AS icontitle, icon.iconpath FROM pm AS pm LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid) LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid) WHERE pm.userid=1 AND pm.folderid=0 ORDER BY pmtext.dateline DESC LIMIT 0, 50; MySQL Error : Got error 28 from table handler Error Number : 1030 Date : Sunday, April 1st 2007 @ 02:40:34 PM Script : http://www.zomgstuff.net/forum/private.php? Referrer : http://www.zomgstuff.net/forum/cindex.php IP Address : xxxxxxxxxxxxxx Username : xxxxxxxxxxxxxx Classname : vb_database If I try to open my portal I get this Code:
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 = 31 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(5238,5153) GROUP BY post.postid ORDER BY sticky DESC,thread.dateline DESC LIMIT 100; MySQL Error : Got error 28 from table handler Error Number : 1030 Date : Sunday, April 1st 2007 @ 02:42:07 PM Script : http://zomgstuff.net/forum/ Referrer : IP Address : xxxxxxxxxxxxxx Username :xxxxxxxxxxxxxx Classname : vb_database Code:
Database error in vBulletin 3.6.5: Invalid SQL: SELECT setting.*, settinggroup.grouptitle FROM settinggroup AS settinggroup LEFT JOIN setting AS setting USING(grouptitle) WHERE settinggroup.displayorder <> 0 ORDER BY settinggroup.displayorder, setting.displayorder; MySQL Error : Got error -1 from table handler Error Number : 1030 Date : Sunday, April 1st 2007 @ 02:44:00 PM Script : http://zomgstuff.net/forum/admincp/options.php?null=0 Referrer : http://zomgstuff.net/forum/admincp/index.php?do=nav IP Address : xxxxxxxxxxx Username :xxxxxxxxxxx Classname : vb_database Latest mod that we installed would be write-in poll. |
#2
|
|||
|
|||
Error code 28: No space left on device
One or more partitions on your server is out of space or doesn't have enough space to complete this operation. Shutdown your forums (if you can) and contact your host immediately. You or your host will need to find out which partition is low on space and free up some more space. |
#3
|
|||
|
|||
Thanks, another reason why dot5hosting blows. NEVER buy from them. Site is down all the time.
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|