V
Viuga
Помнится Льюви говорила, что коллекционирует ошибки базы данных :)
Так вот, при установке хака на денвере часто появляются ошибки, с некоторыми я даже справляться научилась:blush:
Может быть, она и ничем не примечательная, но такое я вижу впервые.:shok:
[OFF]Ветер, переименуй тему, если что не так. Специально для Льюви только потому что она говорила о коллекции ошибок БД.[/OFF]
Хак во вложении
Так вот, при установке хака на денвере часто появляются ошибки, с некоторыми я даже справляться научилась:blush:
Может быть, она и ничем не примечательная, но такое я вижу впервые.: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[OFF]Ветер, переименуй тему, если что не так. Специально для Льюви только потому что она говорила о коллекции ошибок БД.[/OFF]
Хак во вложении