- 21, Jul 2014
- #1
Помнится Льюви говорила, что коллекционирует ошибки базы данных 
Так вот, при установке хака на денвере часто появляются ошибки, с некоторыми я даже справляться научилась
lush:
Может быть, она и ничем не примечательная, но такое я вижу впервые.:shok:
Специально для Льюви только потому что она говорила о коллекции ошибок БД. Хак во вложении
Так вот, при установке хака на денвере часто появляются ошибки, с некоторыми я даже справляться научиласьlush:
Может быть, она и ничем не примечательная, но такое я вижу впервые.:shok:
Ошибка базы данных в vBulletin 3.8.4:
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
, dbtech_thanks_statistics.*, post.userid, userban.userid AS is_banned, userban.bandate, userban.liftdate, userban.reason, user_who_banned.userid AS user_who_banned_userid, user_who_banned.username AS user_who_banned_username, GROUP_CONCAT(moderator_forum.title_clean ORDER BY moderator_forum.title_clean ASC SEPARATOR '#@_@#') AS moderator_in_forums_titles, GROUP_CONCAT(moderator.forumid ORDER BY moderator_forum.title_clean ASC SEPARATOR '#@_@#') AS moderator_in_forums_ids, last_infraction_level.warning, last_infraction.dateline AS infraction_dateline, last_infraction.expires AS infraction_expires, user_who_infracted.userid AS user_who_infracted_userid, user_who_infracted.username AS user_who_infracted_username, IF(ISNULL(last_infraction_level.points), last_infraction.points, last_infraction_level.points) AS last_infraction_level_points, last_infraction.customreason, last_infraction.infractionid, last_infraction_level.warning AS warning, last_infraction_level.infractionlevelid
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 = 3 AND postparsed.languageid = 7)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 3 AND sigparsed.languageid = 7)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
LEFT JOIN dbtech_thanks_statistics AS dbtech_thanks_statistics ON(dbtech_thanks_statistics.userid = post.userid) LEFT JOIN userban AS userban ON (userban.userid = post.userid)
LEFT JOIN user AS user_who_banned ON (user_who_banned.userid = userban.adminid)
LEFT JOIN moderator AS moderator ON (moderator.userid = post.userid AND moderator.forumid != -1)
LEFT JOIN forum AS moderator_forum ON (moderator_forum.forumid = moderator.forumid)
LEFT JOIN infraction AS last_infraction ON (last_infraction.userid = post.userid)
LEFT JOIN infractionlevel AS last_infraction_level ON (last_infraction_level.infractionlevelid = last_infraction.infractionlevelid)
LEFT JOIN user AS user_who_infracted ON (user_who_infracted.userid = last_infraction.whoadded)
WHERE post.postid IN (0,38,39,40,41,42,43)
GROUP BY post.postid
ORDER BY post.dateline , last_infraction.infractionid DESC;
Ошибка MySQL : Column 'displaygroupid' in field list is ambiguous
Номер ошибки : 1052
Дата запроса : Monday, July 21st 2014 @ 05:59:49 PM
Дата ошибки : Monday, July 21st 2014 @ 05:59:49 PM
Скрипт : http://localka/showthread.php?t=6
Реферер : http://localka/forumdisplay.php?f=5
IP адрес : 127.0.0.1
Имя пользователя : Sue
Имя класса : vB_Database
Версия MySQL : 5.5.25
Специально для Льюви только потому что она говорила о коллекции ошибок БД. Хак во вложении
если срочно - пиши в ЛС
