Tweet
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