| ZomgStuff |
04-01-2007 08:42 PM |
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
Also when i try to visit options in admin cp I get this
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. |
More Information