Dunglx
01-04-2011, 11:08 AM
Diễn đàn mình hôm nay mở lên nhận được tin này (1/4)
Database error in vBulletin 4.1.2:
Invalid SQL:
SELECT thread.threadid, thread.title, thread.prefixid, post.attach,
thread.postusername, thread.dateline, thread.lastpostid, thread.lastpost AS threadlastpost, thread.lastposterid, thread.lastposter, thread.replycount,
forum.forumid, forum.title_clean as forumtitle,
post.pagetext AS message, post.allowsmilie, post.postid,
user.*
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM thread AS thread
INNER JOIN forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN user AS user ON (thread.postuserid = user.userid)
LEFT JOIN cms_nodeinfo AS info ON info.associatedthreadid = thread.threadid
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE 1=1
AND thread.forumid IN(3,124,1,2,4,82,84,43,91,44,47,48,49,50,45,51,12 0,52,53,54,46,121,122,110,5,6,7,8,9,10,11,12,13,14 ,42,60,61,113,114,116,85,76,77,81,78,80,15,35,37,3 6,38,39,40,41,123,16,19,20,21,22,23,24,25,26,17,27 ,28,29,30,18,31,115,32,33,34,103,92,93,94,95,55,56 ,73,118,74,75,57,62,119,63,66,96,105,58,67,68,97,9 8,59,112,109,70,71,69,72,117,88,89,83,99,100,101,8 6,87,104)
AND thread.visible = 1
AND post.visible = 1
AND open <> 10
AND thread.dateline > 1299036832
AND info.associatedthreadid IS NULL
ORDER BY thread.dateline DESC
LIMIT 0,5;
MySQL Error : Table './nguyent1_dunglx/thread' is marked as crashed and should be repaired
Error Number : 145
Request Date : Friday, April 1st 2011 @ 10:33:52 AM
Error Date : Friday, April 1st 2011 @ 10:33:52 AM
Script : http://nguyentrungngan.net/dunglx/forum.php
Referrer : http://nguyentrungngan.net/
IP Address : 113.178.26.96
Username : dunglx
Classname : vB_Database
MySQL Version : 5.0.91-community
Check table nó báo thế này
http://farm3.anhso.net/upload/20110401/11/o/anhso-11407_1.jpg
Bác nào chỉ em phương án tối ưu
Database error in vBulletin 4.1.2:
Invalid SQL:
SELECT thread.threadid, thread.title, thread.prefixid, post.attach,
thread.postusername, thread.dateline, thread.lastpostid, thread.lastpost AS threadlastpost, thread.lastposterid, thread.lastposter, thread.replycount,
forum.forumid, forum.title_clean as forumtitle,
post.pagetext AS message, post.allowsmilie, post.postid,
user.*
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM thread AS thread
INNER JOIN forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN user AS user ON (thread.postuserid = user.userid)
LEFT JOIN cms_nodeinfo AS info ON info.associatedthreadid = thread.threadid
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE 1=1
AND thread.forumid IN(3,124,1,2,4,82,84,43,91,44,47,48,49,50,45,51,12 0,52,53,54,46,121,122,110,5,6,7,8,9,10,11,12,13,14 ,42,60,61,113,114,116,85,76,77,81,78,80,15,35,37,3 6,38,39,40,41,123,16,19,20,21,22,23,24,25,26,17,27 ,28,29,30,18,31,115,32,33,34,103,92,93,94,95,55,56 ,73,118,74,75,57,62,119,63,66,96,105,58,67,68,97,9 8,59,112,109,70,71,69,72,117,88,89,83,99,100,101,8 6,87,104)
AND thread.visible = 1
AND post.visible = 1
AND open <> 10
AND thread.dateline > 1299036832
AND info.associatedthreadid IS NULL
ORDER BY thread.dateline DESC
LIMIT 0,5;
MySQL Error : Table './nguyent1_dunglx/thread' is marked as crashed and should be repaired
Error Number : 145
Request Date : Friday, April 1st 2011 @ 10:33:52 AM
Error Date : Friday, April 1st 2011 @ 10:33:52 AM
Script : http://nguyentrungngan.net/dunglx/forum.php
Referrer : http://nguyentrungngan.net/
IP Address : 113.178.26.96
Username : dunglx
Classname : vB_Database
MySQL Version : 5.0.91-community
Check table nó báo thế này
http://farm3.anhso.net/upload/20110401/11/o/anhso-11407_1.jpg
Bác nào chỉ em phương án tối ưu