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. |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|