Hi
my Site Gone Down Because Of MySQL Issuse
their MySQL Version Was 5.0 And I Dont Check And Update Vbulletin to 3.8
Now They Blocekd My Site And Say Chek SQL Log
Sql Log is :
What I Do Now?!?
my Site Gone Down Because Of MySQL Issuse
their MySQL Version Was 5.0 And I Dont Check And Update Vbulletin to 3.8
Now They Blocekd My Site And Say Chek SQL Log
Sql Log is :
Code:
# Fri May 9 05:01:04 2008 # Query_time: 3 Lock_time: 0 Rows_sent: 3 Rows_examined: 13 use bazinama_message; 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=304 AND pm.folderid=0 ORDER BY pmtext.dateline DESC LIMIT 0, 50 # Fri May 9 05:08:05 2008 # Query_time: 2 Lock_time: 0 Rows_sent: 10 Rows_examined: 78 use bazinama_message; 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, editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline, editlog.reason AS edit_reason, editlog.hashistory, 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 editlog AS editlog ON(editlog.postid = post.postid) LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 8 AND postparsed.languageid = 3) LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 8 AND sigparsed.languageid = 3) LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid) WHERE post.postid IN (0,82684,82747,82750,82758,82769,82771,82803,82824,82834,82838) ORDER BY post.dateline # Fri May 9 05:40:38 2008 # Query_time: 2 Lock_time: 0 Rows_sent: 19 Rows_examined: 86 use bazinama_message; 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=407 AND pm.folderid=0 ORDER BY pmtext.dateline DESC LIMIT 0, 50 # Fri May 9 05:40:42 2008 # Query_time: 2 Lock_time: 0 Rows_sent: 2 Rows_examined: 4 SELECT album.*, picture.pictureid, picture.extension, picture.idhash, album.moderation, picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height FROM album AS album LEFT JOIN picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0) WHERE album.userid = 1450 AND album.state IN ('public') AND album.visible > 0 ORDER BY album.lastpicturedate DESC LIMIT 2 # Fri May 9 05:51:04 2008 # Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 0 use bazinama_message; SELECT picture.pictureid, picture.userid, picture.extension, picture.idhash, picture.state, albumpicture.dateline, album.state AS albumstate, picture.thumbnail AS filedata, picture.thumbnail_filesize AS filesize FROM albumpicture AS albumpicture INNER JOIN picture AS picture ON (albumpicture.pictureid = picture.pictureid) INNER JOIN album AS album ON (albumpicture.albumid = album.albumid) WHERE albumpicture.albumid = 162 AND albumpicture.pictureid = 851 # Fri May 9 05:56:22 2008 # Query_time: 3 Lock_time: 0 Rows_sent: 3 Rows_examined: 6 use bazinama_message; SELECT * FROM mailqueue ORDER BY mailqueueid LIMIT 10
Comment