PDA

View Full Version : Lỗi Database, khẩn cấp mọi người ơi



MrShare32
03-03-2010, 13:21
The Di?n Đàn Sinh Viên - Trư?ng ĐHKT Hu? database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the forum.hce.edu.vn home page, then try to open another page.
Click the Back button to try another link.
The forum.hce.edu.vn forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.8.2:

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,
spamlog.postid AS spamlog_postid,
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, 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 spamlog AS spamlog ON(spamlog.postid = post.postid)
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 = 45 AND postparsed.languageid = 2)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 45 AND sigparsed.languageid = 2)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)

WHERE post.postid IN (0,86300)
ORDER BY post.dateline;

MySQL Error : Incorrect information in file: '.\hceeduvndb\spamlog.frm'
Error Number : 1033
Request Date : Wednesday, March 3rd 2010 @ 12:02:54 PM
Error Date : Wednesday, March 3rd 2010 @ 12:03:08 PM
Script : http://forum.hce.edu.vn/showthread.php?p=86300
Referrer :
IP Address : 123.19.50.226
Username : MrShare32
Classname : vB_Database
MySQL Version : 5.0.27-community-nt-log

Help me =((...........................

084club
03-03-2010, 13:25
Dùng vB null hả ?

MrShare32
03-03-2010, 13:28
Mình dùng bản 3.82 down ở Vietvbb.vn đó