MySQL Errors, please help (for vb 3.6.0 Beta 3)
hey, i have 2 errors: im one of the admins on syxe.com - free hosting. we were hacked a few days ago and i'm trying to fix it all up, we've had some struggles already, but whenever i go to view a thread i get this error:
1st Error:
Quote:
Database error in vBulletin 3.6.0 Beta 3:
Database error in vBulletin 3.6.0 Beta 3:
Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
postparsed.pagetext_html, postparsed.hasimages,
sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 7 AND postparsed.languageid = 1)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 7 AND sigparsed.languageid = 1)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
WHERE post.postid IN (0,8676,8677,9621,9653,9667,9683,9776)
ORDER BY post.dateline;
MySQL Error : Unknown column 'infractiongroupid' in 'field list'
Error Number : 1054
Date : Friday, August 4th 2006 @ 04:10:54 PM
Script : http://www.syxe.com/showthread.php?p=9776
Referrer : http://www.syxe.com/index.php
IP Address : 81.79.115.226
Username : jackheskett
Classname : vB_Database
|
i am new to the beta 3.
second error:
Quote:
Database error in vBulletin 3.6.0 Beta 3:
Invalid SQL:
SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount, deletedcount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadredirect.expires
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 402 AND canview = 1)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
WHERE thread.threadid IN (0,1663,1628,1627,1606,1598,1599,1096,1070,1069,10 75,1059,1053,1052,1051,1050,1048,1046,1047,1045,97 0)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Table 'syxe58c_sy.threadredirect' doesn't exist
Error Number : 1146
Date : Friday, August 4th 2006 @ 04:12:19 PM
Script : http://www.syxe.com/forumdisplay.php?f=27
Referrer : http://www.syxe.com/
IP Address : 81.79.115.226
Username : jackheskett
Classname : vB_Database
|
please, if any has any solutions or could point me in a direction of a solution, or another thread, it would be greatly apprechiated, thanks!
|